Reference is not valid FollowHyperlink error

[kevint_cnc]

Hi all, apologies if i have posted in the wrong section or do anything wrong, i'm new to this and don't undestand what code tagging is yet.

I'm creating a database with an Asset register which gives you a simple route to documents related to these perticular assets. My problem is when linking to Excel files. I use the FollowHyperlink method and reference to a Hyperlink in a row of the table. If this Hyperlink happens to be to an excel file (regardless of version) it generates an error stating "Reference is not valid". The odd thing is that the file opens, but is not maximised on opening. I have searched for weeks for a solution but can only find them for Pivot Table problems in excel.

My code is simply;

Private Sub FormName_ObjectName_Click()
On Error Resume Next
Application.FollowHyperlink [ColumnName]
End Sub

This works fine for any file that isn't an excel file. So my question is, what's missing or what needs changing to prevent the error from appearing. I have tried different compatabilities but have had no luck. I also tried a function called GoHyperlink, but had no luck in Access 2007, i'm not sure if it is only available in 2010.

Any help would be much appreciated



Thanks

[June7]

Google: vba followhyperlink excel reference is not valid
I found a clue in http://www.ozgrid.com/forum/showthre...t=22695&page=2

Use the SubAddress argument of FollowHyperlink, like:
Application.FollowHyperlink [ColumnName], "A1"

However, I tried the empty string as criteria as suggested but it did not work.

[kevint_cnc]

Brilliant! That worked a treat, i was sure i had tried it before, but i must have got the SubAddress argument filled in slightly differently. Thanks for that. I will now look for some code that will maximise the window, as it still opens small, but you have solved my problem, thanks alot!