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?
 
Ad

Advertisements


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