Holdenfreak
New Member
- Joined
- Nov 3, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi All,
I would like to run a code to open a .xls file and check a specific cell in that file. The file names are variable and based in invoice number ie ACC003-SS-D9927. I would like to be able to search for just "D9927" the "ACC003... part is variable. i will also be searching multiple folders with a directory (W:\EAL\ARCHIVE EAL REPORTS). I will probably do this via a userform and textbox to set the job number search.
Can anyone help as to how to open the specified files
Cheers
Holdenfreak
I would like to run a code to open a .xls file and check a specific cell in that file. The file names are variable and based in invoice number ie ACC003-SS-D9927. I would like to be able to search for just "D9927" the "ACC003... part is variable. i will also be searching multiple folders with a directory (W:\EAL\ARCHIVE EAL REPORTS). I will probably do this via a userform and textbox to set the job number search.
Can anyone help as to how to open the specified files
Cheers
Holdenfreak