Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Macro, how can I check if an opened workbook was changed ?
please help. I have in a VBA project a Workbook that opens 13 other
workbooks, and at end must close them all. At the moment my instructions to the Main workbook is to save them all, and this is costing a lot of time when I am waiting for the files to be saved. now I want to change to a situation where the workbook closes the files that were not changed, and only save the one that has been changed. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Macro, how can I check if an opened workbook was changed ?
Dim wkbk As Workbook
On Error Resume Next For Each wkbk In Workbooks wkbk.Save wkbk.Close Next "Macro to check if a workbook has changed" wrote: please help. I have in a VBA project a Workbook that opens 13 other workbooks, and at end must close them all. At the moment my instructions to the Main workbook is to save them all, and this is costing a lot of time when I am waiting for the files to be saved. now I want to change to a situation where the workbook closes the files that were not changed, and only save the one that has been changed. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Macro, how can I check if an opened workbook was changed ?
Dim oWB As Workbook
On Error Resume Next For Each oWB In Application.Workbooks If Not oWB.Saved Then oWB.Save oWB.Close Next -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Macro to check if a workbook has changed" <Macro to check if a workbook has wrote in message ... please help. I have in a VBA project a Workbook that opens 13 other workbooks, and at end must close them all. At the moment my instructions to the Main workbook is to save them all, and this is costing a lot of time when I am waiting for the files to be saved. now I want to change to a situation where the workbook closes the files that were not changed, and only save the one that has been changed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro in Excel to check if another workbook is opened. | Excel Programming | |||
How to check workbook is already opened before passing the workbook obj to a subroutine in Word | Excel Programming | |||
Looking for a way to run a macro when the workbook is opened | Excel Programming | |||
Check if workbook has been changed | Excel Programming | |||
Code to check if workbook is the last one opened | Excel Programming |