Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi there,
The facts: - I have a folder with 50-60 files, each file having more than 10 sheets; - the files are pretty big (some of them 40mb+) and are linked to many other files from various locations from the network; What I would like to do is: - to verify whether all files are comprising a sheet named for example "Abc"; The code currently used by me is doing this check, but it is necessary to open each file from the respective folder. The issue is that due to big number of files, size and links, the execution of this code takes few hours. Thus, my code is useless. The question: is it possible to make this test without opening the files? Many thanks in advance, Bogdan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Check if file exists | Excel Discussion (Misc queries) | |||
Loadpicture - check if file exists | Excel Programming | |||
How do I check if a sheetname exists in a file? | Excel Programming | |||
check if file exists | Excel Programming | |||
check if a file exists / is open | Excel Programming |