[AccessD] Urgent help please - Can't open html page in Frontpagefrom 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