Ms access screenupdating
Activate Call Make Connection("fd Master Temp") For i = 1 To rcount - 1 rs.
It appears there are two available data sources: 1 - For one off queries (which is typically me) - Once I query an ICP once via the website form, the data is downloadable at icp here)Once this CSV is available online, import into Excel is simple.
Thanks a lot, Nathan Okay, so with a fair bit of googling I have figured out working VBA code.
It provides one long string of data, but it's a start. The ICP number is a named range in Excel and replace "KEY" with your individual authorisation token. Open "GET", my URL, Falsewin Http Request Header "Ocp-Apim-Subscription-Key", "KEY"win Http Req.sendresult = win Http Req.response Text I've put together a spreadsheet that works in Excel for Windows that downloads one ICP's details and populates cells with the following parameters with good consistency: ICP, Unit, Number, Street, Suburb, Town, Region, Post Code, Network, GXP, Reconciliation Type, Generation, Fuel, Network Price Category, Loss Factor, Trader, MEP, Profile, AMI flag.
Clear Contents s Conn Params = "ODBC; DSN=MS Access Database;" & _ "DBQ=" & db Path & db File & ";" & _ "Default Dir=" & db Path & ";" & _ "Driver Id=25;" & _ "FIL=MS Access;" & _ "Max Buffer Size=2048;" & _ "Page Timeout=5;" & _ "Destination:=Sheet11.range(""J1""))" s SQL = "SELECT DISTINCT [Staff Team] FROM " & db Name & " WHERE (" & db Name & ". Refresh Background Query:=False End With Range("J1").
Save Data = True ' use false to speed up the execution and return of sql query .