Autosave doesn't work

  • Thread starter Thread starter Alonso Vilela
  • Start date Start date
A

Alonso Vilela

I use Automation with excel but When I change the name of the book and
sheets, later I save the book, but all the time and end show me a message if
I want to save the changes in the book.

I set autosave in true but doesn't work.

Help me please.
 
If you're expecting the AutoSave add-in to help you, it does not load with
Excel under automation.

If, on the other hand, you're saying that you are making changes, saving the
workbook and still Excel prompts you to save changes, I'd suggest telling
Excel that the workbook is saved just before closing it:

Set XL = CreateObject("Excel.Application")
XL.Visible = True
XL.Workbooks.Add
XL.Activesheet.Range("A1").Value = 1
XL.ActiveWorkbook.Saved = True
XL.ActiveWorkbook.Close ''No prompt

--
Jim
|I use Automation with excel but When I change the name of the book and
| sheets, later I save the book, but all the time and end show me a message
if
| I want to save the changes in the book.
|
| I set autosave in true but doesn't work.
|
| Help me please.
|
|
 
Back
Top