referencing a closed workbook

B

buckyduke

the INDIRECT formula will not pull values from a closed workbook, wha
is a solution to this?

I am trying to reference a cell in a closed workbook on a sheet tha
has the same name as the active sheet, so I want to be able to us
MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) in the referenc
to the other workbook...

thank
 
N

NooK

There was a topic about getting data from a closed workbook aroun
friday last week and there was a link there for a code to do that bu
sorry I can't remember it so I think a search should do it.

But why not open the workbook, get the stuff you want and close it?
do it all the time (Although I am a newbie in VBA) and I see no harm i
it.

Best Regards

Noo
 

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

reference to closed workbook 2
solution to reference closed workbook 2
Referencing Inactive Workbook Cells 3
Excel sum if and closed workbooks 2
Recalculate formulas when active sheet switches 1
Formula from closed workbook? 2
Get data from closed workbook for use in a variable (no copying) 3
Pull values from a closed workbook 1

Top