ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Get outlook to start a userform in excel. (https://www.excelbanter.com/excel-programming/415349-get-outlook-start-userform-excel.html)

[email protected]

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


All times are GMT +1. The time now is 07:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com