FollowHyperlink ExtraInfo string max length?

[Guest]

Hmmm, I have been using the ActiveWorkbook.FollowHyperlink function without
any problems until I tried to put in a large string in the ExtraInfo field.
If the string is 846 characters it works, if it is 847 characters then it
fails. I tried using the GET & POST methods but it fails both ways.

The function fails with the following error:

Run-Time Error -2147024882 (8007000e)

From what I can tell this refers to a "Ran out of memory" error.

Is this a known limitation within Excel/VB?
Or am I just missing something obvious...

Code Snippet
=================================================
Dim info As String

info = "Really long string..."

' Push this data to the web page and popup a web browser window
ActiveWorkbook.FollowHyperlink _

Address:="http://www.somesite.com/loadForm.do", _
NewWindow:=False, _
AddHistory:=False, _
ExtraInfo:=info, _
Method:=msoMethodPost

=================================================


I'm using Excel 2003 which came with MS Office Basic Edition 2003.

 

[Frank Kabel]

Hi
I would expect that a maximum of 255 characters is allowed for this
string value

 

[Guest]

Interesting... can you expand on why you think 255
characters is the max?

Thanks,
Chad