Adjustable Macro Code????
 

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

Adjustable Macro Code????
 

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

Adjustable Macro Code????
 

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

Adjustable Macro Code????
 

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

Adjustable Macro Code????
 

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