TransferSpreadsheet question

[hedrew3]

Using Access 2000, I have a macro where I would like to transfer in a
spreadsheet using the TransferSpreadsheet function. However, I do not
know the name of the file beforehand, so I can not hardcode it into
the TableName property of the Action Arguments.

I would simply like to have the FindFile dialog box pop up when the
macro reaches this point, so that I can navigate to the appropriate XL
file. Is this possible to do?

TIA,

Pete

 

[Van T. Dinh]

If you know VBA, use:

http://www.mvps.org/access/api/api0001.htm