Save all open workbooks to a specified folder

Hello,

I want to create a macro that will save all open workbooks (not including the active workbook) to a specified folder.

basically, I will open approx 5 - 10 workbooks from email attachments, then on my master sheet, I click a command button, and it should save all the opened attachements to a folder.

can anyone assist please?



thanks,

mike.

Worked exactly as I hoped it would.

Thankyou very much for your solution.

I have 1 more question, (not sure if I should raise another thread for it)


I now have 2 buttons on my master sheet. 1 for saving the workbooks (thanks to you) and another button to list the workbooks as hyper links in my active workbook.

If I wanted to combine these 2 buttons into 1 button that does both jobs, could I do that? would there be much tweaking of the code? or could I simply amalgamate the 2 macros?

here are the 2 macros;

Please Login or Register  to view this content.

and;

Please Login or Register  to view this content.

can anyone assist with combining these 2 macros into one?

hi Arlette,

I get a "Run-time error '438' Object doesn't support this property or method on line;

Please Login or Register  to view this content.

Please Login or Register  to view this content.

im getting the same "Run-time error '438' Object doesn't support this property or method" on the above line now.

Sorry for being a pain. Your help is greatly appreciated.

Absolutely perfect.

we got off on a bad start, but I am now forever in your debt.

again, Sincere thanks for this.

this has cut my workload from about 1 hour per day, to about 30 seconds per day.


thank-you.