View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] s_smith_iet@hotmail.com is offline
external usenet poster
 
Posts: 66
Default Get outlook to start a userform in excel.

I have a outlook code to open an excel spread sheet when outlook is
opened.
What I need now is for it to start a user form in that spread sheet.

Please see code

Thanks

Private Sub Application_Startup()
Folder = "\\Mascarolinabdc\puball\Stuff ~ Stephen\"
FName = "NPI email macro.xls"
On Error Resume Next

Set excelbook = GetObject(Folder & FName)

With excelbook
.Application.Visible = True
.Parent.Windows(FName).Visible = True


End With

End Sub