VBS Help required.

[ricebubbles]

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?

[mattofak]

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()
    Macro1
End Sub