ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   solely search certain cells (https://www.excelbanter.com/excel-programming/412684-solely-search-certain-cells.html)

Julien

solely search certain cells
 
Hi, I'm looking for a way to search only one or two specific cells from a
number of workbooks in a directory - without opening the workbooks.

As a workaround i'm currently searching the workbooks and then using getdata
to retrieve the data from the cells i want. The problem with this approach
is that it appears rather time consuming and often hangs.

Any help would be appreciated

--
J

ytayta555

solely search certain cells
 
HI
Take a look he

http://groups.google.ro/group/micros...705 5aa6ea73d


All times are GMT +1. The time now is 08:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com