[AccessD] Urgent help please - Can't open html page inFrontpagefrom Access form

Hi Donald - thanks for the reply. I didn't know that there was an FP html editor as opposed to normal FP- that would certainly solve the problem as these pages will also be very simple - I will look further into that. Thanks

Kath

----- Original Message ----- 
  From: Mcgillivray, Donald [ITS] 
  To: Access Developers discussion and problem solving 
  Sent: Saturday, September 18, 2004 2:05 AM
  Subject: RE: [AccessD] Urgent help please - Can't open html page inFrontpagefrom Access form


  Firstly, I have only passing familiarity with Front Page and web stuff -
  DEFINITELY no kind of expert!  But since you seem to be in a similar
  situation, maybe my experience will prove useful.

  In FP 98 (newer versions may be different) the html editor is a separate
  application that can be run independently from the FP web designer
  interface.  Since my ISP doesn't support FP extensions at my
  subscription level, I just use the FP editor (not the web designer) to
  create pages (VERY simple ones, to be sure) and upload them via FTP to
  my web space.  Basically, the FP html editor allows you to open, edit
  and save ANY html doc to ANY place you please - doesn't have to be a
  part of a "Front Page web" at all.  Things could get a little tricky if
  the html doc contains hyperlinks to other pages within the web site - in
  my situation I mimic the directory structure of my web space on my PC,
  and make any hyperlinks relative to the page location - and I have no
  idea what happens if you just slip a page into a FP web thru the "back
  door" (does the FP web automatically 'know' the new page is there, or do
  you have to use the web designer to make it available?) 

  All this having been said, I don't know whether the FP html editor (as
  distinct from the web designer) has an exposed object model that you can
  automate from your VBA code (I'm at work and my FP is installed at home)
  but if it does, you ought to be able to open and work a document
  independent of any web specs and then move it to the web via a separate
  process when the user is finished.

  Hope this helps!

  Don McGillivray



  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kath Pelletti
  Sent: Monday, September 13, 2004 6:13 PM
  To: AccessD at databaseadvisors.com
  Subject: [AccessD] Urgent help please - Can't open html page in
  Frontpagefrom Access form


  I have wasted ages on this so am now begging assistance........

  I have an html file (empty at present - later it will have some basic
  text)

  I need to my code to 
  - Make a copy of the template.html file (I can do that) and 
  - give it a new name, eg. Template_BHP_140904.html (I can do that)
  - Open the html file just created in Frontpage for users to modify the
  document (That's where I'm stuck....)

  My problem is a total lack of knowledge of files vs. webs and therefore
  the syntax I need. Questions: - 

  - Do I have to have a 'web' or 'web folder' - can't I just have an html
  file and open it?

  - If I can, what is the alternative syntax to .webs.open - eg. I am
  looking for a .pages.open property or .files.open ?

  Here's my code so far - when I run it I get an error  - There is no web
  named "/E:/SDS/Clients/CPP/WebLetters/Template.html"


  ------------------------------------------------------------------------
  --------

  Private Sub CmdOpenFP_Click()

  Dim oFPweb As FrontPage.Web
  Dim oFP As FrontPage.Application
  Dim FrontPageRunning As Boolean

  'Determine whether FrontPage is alredy open or not
  FrontPageRunning = IsFrontPageRunning()

  If Not FrontPageRunning Then
      MsgBox ("Frontpage is Closed")
      Set oFP = CreateObject("Frontpage.Application")
  Else
      MsgBox ("Frontpage is already open")
      Set oFP = GetObject(, "Frontpage.Application")
  End If

  'add code here later to make a copy of my file

  'open file in front page------------------------------------------------
  oFP.Webs.Open ("E:\Sds\Clients\CPP\Webletters\template.html")
  'STUCK HERE

   ' Show FrontPage
   oFPweb.Activate
   'Set oFP = Nothing

  End Sub

  ------------------------------------------------------------------------
  --------

  TIA


  Kath Pelletti
  Software Design & Solutions Pty Ltd.
  Ph: 9505-6714
  Fax: 9505-6430
  KP at SDSOnline.net
  -- 
  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
  -- 
  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com