Hi,
I have an excel spreadsheet that has some hyperlinks in it. I want to update those hyperlinks automatically. I can update the cell itself, but not the link to which this cell points by doing so:
Object[] args = new Object[1];
args[0] = "http://www.google.com";
aRange.GetType().InvokeMember("Value", BindingFlags.SetProperty, null, aRange, args);
Can anyone tell me how I can update the Hyperlink through InvokeMember or any other call?
Thanks,
Bagh
I have an excel spreadsheet that has some hyperlinks in it. I want to update those hyperlinks automatically. I can update the cell itself, but not the link to which this cell points by doing so:
Object[] args = new Object[1];
args[0] = "http://www.google.com";
aRange.GetType().InvokeMember("Value", BindingFlags.SetProperty, null, aRange, args);
Can anyone tell me how I can update the Hyperlink through InvokeMember or any other call?
Thanks,
Bagh