Find excel file for import

[ali32j]

Hi All

I want to use the following code to import a spreadsheet

DoCmd.TransferSpreadsheet acImport, 8, "Yourtablename", "filepath of spreadsheet", True, "Sheet2!A1:E273"

Is it possible to change the "your table name" to pop up a dialog box to locate the file??

your help is much appreciated

thanks

Ali

 

[combo]

You could use vba InputBox function and string variable to store and validate input.

combo

 

[StarPassing]

The code in the link below shows how to pop a dialog box for the user to select a file. It returns the path and file name selected.

http://support.microsoft.com/kb/824272

Tom

 

[ali32j]

thanks for your help much appreciated