L
Lara
Ultimately I am trying to automate the creation of about 50 from a table
spreadsheets with out "hardcoding" the file name.
I have a table driven list of names that I want to use as file names or as
table names. I am saving these out to spreadsheets so the alternative would
be to dynamically name the spreadsheet files as I export but I do not know
how to complete the file name box in the transfer spreadsheet macro function
where it will pick up the value. I thought about the outputTo function in a
macro but there are three tables that will be saved out to the file and the
OutputTo function replaces the file vs adding an a new tab.
Any help is apprciated.
spreadsheets with out "hardcoding" the file name.
I have a table driven list of names that I want to use as file names or as
table names. I am saving these out to spreadsheets so the alternative would
be to dynamically name the spreadsheet files as I export but I do not know
how to complete the file name box in the transfer spreadsheet macro function
where it will pick up the value. I thought about the outputTo function in a
macro but there are three tables that will be saved out to the file and the
OutputTo function replaces the file vs adding an a new tab.
Any help is apprciated.