ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Saving question (https://www.excelbanter.com/excel-discussion-misc-queries/15825-saving-question.html)

Greg B

Saving question
 
How do I get a macro to create a new folder and save 3 different files into
it.

I can get the autosave to work but not quite sure on how to save into a new
directory or even if you can??\

Thanks again

Greg



R.VENKATARAMAN

actually create a macro for this and you can modify it as vba

Greg B wrote in message
...
How do I get a macro to create a new folder and save 3 different files

into
it.

I can get the autosave to work but not quite sure on how to save into a

new
directory or even if you can??\

Thanks again

Greg





Bob Phillips

Do you mean move 3 files from an existing directory to this new one, or copy
them across?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Greg B" wrote in message
...
How do I get a macro to create a new folder and save 3 different files

into
it.

I can get the autosave to work but not quite sure on how to save into a

new
directory or even if you can??\

Thanks again

Greg






All times are GMT +1. The time now is 05:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com