Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Call Outlook Contacts from Excel Userform | Excel Programming | |||
VBA Pause to allow Print to start. sending fax via Outlook | Excel Programming | |||
Build a userform on excel to copy contacts from outlook 2003 | Excel Programming | |||
I deleted MS Outlook from my start menu, now EXCEL won't work? | Excel Discussion (Misc queries) | |||
Can't start outlook from Excel | Excel Programming |