Do you want to save the changes you made to 'ABC.xls'?
That did it.
THANK you - Bob
"Gary''s Student" wrote:
When Excel has focus, touch ALT-F11 to bring up VBA.
Go to the left-hand pane and right-click the ThisWorkbook icon in the small
object tree. Select View Code.
Paste the stuff in and close the VBA window.
MANUALLY SAVE THE WORKBOOK. You may not get a change again, cause you won't
be prompted.
--
Gary''s Student
gsnu200709
"Bob Barnes" wrote:
Gary - thank you.
I'm almost completely an Access Programmer. Where do I find the module to
enter this code?
TIA - Bob
"Gary''s Student" wrote:
Put the following macro in the workbook in ThisWorkbook code:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Saved = True
End Sub
--
Gary''s Student
gsnu200709
"Bob Barnes" wrote:
I'm running Automation from Access-to-Excel.
As the Procedure ends, within Access, I'm getting
the "Subject" Message above. I've run Automation
from Access-to-Excel many times...but now this
message on this one File.
Any way to turn that off?
TIA - Bob
|