Output File to a different path

[cjinls]

I would like to use a macro to export tables in Excel. There are 14 spreadhseets every two weeks that will be exported. I know how to export them with a macro, but is there a way to use a form or something to change the folder that these files will be exported to? Basically, every two weeks, I want these files to go to a new folder but I don't want to have to go to each lne in the macro and update the folder name. Can a form be used to enter the folder name before the macro is ran?

I would appreciate any advice anyone may have.

 

[SpentGeezer]

Hey, use a dialog box to get the folder. See attached example which calls a function for the get folder dialog