Hey all, I have something that I just can't seem to figure out. cells h2 to
k33 are linking to a file such as "
[\\network_path\directory\xls_file]worksheet!h2" etc etc. my problem is
that the excel file is named with the month. What I have been trying to do
is create an external link that uses the value of a cell for the file data.
an example would be having my path in cell a1 and the current month in cell
b1 followed by the worksheet in cell c1. then in my group h2 to k33 instead
of the direct link it would be looking at the combination of the 3 cells in
row 1 that make up the link. Now as each month changes so does the reference
and only that month is displayed. Is this possible, it has to be right?

Thanks in advance for any help.
Frank