followhyperlink to Excel w/s generates "Reference is not valid"?

[Guest]

Good day folks!
An (MS Access) call to a workbook (via FollowHyperlink) generates "Reference
is not valid". If the book is saved and re-opened manually there is no
errror, and all cells/formulae/references seem to be OK?
thanks in advance

 

[Guest]

Does your hyperlink to the file use this method:

FollowHyperlink "file:///D:\YourFilePath\YourFileName.xls"

and not just

FollowHyperlink "D:\YourFilePath\YourFileName.xls"

because a valid hyperlink to a file is prefaced with file:///
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[Guest]

Thanks Bob.
I am using the 2nd syntax, (always works OK).
I discovered I was omitting the 2nd arg (sub-address) and instead using the
3rd ('True') in in its place. This was causing the problem.
cheers,
N.

 

[KS30]

Hi Bob & others tha might be able to help (please?!)

I also keep getting a dialogue box saying "Reference is not valid" when
linking from a Visio 2007 model to an Excel 2003 worksheet.
I use the D:\YourFilePath\YourFileName.xls in the Address field for the
hyperlink - if I put the 'file:///' in front then the link doesn't work at
all.
I put the name of the worksheet in the Sub-Address field.
Sometimes when I click on the link it opens the correct worksheet and
sometimes when I click the link it opens the file but at the first worksheet
instead.
But it always has the same error message!

Any ideas??!
Thanks lots

Kate