inserting hyperlinks using vba

[brojard]

I have excel 2002. I inserted hyperlinks via a vba .bas file that I created using a shell script. I imported the bas file by clicking tools>> macro>> vba editor >> import. A module was created. I then clicked "run" and closed the vba editor. Everything looked ok. The links were inserted properly. But, when I click on a link it does not open follow the link. The hour-glass appears. Nothing happens (it should open a pdf file. After five or ten minutes, I try to close excel but I get this message: "Excel is waiting for another ole object to complete an OLE action." What do I need to do to automate the creation of hyperlinks / import macros? Here's a snippet of my vba code.

Please Login or Register  to view this content.

[Richard Buttrey]

I have excel 2002. I inserted hyperlinks via a vba .bas file that I created using a shell script. I imported the bas file by clicking tools>> macro>> vba editor >> import. A module was created. I then clicked "run" and closed the vba editor. Everything looked ok. The links were inserted properly. But, when I click on a link it does not open follow the link. The hour-glass appears. Nothing happens (it should open a pdf file. After five or ten minutes, I try to close excel but I get this message: "Excel is waiting for another ole object to complete an OLE action." What do I need to do to automate the creation of hyperlinks / import macros? Here's a snippet of my vba code.

Please Login or Register  to view this content.

Hi

Try changing the last bit to"

Address:="http://www.source/0001.pdf"

HTH

[brojard]

Hi

Try changing the last bit to"

Address:="http://www.source/0001.pdf"

HTH

Richard, I don't think this will work because I am trying to map the pdfs to a relative path. I plan to take this data and install it on my user's PCs. The user will always have a spreadsheet and a folder at the same level named "source."

[Richard Buttrey]

Richard, I don't think this will work because I am trying to map the pdfs to a relative path. I plan to take this data and install it on my user's PCs. The user will always have a spreadsheet and a folder at the same level named "source."

Hi,

Ah, OK. I thought you were trying to create a link to a web URL. In which case try the following instead.

Please Login or Register  to view this content.

HTH