Lookup up cell value in closed sheet

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

what Im trying to achieve:

Column L lists file names including path eg c:\rds\incomplete\filename.xls
(the filenames will be variable, ie they will change regularly, so to the
amount of filesnames in the list, usually between 1 and about 20 can be
listed at any given time)

Column A needs to retreive information from a cell (example sheet1!B6) on
the closed workbook listed in column L

Would like to call a function the will populate column A automatically....

tia steve
 
Open them, extract the data and close them


Set thisWb = Activeworkbook.Activesheet
Workbooks.Open Filename:=(Range("L1").Value
thsWb.Range("A1").Value = Activeworkbook.Activesheet.Range("B6").Value
ACtiveworkbook.Close

etc for each book

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
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

Populating values in cells based on lookup from other cell. 4
Conditional listbox cell populating 4
Match or Lookup 6
Find a value in a sheet and replace it with another value if it matches 8
Lookup and copy cells if match found 2
fill in data that is not empty 1
Convert code to lookup three criteria return fourth 15
Macro to insert formula using cell reference/text - Urgent 2

Back
Top