By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,662 Members | 1,765 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,662 IT Pros & Developers. It's quick & easy.

Import text/spreadsheet using code and wizard

P: n/a
Bob
Hi all,

I'm trying to use code to start the text/spreadsheet import wizard
because my file will change all the time and so I can't define a spec
for it - I want the user to define everything. So, my code is:

CommandBars("Menu Bar"). _
Controls("File"). _
Controls("Get External Data"). _
Controls("Import..."). _
accDoDefaultAction

Which starts up the wizard, but once I have selected the file I want
then it comes up with the following error:

Microsoft Access can't find the wizard. The wizard has not been
installed, or there is an incorrect setting in the windows registry,
or the wizard has been disabled.

Does anyone have any suggestions about how to fix this problem?

Feb 6 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.