Macro that will create a link and send me to a website based on information in cell?

[AnthoHead]

I'll try to explain this the best I can.

I'm looking to build a Macro that I can use to hyperlink a specific set of numbers to open a website that will access the information based on those numbers. the problem is that the website opens a collection of boxes and I only need the numbers to go into one of those boxes and click search. It would then pull up the document I need.

I have this setup for a different set, but that one only has one box to fill in and the set of numbers is in the link address whenever you go to that site.

The sites are intranet sites so sharing them won't help, but the another way to look at it would be to click on a link that will automatically sign me in.

Any suggestions?

 

[ssingh75]

I'll try to explain this the best I can.

I'm looking to build a Macro that I can use to hyperlink a specific set of numbers to open a website that will access the information based on those numbers. the problem is that the website opens a collection of boxes and I only need the numbers to go into one of those boxes and click search. It would then pull up the document I need.

I have this setup for a different set, but that one only has one box to fill in and the set of numbers is in the link address whenever you go to that site.

The sites are intranet sites so sharing them won't help, but the another way to look at it would be to click on a link that will automatically sign me in.

Any suggestions?

Try to read the text box name using innerHTML in your code,