I've been working on trying to CONCATENATE a link to a bit of data in a separate file. I have many files to draw data from - this is the reason for wanting to automate it.
What I have done is generated the link text string, and then I want to automate Copy-Paste Special-Value, so that the link is the actual link string not CONCATENATE ..... now I'm doing this with a macro - so it is working, but it pastes the full correct text string, but stops there - I then need to enter the cell, and leave it again ! - then the formula works - without being changed.
If I try to automate that with a MACRO, the VB code contains the actual cell contents - just just enter/leave, so the macro won't work when a variable changes - as it contains the exact references from when I recorded the macro.
I think I have made things much more complex than they need to be here - but have had little success with getting help on this subject - even here ! - Is this a really complicated problem ? - I need help, please, I CHALLENGE YOU !!
What I have done is generated the link text string, and then I want to automate Copy-Paste Special-Value, so that the link is the actual link string not CONCATENATE ..... now I'm doing this with a macro - so it is working, but it pastes the full correct text string, but stops there - I then need to enter the cell, and leave it again ! - then the formula works - without being changed.
If I try to automate that with a MACRO, the VB code contains the actual cell contents - just just enter/leave, so the macro won't work when a variable changes - as it contains the exact references from when I recorded the macro.
I think I have made things much more complex than they need to be here - but have had little success with getting help on this subject - even here ! - Is this a really complicated problem ? - I need help, please, I CHALLENGE YOU !!