Excel and Publisher

[texasaswang]

I am reaching here, hoping for a lifeline.

Is it possible to use Excel 07 VBA to automate publishing to a website of a publisher document?

-Thanks in advance!

-Tex

 

[texasaswang]

Ok, I found a partial solution. I can script the save portion. However, when I open this .pub document, it asks me if I want to update the hyperlinks. This has to be cleared by clicking yes.

Any suggestions?

Sub PublishDoc()

With ActiveDocument
    .SaveAs Filename:="http://lebg/sites/fab2/process_eng/rda/RDA Web Page Files/RDA_Main_Test", Format:=pbFileHTMLFiltered
End With
End Sub