Close ALL Workbooks and Save Changes WITHOUT asking do I want to save.

start macro with

Please Login or Register  to view this content.

Hi, clemsoncooz,

this code is unreliable as may be. You want to close all workbooks down you would need to make clear which path and name should be used for all workbooks which aren´t saved in the Excel application. The Code patel45 delivered won´t be of any use if there is an unsaved workbook which always display the SaveAs display and should be used as xlApp.DisplayAlerts and not Application.DisplayAlerts.

I would use the CreateObject, open the relevant workbook, do my action, save and close the workbook, quit the application and release all objects. And since there was more than one workbook open I had to specify which workbook to use as well as the worksheet on which to perform the action.

I think both posters missed the line

The VBA code will reside in ACCESS.

Ciao,
Holger

Try this.

Please Login or Register  to view this content.

Hi, Norie,

just for me to get it sorted: Application - Workbook - Worksheet - Range?

Please Login or Register  to view this content.

isn´t clear for me at first sight as neither a workbook nor a worksheet is given for the Application (resulting in RTE 1004 for a newly created instance).

Ciao,
Holger

Holger

I kind of ignored those lines, perhaps wrongly, as the question was about closing workbooks.

This isn't quite right but will work - Range("A1") will refer to A1 on the active sheet

Please Login or Register  to view this content.

Hi, Norie,

thanks for coming back on that. I know it sounds a bit out of the box in an Excel Forum but please close down Excel and start the procedure from Access. No workbook is open, the RTE will occur no matter if the lines may work with an open book or not. And I think my comment about not being to stable is not so far out of the world as no workbook is specified (what about a personal macrobook), no worksheet.

I know I´m pretty oldfashioned but I like to know what I am working on which I can´t guarantee with this kind of code.

Ciao,
Holger

Holger

I'm kind of assumed it's not 'real' code.

It would work if this code was removed, even if no instance of Excel was open.

Please Login or Register  to view this content.

PS When testing the 'code' I was using Access.