FollowHyperlink

[Mudbutt]

This line of code isn't working for me for some reason and everything I've looked up states that it should. I'm getting an "Object does not support this property or method" error.

When I click on the link directly, it pulls up the option to Open the file so I know the link works...

Application.FollowHyperlink "http://.../Delivery Plan Data.xlsx", , True

 

[Andrew Poulsom]

FollowHyperlink is a member of the Workbook object not of the Application object.

 

[Mudbutt]

Oh really? Because all the examples I found online stated it like this. I tried Workbook.Followhyperlink just now and it told me the object is still required. Do you have an example?

 

[Andrew Poulsom]

You could use:

ThisWorkbook.FollowHyperlink "http://.../Delivery Plan Data.xlsx", , True

 

[Rick Rothstein]

Oh really? Because all the examples I found online stated it like this. I tried Workbook.Followhyperlink just now and it told me the object is still required. Do you have an example?

Try either ThisWorkbook or ActiveWorkbook... not just Workbook by itself.

 

[Mudbutt]

That worked! Thanks guys! Do you know how to bypass the prompt warning me about opening something with a virus?

 

[Andrew Poulsom]

Do you know how to bypass the prompt warning me about opening something with a virus?

Here you are:

http://support.microsoft.com/kb/829072

 

[Littlemalky]

That's too bad, i don't have enough access to my computer because it's a work computer to make those changes. Thanks anyway.