Sendkeys not working in 2007

S

Sarah

I have a database I created in access 2003 that I open up in 2007. I went to
the trust center and allowed all macros and listed the location of my
database under trusted locations. The macro let's me select the sendkeys
command. This is the list of commands:

SENDKEYS {TAB}
SENDKEYS E
SENDKEYS E
SENDKEYS E
SENDKEYS {ENTER}
RunCommand Import

The purpose is to change the File type to Excel 97-2003 Workbook (*.xls) and
it doesn't do that. It runs the import command and then stops there.

Any suggestions?

Thank you.

Sarah
SENDKEYS {TAB}
SENDKEYS {ENTER}
 

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

Top