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
 
C

Chris O'C via AccessMonster.com

Use this:

DoCmd.RunCommand acCmdImport

When the import dialog comes up, change the "files of type" to "Microsoft
Excel (*.xls)" then choose your xls file to import.

Chris
 
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!
 
C

Chris O'C via AccessMonster.com

Sorry, there's no built in command.

Chris


Tony said:
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?
Click to expand...
 

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

Starting Export wizard 0
Program buttons to create a word document 0
Office365 Family + TXT or MX Domain 0
Setting a default zoom in Infopath 0
Can I automate the import of a text file? 2
Print Excel files from a BAT file. 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Clearing Fields in a Word Form 5

Top