No, not really. The xCell.Address would contain the actual link whereas the xCell.Value would contain the 'friendly' info.sundaymorningstaple wrote:Your macro, if I understand it correctly, needs to have the file name in the field in the spreadsheet.
None of the above. I've been all through the knowledge base and cannot find any reference to it at all. I've only found one instance that it's happened before, but unfortunately, no reasonable answer as the so called expert said it could not be right and the hyperlink had to be wrong?!?.
My guess is the open office changed the file extension, which alters the data to the local server on your home computer, so it will always open the Open office file extension and not the original file extentions, data of the change can still be read on the office computer that's why it works only in the office.sundaymorningstaple wrote:None of the above. I've been all through the knowledge base and cannot find any reference to it at all. I've only found one instance that it's happened before, but unfortunately, no reasonable answer as the so called expert said it could not be right and the hyperlink had to be wrong?!?.
http://en.allexperts.com/q/Excel-1059/H ... xcel-2.htm
Still searching......
Users browsing this forum: No registered users and 1 guest