I have a simple code that extracts data from an url and dumps into a new file named vols.csv.

However, I want the data to be posted in the file that has the command object.

Please help me with this... Below is the code

Private Sub CommandButton1_Click()
volURL = "website address/vols.csv"

Workbooks.Open Filename:=volURL

End Sub