Sorry, you are dealing with a VB dummy here.
Below is cell content that is calculated when a user selects a month through
a conditional formatting dropdown, in this case January:
K:\Operations\Daily Production Sheets\2009\01-09\0109 Production
Reports.xlsb. This part is already done and works.
I need to pass this information from the cell location where it exists into
the macro statement: (ActiveWorkbook.UpdateLink Name:= _ €œ €œ, _
Type:=xlExcelLinks) in-between the quotes where you would typically indicate
the path to the desired file. I am not sure how to use variables to pass
information to the VB code from a cell range. This needs to be done to speed
up a process that links to twelve large monthly data gathering workbooks over
a WAN. The above will allow only the month in question to have the link
updated with daily information greatly speeding up the process.

Thank you for your time