Function required to extract cell info from an unopened file.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have about 5000 recipes in separate spreadsheets and i have been asked to
compile a list of the recipe names into a new spreadsheet.
I could open every individual recipe and copy/paste the filename into the
new spreadsheet but that will take forever.
Is there a way to tell the spreadsheet to look at the xls files and extract
the info required (the recipe name is always in the the same cell ref),
without openeing the files?

Any help would be gratefully received
Thanks
 
This message should be sent to the programming newsgroup - it will need VBA
to do it.
best wishes
 
YOu can't get information out of a spreadsheet without opening it, but that
opening can be done with screen updating off, so the user doesn't see it
happening. As Bernard says, you need a macro to do this.
 
Thanks for the advice, i will post the same question in the correct
discussion group
 
Thanks for the advice, i will post the same question in the correct
discussion group
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function or VBA required to extract cell info from an unopened fil 5
How to Extract Emails from PST File Without Outlook? 1
Collate data from one spreadsheet into another spreadsheet 2
Reference constant cells in different files from a master workbook 1
extract data from cells 2
Extract specific information from the body of outlook mail to an Excel File using VBA 0
extract characters from filename 7
formula finds values in apparently blank cells 1

Back
Top