Network Links
I tried that, but it made no difference.
What happens when I run my macro is:
Excel displays the correct path with the usual warning about ...files may
contain viruses...
I click on OK.
Excel then displays an error with the path changed to:
C:\Documents and Settings\MyName\Local Settings\Temporary Internet
Files\Content.IE5\ZEK7Z9S1\...
This obviously fails, because the file isn't there.
--
Steve Franks
"Bill Manville" wrote:
Try
File/Properties/Summary/Hyperlink Base =
\\SomeNonExistentServer\Folder
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|