L
Loopi
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
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