macro automatically clicking links in cells

[akxander]

Hey all,

I have a list of links in 1 excel worksheet. They are spaced every other row if it makes a difference. I need to create a macro that clicks on every link automatically. Each link is a direct file that I need downloaded every few months. I have no Macro experience beyond hitting record to automate basic tasks.

cheers!

[Leith Ross]

Hello akxander,

Welcome to the Forum!

Are you referring to HyperLinks? If you are and these have been created using the fomula "=HYPERLINK" then answer is no. You can't use VBA to click them.

[akxander]

Hi,

Thanks for the speedy reply. They are links as follows:

http://XXXX.com/reports/XXXX.aspx?ci...=1&e=57&ft=pdf
That's exactly how it is in the formula. Just the link.

It's a sequential set of links that need to be downloaded.

I hope that answers your question.

Thanks!

[Leith Ross]

Hello AKxander,

Can you post a your workbook or a sample workbook? Since there are different types of Hyperlinks, it will be easier to answer your question with the actual workbook.

[akxander]

Absolutely! Here's a sample version of what I'm trying to work with.

Thanks

[ravishankar]

Hi
try the macro in the attached file
ravi

[akxander]

Hi, I got the error compile error: sub or function not defined.

[Leith Ross]

Hello akxander,

Thanks for posting the workbook. The hyperlinks on the worksheet can be opened from VBA. This macro has already been added to the attached workbook and can be run by clicking the button on "Sheet1".

Please Login or Register  to view this content.

[akxander]

Thanks much! The macro does what I want it to do. My only issue is that the site where I need to download data seems to redirect when I run the macro, but if I go to the link and click on it the file downloads fine. Any ideas?

[Leith Ross]

Hello akxander,

A hyperlink to a URL can have 2 parts. The main page and redirect to another page on the site. I would need to split the addresses and assign them to the proper Hyperlink properties. Can you post the address?

[akxander]

I can post the address I suppose, but I'd also like to know how you do it so I can do it myself in the future.

It's a boat load links, but only 1 digit changes for each file.

I'll load the actual list when I get back to my work laptop if that's what you want.

Thanks!

[akxander]

Sorry my reply took so long. I've been out of town. Anyway, I'll be at my office in an hour or so to upload the xls file. Unfortunately they are password protected links so you have no way of telling if it will work. Still want the file?

thanks a ton!

[Leith Ross]

Hello akxander,

It would help to see the file. There maybe something I am missing about how all this works.

[akxander]

Sounds good. Here is the file.
If it makes a difference, I plan on whittling down that list to about a 10th of the size once I get everything working.
Thanks