Sheets to web VBA

[RobbMiller]

How would I use VBA to save each sheet in a workbook as a separate .htm file where the name of the .htm is derived from a cell value? I was thinking something like the code below should work, but I am quite sure I have blown the syntax.

Please Login or Register  to view this content.

[mudraker]

RobbMiller

Please read forum rules & wrap your VBA code - see links below for rules

If you do not understand the VBA code wrap instructions have a look at my last reply in this thread
http://www.excelforum.com/showthread.php?t=583950

[RobbMiller]

first of all... thanks for the warm welcome.

secondly, the above was not really code as much as it was a thought about code.

thirdly i Have solved the problem.

Please Login or Register  to view this content.

thanks for all the help