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

See these articles:

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


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


--

Ken Snell
http://www.accessmvp.com/KDSnell/



"Pap" <(E-Mail Removed)> wrote in message
news:582321AF-D5AF-493C-8DFA-(E-Mail Removed)...
>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