Hi Everyone,

I get the dreaded runtime error 87 when I use followhyperlink. Not
sure why it fails, but it seems like a universal issue with a certain
number of characters. (Which is also random. I started failing at
1000+, and found some links that would only take 800+.)

(All of these links work fine when cutting and pasting the same string
into Internet Explorer.)

I've googled it endlessly, and gave up after the umpteenth board
posting with no solution offered.

Anyone know of a hack or some sort of shell call or something that
will let me use a bigger string to open a hyperlink from VBA?

Thanks,

Jon

on 5/27/2011, jonceramic supposed :
Have a Look at the Shell Execute API. There is some Copy Paste code
here http://access.mvps.org/access/api/api0018.htm I have been using
this code for a long time without problems, but doubt that I ever
passes strings anywhere near 800 bytes.


Rdub