Volatile Formula Issue Causing...
"Do you want to save the changes you made to€¦vbYesNoCancel"
during Access-to-Excel automation.
I'd read that can be prevented by...
Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Saved = True
End Sub
However, I'm using FollowHyperLink w/ the option
to open the Excel File...
In using..
Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Saved = True
End Sub
...it doesn't allow the FollowHyperlink in code to open
the file..a "Gotcha"...how can I avoid the
"..want to save the changes you made.." MsgBox
and STILL open the file w/ FollowHyperlink???
TIA - Bob
|