VBA Open Workbook From Outlook

[ziad alsayed]

dear all

is it possible to open a Workbook as soon as Outlook is open?

appreciate any help.

 

[bensonsearch]

dear all

is it possible to open a Workbook as soon as Outlook is open?

appreciate any help.

in outlook go to tools, then macro and make a new one. on the left side click this session and make a application startup macro.

insert code that opens what you need

 

[ziad alsayed]

thanks Benson, can please send me the code ?

 

[bensonsearch]

just open a blank workbook?

Dim asd
asd = Shell("excel.EXE", 1)

under application startup

 

[bensonsearch]

thanks Benson, can please send me the code ?

how did you go?

 

[ziad alsayed]

dear benson

thanks for your concern

i tried the below an it is working

Private Sub Application_Startup()
Dim strFldr As String
Dim OutMail As Object
Dim xlApp As Object
strFldr = "G:\"
Set xlApp = CreateObject("Excel.Application")
    xlApp.Application.Visible = True
    xlApp.Workbooks.Open strFldr & "\Birthday.xlsm"
End Sub