macros and wizards


Posted by G. Seager on January 10, 2002 10:08 AM

Is there any way to incorporate an excel wizard in a macro....specifically the "save as HTML" wizard? I need to update html pages from an excel spreadsheet weekly, always the same cell ranges on each sheet. It is a repetitive process I would like to automate.



Posted by Aemilia on January 10, 2002 2:23 PM

See whether this helps :-
http://www.microsoft.com/exceldev/articles/convhtml.htm