Thanks for the fedback.
--
Gary''s Student - gsnu200831


"Loopi" wrote:

I figured out how to get this done. Your suggestion worked perfectly and
really sped up the entire process for my end users....

Thank you very much

"Loopi" wrote:

Thank you. One quick question. How do i indicate the tab location where full
file spec in A1? The passed on link name will be in a hidden tab named
"lists". Is there code for sheet select or something of that nature?

"Gary''s Student" wrote:

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