Publishing with Publisher 2003

Publishing with Publisher 2003

Hi,

I'm new on web design, so may be my question is a silly question, but I 
can't see clear how to publish my web.

I already did my web page, static web, and it works fine 
http://www.telefonica.net/web2/vilacardona
but all it has is images and links.

Problem comes to me when I want to (via VBA) read a file 'all-sensors.xml', 
wich is placed in a folder of this provider (www.telefonica.net), and process 
some info from it. Then  with the results I fill a text.frame and show it in 
the page. This works fine when I do this publising my web in my own system 
(PC), but when if I upload this index.htm, obviously, OPEN sentence crashes, 
because looks for c:/.....

Ed Bennet told me I can't use OPEN when URL or HTTP is in the path.

My actions are:
1. Create/edit a myproject.pub in my file
2. Publish it
3. FTP index.htm to my web folder
So, I understand index.htm needs to be in my providers folder, but then I 
don't know how to OPEN 'all-sensors.xml' file (which, as said, is in same 
folder updated every 5 minutes)

Is wrong my approach? Where has to be placed myproject.pub? 

Here i publish lines of code involved:
...
    Set pbShape = ThisDocument.Pages(1).Shapes(24)
    'tit = ThisDocument.Path & "all-sensors.xml"
    'Open tit For Input As #1
    Open "c:\all-sensors.xml" For Input As #1
    col = 0
    res = ""
    Line Input #1, strTest
...
    pbShape.TextFrame.TextRange.Text = res
....

sharon

date: Fri, 30 May 2008 01:21:01 -0700 author: sharon

Re: Publishing with Publisher 2003

Ed Bennet is the expert when it comes to using VBA, and if he says that what 
you want to do can't be done, then it is likely it can't. To my knowledge 
the use of VBA is limited to Publisher files on a local computer, not a web 
page.

Publisher produces static sites, and it sounds like you are looking for 
dynamic functionality that is beyond the capability of Publisher. To update 
Publisher webs, you make the changes in the Pub file, produce new web pages, 
and upload those. There is no way to automate that process to my knowledge. 
If you want your pages to be dynamically updated, then you probably need to 
look at a server side solution. Sorry.

DavidF

"sharon"  wrote in message 
news:6A73034E-B91B-44A3-941F-DD24FAD03010@microsoft.com...
> Hi,
>
> I'm new on web design, so may be my question is a silly question, but I
> can't see clear how to publish my web.
>
> I already did my web page, static web, and it works fine
> http://www.telefonica.net/web2/vilacardona
> but all it has is images and links.
>
> Problem comes to me when I want to (via VBA) read a file 
> 'all-sensors.xml',
> wich is placed in a folder of this provider (www.telefonica.net), and 
> process
> some info from it. Then  with the results I fill a text.frame and show it 
> in
> the page. This works fine when I do this publising my web in my own system
> (PC), but when if I upload this index.htm, obviously, OPEN sentence 
> crashes,
> because looks for c:/.....
>
> Ed Bennet told me I can't use OPEN when URL or HTTP is in the path.
>
> My actions are:
> 1. Create/edit a myproject.pub in my file
> 2. Publish it
> 3. FTP index.htm to my web folder
> So, I understand index.htm needs to be in my providers folder, but then I
> don't know how to OPEN 'all-sensors.xml' file (which, as said, is in same
> folder updated every 5 minutes)
>
> Is wrong my approach? Where has to be placed myproject.pub?
>
> Here i publish lines of code involved:
> ...
>    Set pbShape = ThisDocument.Pages(1).Shapes(24)
>    'tit = ThisDocument.Path & "all-sensors.xml"
>    'Open tit For Input As #1
>    Open "c:\all-sensors.xml" For Input As #1
>    col = 0
>    res = ""
>    Line Input #1, strTest
> ...
>    pbShape.TextFrame.TextRange.Text = res
> ....
>
> sharon
>

date: Fri, 30 May 2008 08:43:44 -0700 author: DavidF

Re: Publishing with Publisher 2003

Thanks DavidF,

It's a pitty and almost unbelievable... but many thanks.

sharon

"DavidF" wrote:

> Ed Bennet is the expert when it comes to using VBA, and if he says that what 
> you want to do can't be done, then it is likely it can't. To my knowledge 
> the use of VBA is limited to Publisher files on a local computer, not a web 
> page.
> 
> Publisher produces static sites, and it sounds like you are looking for 
> dynamic functionality that is beyond the capability of Publisher. To update 
> Publisher webs, you make the changes in the Pub file, produce new web pages, 
> and upload those. There is no way to automate that process to my knowledge. 
> If you want your pages to be dynamically updated, then you probably need to 
> look at a server side solution. Sorry.
> 
> DavidF
> 
> "sharon"  wrote in message 
> news:6A73034E-B91B-44A3-941F-DD24FAD03010@microsoft.com...
> > Hi,
> >
> > I'm new on web design, so may be my question is a silly question, but I
> > can't see clear how to publish my web.
> >
> > I already did my web page, static web, and it works fine
> > http://www.telefonica.net/web2/vilacardona
> > but all it has is images and links.
> >
> > Problem comes to me when I want to (via VBA) read a file 
> > 'all-sensors.xml',
> > wich is placed in a folder of this provider (www.telefonica.net), and 
> > process
> > some info from it. Then  with the results I fill a text.frame and show it 
> > in
> > the page. This works fine when I do this publising my web in my own system
> > (PC), but when if I upload this index.htm, obviously, OPEN sentence 
> > crashes,
> > because looks for c:/.....
> >
> > Ed Bennet told me I can't use OPEN when URL or HTTP is in the path.
> >
> > My actions are:
> > 1. Create/edit a myproject.pub in my file
> > 2. Publish it
> > 3. FTP index.htm to my web folder
> > So, I understand index.htm needs to be in my providers folder, but then I
> > don't know how to OPEN 'all-sensors.xml' file (which, as said, is in same
> > folder updated every 5 minutes)
> >
> > Is wrong my approach? Where has to be placed myproject.pub?
> >
> > Here i publish lines of code involved:
> > ...
> >    Set pbShape = ThisDocument.Pages(1).Shapes(24)
> >    'tit = ThisDocument.Path & "all-sensors.xml"
> >    'Open tit For Input As #1
> >    Open "c:\all-sensors.xml" For Input As #1
> >    col = 0
> >    res = ""
> >    Line Input #1, strTest
> > ...
> >    pbShape.TextFrame.TextRange.Text = res
> > ....
> >
> > sharon
> > 
> 
> 
>

date: Fri, 30 May 2008 09:39:02 -0700 author: sharon