Dear All,
I am working with Exact software, which is working with SQL database.
From the Exact database we can load data into an Excel sheet by putting a querie in a cell, say A5 (we usually use A5 for that purpose)
The querie is started from VBA code:
Set ctlMenuItem = CommandBars("Exact Globe Next").Controls(6) ' that is button 6 from the Excat AddIn
Sheets("DATA").Select
Range("A5").Select
ctlMenuItem.Execute
Btw: The AddIn of Exact has been installed in the menu bar of Excel!
Till recently this worked perfectly for many years.
Recently the procedure generates errors or gives no data at all. Or only the header line repeatedly..
The next VBA command after the "ctlMenuItem.execute" command is not waiting for the database data to be loaded in my sheet "Data".
How can I be sure that data is loaded properly, i.e. can I put some wait command or so ? I mean wait till the data from the database is loaded, and after that proceed in the VBA programm.
Thanks in advance for your answer.
Greetings from Holland!
I am working with Exact software, which is working with SQL database.
From the Exact database we can load data into an Excel sheet by putting a querie in a cell, say A5 (we usually use A5 for that purpose)
The querie is started from VBA code:
Set ctlMenuItem = CommandBars("Exact Globe Next").Controls(6) ' that is button 6 from the Excat AddIn
Sheets("DATA").Select
Range("A5").Select
ctlMenuItem.Execute
Btw: The AddIn of Exact has been installed in the menu bar of Excel!
Till recently this worked perfectly for many years.
Recently the procedure generates errors or gives no data at all. Or only the header line repeatedly..
The next VBA command after the "ctlMenuItem.execute" command is not waiting for the database data to be loaded in my sheet "Data".
How can I be sure that data is loaded properly, i.e. can I put some wait command or so ? I mean wait till the data from the database is loaded, and after that proceed in the VBA programm.
Thanks in advance for your answer.
Greetings from Holland!
