Save as .xlsx and .txt

[MarcoNecroX]

Hi all!

I would like to make a macro that saves the current sheet as .xlsx (normal file) but also creates a .txt savefile (automatically override, if one exists).
I'm not sure if it would be possible to make this macro get activated by the normal Ctrl+S command, or if I simply need to run the macro separatedly (via button for example)

Thanks!!

[fredlo2010]

Hello,

Place this code in a module under your personal workbook. If you need help with your personal workbook look here http://www.rondebruin.nl/win/personal.htm

Its better if you add another set of keys to the macro. (Ctr+Shift+S)

Please Login or Register  to view this content.

thanks

[MarcoNecroX]

Thank you!!