Selecting and Importing .xls files at runtime

[shanedavid1981]

Hi guys,

I haven't done this for a while, and thought I would try asking here first... how would I be able to call the windows Open File dialog box to select an xls spreadsheet for access to append to a table at runtime?

)

 

[Remou]

Hi
Have you seen this thread705-760625? It might help.

 

[PHV]

Have a look at the Application.FileDialog object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886