Referring to a worksheet in a closed workbook.

**Al Bert** · 05-05-2009, 06:49 PM

I've done quite a bit of searching, and apologize in advance if there is some obvious answer to this question I just haven't been able to come up with yet.

I'm reading data, from specific cells off a closed workbook. When the sheet that needs said cell data is activated, it automatically opens the workbook and references the sheet nessecary. The issue I've come across, is I now need to access another workbook (Easy to open) with 12 sheets 1 for each month, and only read from the worksheet of the actual Month...

Kind of lost on how to possibly make this work. I basically need something like:

=location/[workbook.xls]worksheet!cell - where worksheet = B12

and B12 =month(today()) and is formatted to MMMM

I realize that doesn't work, looking for another way around it. Any advice is greatly appreciated.

I'm using WinXP and Excel 1997

Thanks in advance for your help,

Albert

PS: This question has been posted on another forum as well... Post found here: http://www.mrexcel.com/forum/showthread.php?t=388107

**ravishankar** · 05-06-2009, 02:20 AM

HI
try the formula shown in the following link
http://www.excelforum.com/excel-prog...pening-it.html
Ravi

**Al Bert** · 05-06-2009, 09:20 AM

I already have it opening the closed workbook. I'm already past the step of reading from the workbook after its open. The trouble I'm having is reading from a sheet, that matches the current month and automatically updating to match the month....

So in May, it reads from the May worksheet after I open the the workbook. Then when June hits, it reads from June. Obviously I can just reference directly using June!E5. But having to change that each month is a pain, since its on multiple sheets in multiple cells and replace all isn't an option.

This is the code I'm using to open the workbook:

Please Login or Register  to view this content.

I just need the cell formula, to read from Lock%Desk.xls the worksheet that has the current month's information.

Thanks again for any assistance.

Albert