Excel VBA to enter form data in IE

[SpurmanisA]

Hi everyone,

I'd like to know if there is a way to use VBA to script the automatic activation of a form in a webpage.

I can already use VBA to automate hyperlinking to product pages like:

http://www.sigmaaldrich.com/catalog/search/ProductDetail/SIGMA/I9516

I'd like to activate the MSDS link on this page programmatically (and name and save the pdf file to a specified directory) and have know idea how do this. Straight forward webquerying doesn't work here because the link uses javascript and hidden inputs to call up an associated pdf file from a form.

Can somebody help me out (even if it's to say "This can't be done because...")?

Thanks

Aleks