Ok I will give that a try also.
--
Leanne M (Aussie)
(Changed Display name from Leanne)
United Kingdom
(Don''t ask me what an Aussie is doing living in the UK!)


"Dave Peterson" wrote:

Just something to try...

I've always used:

file:////c:.....

(4 slashes

Leanne M (Aussie) wrote:

Hi,

I have the following code to switch/open a workbook.

Private Sub CommandButton3_Click()
s = "file:///c:\My Documents\Pest Control Management System\Pest Control
Reporting Tool.xls"
ActiveWorkbook.FollowHyperlink Address:=s
Application.CommandBars("Web").Visible = False
End Sub

This is one two workbooks and the code is exactly the same (with the
exception of the file name). On one of the workbooks the code works, on the
other it does not. I get a messaging saying 'Object invalid or not found'

This is only (so far) happening on my husbands pc (windows vista excel
2003). The code works in both instances on my pc and the one at work.

Any ideas as this has me baffled (though thats not hard these days!)
--
Leanne M (Aussie)
(Changed Display name from Leanne)
United Kingdom
(Don''t ask me what an Aussie is doing living in the UK!)

--

Dave Peterson