ricebubbles Posted January 21, 2005 Share Posted January 21, 2005 I am trying to use Sendkeys from Outlook to open an Excel file as the Excel file has an Auto_Open Macro (in Macro4) that I want to run automatically. If I use the normal open file commands that Auto_Open is suppressed. My problem with Sendkeys is that it works until Excel creates the OPEN shell, then all my sendkey commands fail with gobbledegook being reported by VB debug.Can anyone help me with this? Link to comment Share on other sites More sharing options...
mattofak Posted January 21, 2005 Share Posted January 21, 2005 You could use the Workbook_Open or Workbook_Activate calls in MSVB script, or the Sheet_Open Sheet_Activate calls... then you could do something like...Private Sub Workbook_Open() Macro1End Sub Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now