Refesh data connection based on Network URL Sheet "Website"

[howard]

I have a spreasheet that is updated by selecting Refresh Data and the data is imported into sheet "Data"

I have the Network address on sheet "Website" in cell A1

I would like a macro to refresh the data based on the Website address on sheet "Website' in Cell A1 so that if this changes, the data will refresh based on the correct address on my network for eg http://172.35.45.94/Reports/Accounts Receivable/Dec 2022


Your assistance is most appreciated

 

[howard]

I have come up with this code to refresh the data

[code[ Sub RefreshData()

With Sheets("Data").QueryTables.Add(Connection:="http://172.35.45.94/Reports/Accounts Receivable.cfm?monthreported=" & Sheets("Macro").Range("a1"), Destination:=Range("$A$1"))
End With
End Sub [/code]


However, when running the macro, I get a run time error 1004 "Appliction-defined or object-defined error


It would be appreciated if someone could kindly amend my code

 

[howard]

I have also posted on Macro to Refreh Data