Extract Data from Web link

[shahzeb123]

Hi guys,

I am getting too much help from all of you guys. I am overwhelmed. Thank you so much

Now my query is i need to extract online exchange rate table from web.

The link is Currency Exchange Table (US Dollar - USD) - X-Rates

I have done this by "GET EXTERNAL DATA - FROM WEB"

However, what i want to do is to have a button for this so that when i click on the button it fetches the current data from web.

Hoping you guys can help me as always, waiting for the positive response.

 

[alansidman]

Build your query and close and load to your workbook. then create a command button and attach this VBA code to the button

Private Sub CommandButton1_Click()
ActiveWorkbook.RefreshAll
End Sub

 

[shahzeb123]

Thanks its work great !

Little help also, can we add a dialog box where it says "Update Complete" and on cell A1 it writes the current date and time.

Thanks for your help.

 

[alansidman]

Private Sub CommandButton1_Click()
ActiveWorkbook.RefreshAll
MsgBox "Update Complete"
Range("A1")= Date & Time
End Sub

 

[shahzeb123]

It is working great as always. Thank you so much.

However, I am not sure its me over thinking or its real, The dailog box pop up before the update. Meaning when i clik OK on update complete dailog box , the pag is still loading