| | | Sarah |  |
|  Posted: Tue Sep 02, 2008 4:18 pm Post subject: Sendkeys not working in Access 2007 |  |
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 |
|
