Dear Experts !
I have two sheets in excel
1. Query
2. Data
The query sheets returns the url correctly for which I have written below code
Sub Retrieve()
Dim Webquery As String
Webquery = ActiveWorkbook.Worksheets("Query").Cells(1, 1).Value
End Sub
Problem
Now, I need to continue this code to to populate data in sheet named data. It is not a query table. the Moment Webquery string output is executed, data comes to excel sheet.
Now, how do I execute output of Webquery at cell A1 in sheet "Data'
Bookmarks