I am trying to write a simple macro that will change the file link path/name from the active cell to the value in the cell directly to the right of it....
I tried this:
Dim new_ss As String
ActiveSheet.Calculate
new_ss = ActiveCell.Offset(0, 1).Value
ActiveWorkbook.ChangeLink Range(ActiveCell()), _
Range("new_ss"), xlExcelLinks
But its not working. I know the problem is in the change link to file name variable....
The macro works when I use the names of the two cells.... but I make it realtive to which ever cell lin the SS I am on....
I also tried without the new_ss viable and just using the activecell.offset function in the changelink command...
What am I missing?
Thanks
I tried this:
Dim new_ss As String
ActiveSheet.Calculate
new_ss = ActiveCell.Offset(0, 1).Value
ActiveWorkbook.ChangeLink Range(ActiveCell()), _
Range("new_ss"), xlExcelLinks
But its not working. I know the problem is in the change link to file name variable....
The macro works when I use the names of the two cells.... but I make it realtive to which ever cell lin the SS I am on....
I also tried without the new_ss viable and just using the activecell.offset function in the changelink command...
What am I missing?
Thanks