Command Button to start import

T

Tony Williams

Can anyone provide me with the code I would need to put behind a commnad
button on a form to start the import spreadsheet wizard?
Thanks
Tony
 
T

Tony Williams

Thanks for such a quick response Chris. That worked just fine. Is there
anyway I can force it to show Excel files only in the files to open box?
Cheers
Tony
PS Happy New Year!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I automate the import of a text file? 2
Creating an Import Spec – Advance button missing? 5
Importing CSV file through Import Wizard but storing filename & location 3
Automating an Excel import 4
Import from Excel - Subscript out of range 2
Import Excel File into Access DB where user can specify file name andcell range to import 1
Can't see the advanced button when importing?? 1
Adding a reference field to imported spreadsheet table 3

Top