I have a VBA macro with the following line of code that pulls data using a data connection to a website:
[url removed, login to view] BackgroundQuery:=False
Every time the internet stops working (even momentarily) the macro goes into debug mode and I get a message box warning that the query was not able to refresh. This is extremely disruptive. Instead, I would like to enter a loop that keeps attempting to refresh the query. The loop would end if the query is successful (i.e., no error).
3 pekerja bebas membida secara purata $28 untuk pekerjaan ini
I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document an Relevant Skills and Experience VBA Proposed Milestones $25 USD - d