Using VB in Excel to pull data from certain websites

X

xXMCP1317Xx

New Member
Joined
Jun 16, 2011
Messages
4
Lets say column A1:A100 has FEDEX training numbers. Then is column B2:B100 I have the following address repeated "http://www.fedex.com/Tracking?clienttype=dotcom&ascend_header=1&cntry_code=us&language=english&mi=n&tracknumbers=" So in cell C1 I do a concatenate(B1,A1) to make a whole tracking url.

Is it possible to create code that will go to the url and specifically only pull the delivery date from the FEDEX website.
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
You must log in or register to reply here.

Similar threads

M
  • Question Question
VBA that pulls data based on multiple criteria
Replies
0
Views
294
Mouse7681
M
G
  • Question Question
Open Google Chrome via VBA Using Cell
Replies
0
Views
5K
Guard913
G
S
  • Question Question
VBA to get distance between two Postcodes using Bing API giving 400 error on certain lines.
Replies
1
Views
1K
John_w
J
J
  • Question Question
Copy column data from worksheet to .htm file (notepad) using VBA
2
Replies
14
Views
2K
johnnywinto
J
D
  • Question Question
Using VBA to search over multiple sheets and paste data into new one
2
Replies
11
Views
7K
abhi221996
A

Forum statistics

Threads
1,223,239
Messages
6,170,947
Members
452,368
Latest member
jayp2104

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