Hi,

I'm trying to link to an external workbook. Let's say the formula is:

G:\2007\2007 Jun\blah.xls

I would like to be able to change "Jun" by referencing a cell. I've read
that the Indirect function cannot be used to reference an external workbook
without it being open. I can't open my external workbook b/c it has the same
file name as the one I'm working on (but they are located in difference
folders, thus, needing to change "Jun" each month). Is there a way to do
this?

Thanks in advance for any help.