Macro to 'save as' in a specific folder

Hi all,

I have spreadsheets that are completed 2x daily, then a report is run from them (creating another sheet in the spreadsheet). Once this is done, I want to assign a macro to a button to pop up a 'save as' window, prompting them to save it in a folder of my choosing.

Workbook attached - TIA

Use:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I have added a button to your worksheet and attached the following code - this will copy the report into a new workbook which you then can save in directory of your choice and name it what ever you want.

Please Login or Register  to view this content.

You simply browse to the folder - when the file save dialogue comes up you can select any folder you want. When you hit the save button you can use the Windows explorer box just like you normally would when saving a file in excel. It may default to a directory however you can change the directory to where ever you want. You can also make the filename what ever you want.

If you want change the macro to the following - it will default then to "Z:\FireOperations\Shift Reports\Unprocessed\"

Please Login or Register  to view this content.

See my post just before your last post - I added in a change directory command so it will default to "Z:\FireOperations\Shift Reports\Unprocessed\"

Change it to

Please Login or Register  to view this content.

Nuts - spoke too soon...I am trying to use this is Excel 2003

Sorry - my fault - this will work with Excel 2003 - I have place a button on your workbook and attached the macro - Changed your code so the active page after running the report is A-1 - you can change that back if you want.

Please Login or Register  to view this content.

If you want to close the report automatically after saving just add in after the save a Close command.

Please Login or Register  to view this content.