How to use the "post" parameter with the Excel's 2003 hyperlink "follow(...)" method?

Question

If you look at Excel's help for the Follow Method of the hyperlink object, you'll see that it accepts POST as a way to send the data. How should I fill the "Extra Info" String or byte array? How should I format the data? What is the limit for the data to be sent? Please see below:

expression.Follow(NewWindow, AddHistory, ExtraInfo, Method, HeaderInfo)

Method Optional Variant. Specifies the way ExtraInfo is attached. Can be one of the following MsoExtraInfoMethod constants.

ExtraInfo to specify the coordinates of an image map, the contents of a form, or a FAT file name.

Method Optional Variant. Specifies the way ExtraInfo is attached. Can be one of the following MsoExtraInfoMethod constants

• msoMethodGet ExtraInfo is a String that’s appended to the address.
• msoMethodPost ExtraInfo is posted as a String or byte array.

Answer 1

ok if you are "get"ing you format as string.
follow(,,,msoMethodGet,"/questions/3354288/")
so if the link is www.stackoverflow.com
you should go to www.stackoverflow.com/questions/3354288/

if you are "post"ing you can either use a string OR byte array. You can try something like username=asdf or Content-Type: application/x-www-form-urlencoded" + Chr(10) + Chr(13) + username=asdf. You may need to look up the spec for http posts and send the entire header.