TransferSpreadsheet Method

[Pap]

I am trying to use the TransferSpreadsheet method in a pretty basic way, but
I want the FileName element to be a variable where the User picks up the file
from an explorer box (in the same way that ImportHyperlink kind of works). I
know that I need to give the directory a string name and insert this name
into the method, but I don't know what the code is to create that string
directory. Can someone help please?

Thanks,

Paul

 

[orange via AccessMonster.com]

I am trying to use the TransferSpreadsheet method in a pretty basic way, but
I want the FileName element to be a variable where the User picks up the file
from an explorer box (in the same way that ImportHyperlink kind of works). I
know that I need to give the directory a string name and insert this name
into the method, but I don't know what the code is to create that string
directory. Can someone help please?

Thanks,

Paul

You might want to look at this
http://msdn.microsoft.com/en-us/lib...).aspx#odc_offilesfolders_thefiledialogobject

 

[orange via AccessMonster.com]

I am trying to use the TransferSpreadsheet method in a pretty basic way, but
I want the FileName element to be a variable where the User picks up the file
from an explorer box (in the same way that ImportHyperlink kind of works). I
know that I need to give the directory a string name and insert this name
into the method, but I don't know what the code is to create that string
directory. Can someone help please?

Thanks,

Paul

You might want to look at this
http://msdn.microsoft.com/en-us/lib...).aspx#odc_offilesfolders_thefiledialogobject

 

[Ken Snell]

See these articles:

Browse to a single EXCEL File and Export Data to that EXCEL File via
TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#ExpBrowseFile


Browse to a single EXCEL File and Import Data from that EXCEL File via
TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#ImpBrowseFile