TotalBeginner
New member
- Joined
- Jul 3, 2012
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hi All
I have recorded this simple macro for getting Data from Web - I have replaced the URL as I have insufficient posts to even post a URL.
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;XXXX", Destination:= _
Range("$A$1"))
Question - how can I make the macro take the URL from a specific cell (say cell A1) on Sheet 1 and then make the destination Cell A1 in Sheet2?
Many thanks in advance.
I have recorded this simple macro for getting Data from Web - I have replaced the URL as I have insufficient posts to even post a URL.
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;XXXX", Destination:= _
Range("$A$1"))
Question - how can I make the macro take the URL from a specific cell (say cell A1) on Sheet 1 and then make the destination Cell A1 in Sheet2?
Many thanks in advance.