Want to use sendkeys in Outlook to open Excel file

R

ricebubbles

I have a form in Outlook that I have saved the data from as a .txt file. I
want to get the VBscript code in Outlook to activate Excel (which I have
done) and open a spreadsheet. I can't use the normal openfile commands as the
spreadsheet has an Auto_Open macro in Macro4 language that I want to kick off
when the file is opened. Using the fileopen command supresses the Auto_Open
feature. To bypass this I want to use Sendkeys. This works up until the Open
shell is created and then my Excel.sendkeys commands fail. What do I send my
sendkeys command to insert the filepath I wish to have opened?
 

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

Accessibilty - how to open doc with keyboard? 0
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Excel - Wich Function should I use? 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Dumb question alert! What program to use? 0
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
Sub projects added as read only in Master file which are saved on sharepoint 1

Top