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!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Use of "Republish: Sheet" feature in "SaveAs" function...

Status
Not open for further replies.
BluByU

BluByU

IS-IT--Management
Jul 29, 2003
35
0
0
US
Is there any way in VBA Excel 2002 to use the "Republish: Sheet" feature when saving the active worksheet as an "html" formatted file? The online help for the "SaveAs" doesn't show this feature as available. Any suggestions? Thanks in advance.
 
Sort by date Sort by votes
Have a look at the PublishObjects collection.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kapok1
  • Locked
  • Question
how to use vba to forbid "Worksheet Menu Bar" being selected
Replies
6
Views
114
kapok1
kapok1
NewbieMacro
  • Locked
  • Question
Hello, I have a sheet named "Fin
Replies
2
Views
61
NewbieMacro
NewbieMacro
IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
95
Andrzejek
Andrzejek
MattGreer
  • Locked
  • Question
Using A Boolean in a Calc, and setting a variable = "0" 3
Replies
6
Views
79
SkipVought
S
Andrzejek
  • Locked
  • Question
Data Type in ADODB.Recordset
Replies
6
Views
146
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top