I have a varible that refers to a cell on a worksheet in another workbook using the following code.
myInfo=Workbooks ("Report 3-3-04.xls"). Sheets ("Info"). Range ("B4")
This works fine, the problem I am having is the date in the name of the Workbook "Report 3-3-04.xls" changes. Is there a way that I can reference the "Report" Workbook no mater what the date is?
myInfo=Workbooks ("Report 3-3-04.xls"). Sheets ("Info"). Range ("B4")
This works fine, the problem I am having is the date in the name of the Workbook "Report 3-3-04.xls" changes. Is there a way that I can reference the "Report" Workbook no mater what the date is?