ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   HOW TO FIND SOMETHING IN ANOTHER FILE, WITCH IS NOT OPEN?? HELP ME (https://www.excelbanter.com/excel-programming/329777-how-find-something-another-file-witch-not-open-help-me.html)

Andrzej

HOW TO FIND SOMETHING IN ANOTHER FILE, WITCH IS NOT OPEN?? HELP ME
 
For example.
I have two files: p1.xls and p2.xls
In p1.xls in unknown Cells value = "AAA" or differend string.. and this file
isn't open.

and I would like to write in to the file p2.xls in to ActiveCell something,
but only if i find in file p1.xls value "AAA" .

How to search that file?






All times are GMT +1. The time now is 02:12 PM.

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