shellToFile compile error

[sammers101]

I'm getting a compile error. I was trying to use ShellToFile for links in a table. Is there another way that allows users to click links that are part of a list?
Some items in the list have a link, others do not. They are different links.
I was using this code:

Private Sub cmdOpen_Click()

    If Not IsNull(Me.link) Then
        ShellToFile Me.link
    End If
    
End Sub

Thanks

 

[theDBguy]

Hi. To fix the error, you'll have to show us the code for ShellToFile. Otherwise, have you tried?

Application.FollowHyperlink Me.Link

 

[sammers101]

I used that before and switched to ShellToFile Me.link for some reason (can't remember now), but that appears to be working.
Thanks

 

[theDBguy]

I used that before and switched to ShellToFile Me.link for some reason (can't remember now), but that appears to be working.
Thanks

Well, yes, there are some potential drawbacks to using such a simpler approach. However, we can't help you fix the problem with ShellToFile if we can't see what it does. Is it the same thing as ShellExecute?