Syntax Compile Error - How to work around this (file path doesn't exist)

**Harribone** · 01-18-2015, 06:05 AM

HI,

I have the below code with is used to open a user guide file.
This works fine at work as the path and file exist.

Please Login or Register  to view this content.

At home however when working on improvements this causes a compile error as the path doesn't exist. How do I work around this so that I don't get a Compile Error (I thought the ErrHandling would have done the job)?

Thanks in advance
Harribone

**TMS** · 01-18-2015, 06:23 AM

You appear to have an extra double quote on the FollowHyperlink line ... ""\\

Regards, TMS

**Harribone** · 01-18-2015, 06:37 AM

What an absolute idiot I am....

Thanks TMS

**TMS** · 01-18-2015, 08:19 AM

You're welcome. Thanks for the rep.

Syntax Compile Error - How to work around this (file path doesn't exist)

LinkBack

Thread Tools

Rate This Thread

Display

Syntax Compile Error - How to work around this (file path doesn't exist)

Re: Syntax Compile Error - How to work around this (file path doesn't exist)

Re: Syntax Compile Error - How to work around this (file path doesn't exist)

Re: Syntax Compile Error - How to work around this (file path doesn't exist)

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] first timer using VB to cut and paste macro - getting compile error syntax error

[SOLVED] Work around for Run-time Error 445: Object Doesn't Support This Action (File Search)

[SOLVED] VBA Loop - Does file exist (Y/N) at the path specified?

Syntax Error and Compile Error: Expected Line Number or Label...

error msg of link to a file that doesn't exist

Bookmarks

Bookmarks

Posting Permissions