How to use VBA to download a link from a website into an already open workbook!! Please Help!

L

lpeters

New Member
Joined
Aug 12, 2011
Messages
8
I am working on a project where i need to go to a website and click on the link to download the file into excel.

I want to make something where it can pull the file into an already open workbook and then refresh it daily. I have had some luck using others codes to actually open the site but then i cant figure out how to download the link. (especially because there are so many to choose from)

The website is http://investor.shareholder.com/bhi/rig_counts/rc_index.cfm

and if you scroll down the link is
North America Rotary Rig Counts - see all 13 tabs in spreadsheet. Rigs by oil vs. gas; trajectory; rigs by state, GOM, etc

Any help would be greatly appreciated!!!
Thanks in advance:)
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
You must log in or register to reply here.

Similar threads

F
  • Question Question
VBA code to activate a already opened Excel workbook using a dynamic naming convention.
Replies
2
Views
279
fwk
F
O
  • Question Question
Simple Code to Download Files from a Website Using List of Links
Replies
3
Views
4K
GWteB
GWteB
V
  • Question Question
Downloading files from protected website with VBA-Excel
2
Replies
10
Views
15K
victorjagu
V
A
  • Question Question
Macro for downloading files from website into excel
Replies
1
Views
1K
jbesclapez
jbesclapez
D
  • Question Question
How to run VBA code in multiple workbooks from one workbook.
Replies
6
Views
3K
dilshod_k
D

Forum statistics

Threads
1,224,502
Messages
6,179,126
Members
452,890
Latest member
Nikhil Ramesh

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top