Thread: Close a Excel Workbook when close a userform in Outlook
View Single Post
  #3  
Old May 8th 08, 02:54 PM posted to microsoft.public.outlook.program_vba
[email protected]
external usenet poster
  
Posts: 3
Default Close a Excel Workbook when close a userform in Outlook
Thanks, this works:

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As
Integer)

Dim XLObject As Object
Set XLObject = GetObject("H:\Outlook\Prosjekt.xls")
XLObject.Close SaveChanges:=True

End Sub
Ads