VBA script on document open or close
Hi Joseph,
I don't know about the path issue,
I avoid paths with spaces.
As for the second part of your question,
there are subtle differences between WordVBA and ExcelVBA.
And subtle differences are harder to control then obvious ones.
This one works for me:
Sub auto_close()
If ThisWorkbook.BuiltinDocumentProperties("Title") = "" Then
Application.Dialogs(xlDialogSummaryInfo).Show
End If
End Sub
Sub auto_open()
If ThisWorkbook.BuiltinDocumentProperties("Title") = "" Then
Application.Dialogs(xlDialogSummaryInfo).Show
End If
End Sub
AutoOpen (Word) vs. Auto_Open (Excel)
Autoclose (Word) vs. Auto_Close (Excel)
And many more differences...
--
Greetings from Bavaria, Germany
Helmut Weber, MVP WordVBA
on strange territory
Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"
|