![]() |
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