Macro not working for other workbooks

Hi.

Below is a code which I added to my 'Quick access toolbar' (and which is based off a hidden workbook). I use this macro to fulfill tasks to regular excel spreadsheets that are not macro enabled, however, I can't seem to get this macro to work for other workbooks. I would appreciate if anyone can modify my code to work for other spreadsheets.

Thank you.

Please Login or Register  to view this content.

open the desired workbook first so you can work on it

My question is based off open work books. I'm looking to modify the code to work for any work book and not just the one which it originates from. With the original workbook this macro works fine.

Hi,

Your problem is probably the following line:

Please Login or Register  to view this content.

You macro enabled spreadsheets are probably of type '.xlsm'.

Identifying the extension of the workbook first such as:

Please Login or Register  to view this content.

Please let us know if you need additional help implementing the fix.

Lewis

Here is additional information (using a working example) about using 'SaveAs' tested using Excel 2003.

Lewis

Please Login or Register  to view this content.