save all sheets as separate text files

Hi,

I have a workbook with 45 sheets and I am looking for a script to save all sheets as separate text files. The script should take the "save as" file names from the sheet names.

Although they should be saved as text files, the extension is php as given in the sheet names.

Unfortunately I've been out of practice for years with Excel VBA macros of this deepth, so I would highly appreciate some help for the above!

Thanks a lot, Minnesaenger

The following will save all sheets to the same folder as the current file. If the current file hasn't been saved, the files will be saved in the default file location as set in your options.

Please Login or Register  to view this content.

mdbct, the script runs flawlessly, thank you very much for your help!!

JBeaucaire, thanks a lot, I'll look around your site!

JBeaucaire. thanks for solution