Macro problem

[1HulkHogan]

I recently saved a excel spreadsheet as a .htm file. I have some macros in the Excel spreadsheet but they don't work in the .htm file. How do I get the macro to work in the .htm? Any help would be most helpful.

Thanks

 

[mvptomlinson]

Macros won't work in a .htm file. HTM files are web pages and are, essentially, plain text files that Excel can read and write. When double clicked, they open in your web browser and you can view the source code (text) that generates the page.

You would need to re-save the file in XLS (or XLSM) format - although I think saving as HTM strips out any VBA code, so I hope you have an original copy.