TransferSpreadsheet

[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

 

[Ken Snell [MVP]]

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.

 

[Nick]

Thanks again Ken,
This is the second time today you have helped me out.

Regards
Nick

 

[Ken Snell [MVP]]

You're welcome... and we're not counting! ;-)