Just my opinion, I don't think this has anything to do with FollowHyperlink.
You can automate Internet Explorer - that's the common approach. You can use
Code:
Dim IE as object
set IE = createobject("internetexplorer.application")
IE.visible=true 'easier for debugging and eyeballing what is going on
IE.Navigate "some URL"
After that point, you will need to right-click on the page and View Source to see what you are up against. There is no one size fits all answer. If you see button IDs and textbox IDs, you might get lucky, then you can use things like:
Code:
IE.Document.GetElementyByID("id number").Value = "something"
IE.Document.Forms("formName").submit
OR
Code:
IE.Document.getelementbyid("button1").Click
As you can see, a significant amount of legwork on your part will be required. In many cases you will need
Code:
'Do Until ie.Busy = False
DoEvents
'Loop
in between lines of code to "wait" for IE to be ready.
It will be very likely much less than 100% reliable, hit & miss, and totally fail if/when the webpage programmer changes the slightest detail.
If the page depends on calling javascript functions rather than button click events and such, you will need yet a slightly different approach for the Wait concept, since IE won't be busy.....But a java script function could very likely still be busy.
See if that gets you anywhere and post back if you get stuck. I will try to help.
The best advice is, "don't do/rely on it: Get an API from the website owner instead".