use "search" in a closed workbook

[amy_cmte]

Hi,

I created a code to return value of a destinated cell from a list of closed workbooks in a folder. Now my question is how do I alternate the code to "search" through to return a destinated value? The difference is that for the current solution, I must know my destinated cell ahead of time, when in reality, I don't know where it is due to differences in different excel sheets.

Thank you for your help. - Amy

Please Login or Register  to view this content.

[shg]

Welcome to the forum, amy.

Please take a few minutes to read the forum rules (link in menu bar), and then edit your post to add code tags.

[Keyur]

Hi Amy,
I am sorry but I am not sure exactly what you are trying to achieve. I am just replying based on your subject of the thread.

Now I am not sure if it's possible to search through closed workbooks. but you can open files in hidden mode. I am using the following in AutoCAD but it might help you here. The code basically creates a new 'Excel' instance and opens an excel file but it's hidden until it's made visible.

Hope this helps.

Please Login or Register  to view this content.

[amy_cmte]

Thanks Keyur for your reply.

Opening and closing the file will take more time and effort because you must locate each excel file ahead of time in the code (and I have a lot of files to search through). I was able to use the code(not posted) to perform the same procedures to all the excel files in a certain located folder.

In the function(posted in the original thread), is a function called GetInfoFromClosedFile. This function now only retrieves a certain cell from the closed workbook(not known ahead of time). I'm having difficulties adding a "search" feature in the function. (I'm not even sure if this is even feasible or not.) What I essentially want to achieve is to search the rows(in closed file), then find and copy the row with a value (i.e. Account Payable) to the new workbook.

I hope I explain it better. Thanks again for your help.