Trouble With Hyperlinks

Greetings,

I am having great difficulty with the Hyperlinks Method.

I have a workbook where the user fills in summary information and then clicks a command button which takes that information, copies it to the appropriate fields on a template (a separate workbook), and then saves the new workbook with the next consecutive number as the file name. All this works just fine.

The next sub in my macro is supposed to create a hyperlink from the active cell to the newly created workbook which is in a sub directory under the directory where the summary workbook resides.

Here's my code:

Please Login or Register  to view this content.

This runs until I get to the line in purple text, at which point it hangs and produces a "Run-time error '1004': Application-defined or object-defined error.

Any help at all would be appreciated. I've been working on this one line of code for 3 days now with no luck whatsoever.

Thanks,
~ Phil

JBeaucaire,

Thank you for your suggestion and I apologize for my delayed response. I got pulled into another project for a few days.

Unfortunately, your code hung at the creation of the hyperlink too. If you have any other suggestions, I would love to hear them.

In the mean time I will continue to try to beat it into submission!

Thanks again,
~ Phil

Thanks for your continued assistance.

Since my project involves workbooks in two different directories, I have used the .zip format to preserve the directory structure. The Q:\ drive referred to in the code is a network drive here at work. I don't know what impact that has on your ability to manipulate the files. The password to unlock the VBA project and the protected worksheet is "atholl" (no quotes).

I have also included a .doc file which is the instructions for the end user.

There really isn't anything proprietary in here, although you can see my full real name in the path of the network drive.

I know my code is sloppy, and have come to realize that I should be working in a module, not in Sheet1. I'm still learning VBA and unfortunatley, I don't get to use it frequently enough to facilitate good learning. I frequently find that what works in the lessons & books I'm studying from doesn't always work as well in the real world.

Thanks again for investing your time in helping a newbie out.

~ Phil

That is the name of Sheet1 in the templates. I'm grabbing my file name from cell AO9 in the template.

Sorry for the delay. I got pulled off onto another project ...

SO I tried your code and it still produces the same error when attempting to create the hyperlink.

Run-time error 1004, Application defined or Object defined error.

I've also checked with our network admin and confirmed that there is nothing in our network security preventing the creation of hyperlinks.

Thanks for your time.

Solved!

As usual (at least in my case) it was something simple. The cell I was trying to anchor the hyperlink to was protected. Duh!

This code runs and does what it's supposed to now.

Please Login or Register  to view this content.

Thank you again for your time and patience.
My apologies for not catching my boneheaded error sooner.

~ Phil

Thanks.

I was looking for a way to do that but couldn't find it.