Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing Closed Files
I have a number of XL workbooks in a directory. I want to loop through
every workbook, checking if that workbook contains as wks called 'NEW' and if it does, collect data from this worksheet. I have written code that achieves this, but I do this by opening every WB to test if the 'NEW' worksheet exists. This is very time consuming as every file has to be opened and closed. Is it possible, through code, to test for the existence of a worksheet within a closed workbook. If it does test whether it is visible or hidden WITHOUT opening the workbook? Paul Smith |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing Closed Files
Paul
I don't think that's possible. You might consider setting Application.Calculation, Application.ScreenUpdating to False to speed up what you already have. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Paul W Smith" wrote in message ... I have a number of XL workbooks in a directory. I want to loop through every workbook, checking if that workbook contains as wks called 'NEW' and if it does, collect data from this worksheet. I have written code that achieves this, but I do this by opening every WB to test if the 'NEW' worksheet exists. This is very time consuming as every file has to be opened and closed. Is it possible, through code, to test for the existence of a worksheet within a closed workbook. If it does test whether it is visible or hidden WITHOUT opening the workbook? Paul Smith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking up information in closed files | Excel Discussion (Misc queries) | |||
Linking Files that are closed | Excel Discussion (Misc queries) | |||
Reference closed files in formula | Excel Worksheet Functions | |||
Testing Time /Date stamps of Files | Excel Programming | |||
Testing Time /Date stamps of Files | Excel Programming |