Do you want to save the changes you made to 'ABC.xls'?
 

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

Do you want to save the changes you made to 'ABC.xls'?
 

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

Do you want to save the changes you made to 'ABC.xls'?
 

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

Do you want to save the changes you made to 'ABC.xls'?
 

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

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