Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Script to save as web page but remain in workbook
This helps, thank you. I have tried using PublishObjects(1) and I get a 1004 error. I tried using 0, 2, 3, 4 as well with no success. I am glad the number is static but when is it assigned exactly? Can I set it to what I want? I seem to find these thing out by accident but I feel I am...- xphile2
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Script to save as web page but remain in workbook
I have this vba script (see line below with --->) that publishes your workbook to a single file web page (*.mht). I had problems with the Activeworkbook.PublishObjects command below a little bit. My first question is why wouldn't "ActiveWorkBook.PublishObjects(1)" work instead? 2nd question is...- xphile2
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
