Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
refresh a folder
My "process" macro cycles through a folder and opens each workbook and does
stuff to it. When it is finished, it closes the workbook and moves it to a "completed" folder. The workbooks are sent to this folder by our cost centers with another macro. During month-end, the volume of worbooks submitted by the cost centers increases significantly. I've noticed the "process" macro only processes workbooks submitted prior to starting this macro. Any workbook submitted by the cost centers after the macro has started (and is running) does not get processed. I have to re-start the "process" macro and cycle through the folder again to get the "new" workbooks processed. Is it possible to programmatically "refresh" the folder each time a workbook is processed so any "new" workbook submitted while the macro is running is processed? Thanks for the help. -- JT |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
refresh a folder
Without knowing what you've got set up, you could probably do something like
this Before you start looping through the workbooks Dim WBFound as Boolean Do WBFound = False 'Put all your Workbook Processing here 'When you process a workbook, set WBFound = TRUE Loop while WBFound = TRUE -- HTH, Barb Reinhardt "JT" wrote: My "process" macro cycles through a folder and opens each workbook and does stuff to it. When it is finished, it closes the workbook and moves it to a "completed" folder. The workbooks are sent to this folder by our cost centers with another macro. During month-end, the volume of worbooks submitted by the cost centers increases significantly. I've noticed the "process" macro only processes workbooks submitted prior to starting this macro. Any workbook submitted by the cost centers after the macro has started (and is running) does not get processed. I have to re-start the "process" macro and cycle through the folder again to get the "new" workbooks processed. Is it possible to programmatically "refresh" the folder each time a workbook is processed so any "new" workbook submitted while the macro is running is processed? Thanks for the help. -- JT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Excel functions formula and auto refresh refresh | Excel Worksheet Functions | |||
Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
Save file in a new folder, but create folder only if folder doesn't already exist? | Excel Programming | |||
Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming |