With the full filespec in A1:

Sub up_it()
Dim s As String
s = Range("A1").Value
ActiveWorkbook.UpdateLink Name:=s, Type:=xlExcelLinks
End Sub


--
Gary''s Student - gsnu200831


"Loopi" wrote:

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