Variable File names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to automatically create a new folder and spreadsheet file that
will be named the value of a query field as the folder name and filename?

i.e. a design number field. Have each design output to a spreadsheet file
with it's design number as the file name within a folder with the design
number as the folder name?
 
To create a new folder, you will want to use the MKDIR command. See VBA Help
for details.

You don't need to create a file name when you use TransferSpreadsheet to
create an xls file, if the file name exists, it will overwrite the existing
file. If it does not, it will create the file. You can use a variable that
contains the path and name of the file you want to save the spreadsheet as.
 
Back
Top