TransferSpreadsheet

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

I have a macro TransferSpreadsheet that imports my data.
What I would like to do is have the details for the File
Name to come from a field in a table.
The table is called tbDefaults and the field is
File_Location. This is because I get data from different
servers, eg G:\Crushing Shedules\Backlog\BACKLOG.xls. So
to select a different file location I can look it up and
then refresh.

I hope this is do-able.
Regards
Nick
 
For the File Name argument, use an expression involving the DLookup
function:

=DLookup("FileNameField", "TableName")

The above can be modified to include a WHERE clause's expression for
filtering the result.
 
Back
Top