Possibly to refresh data programmatically from VBA?

[MgSam]

Is there a hook into VBA that would allow me to refresh the data programmatically?

Also related- it's annoying that when you click "Refresh" it shows you the connection wizard again. If the connection has been set already why does the user have to go through the wizard again?

Also- bug report here- I've found this tool doesn't work for a large data set of 10,000 rows.

Finally- feature request- a lot of times you want to be able to pass a parameter to your query from a cell in some other tab. There doesn't seem to be any support for this currently.

[Pinturiccio]

Is there a hook into VBA that would allow me to refresh the data programmatically?

We will investigate the possibility to implement such feature and post here about the results as soon as possible.

Also related- it's annoying that when you click "Refresh" it shows you the connection wizard again. If the connection has been set already why does the user have to go through the wizard again?

This behaviour occurs only if you haven't selected the "Allow saving password" check box when importing data. If you select the "Allow saving password" check box, Refresh won't open the wizard.

Also- bug report here- I've found this tool doesn't work for a large data set of 10,000 rows.

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

Finally- feature request- a lot of times you want to be able to pass a parameter to your query from a cell in some other tab. There doesn't seem to be any support for this currently.

We will investigate the possibility to implement such feature and post here about the results.

[MgSam]

This behaviour occurs only if you haven't selected the "Allow saving password" check box when importing data. If you select the "Allow saving password" check box, Refresh won't open the wizard.

But in my case I'm using Windows Authentication, so the state of the "Allow saving password" checkbox shouldn't matter.

[Pinturiccio]

We have reproduced the issue with Windows Authentication. We will investigate it and post here about the results as soon as possible.

[Pinturiccio]

We have fixed the bug with freezing when importing a large number of rows. We will post here when the corresponding build of Excel Add-ins is available for download.

[Pinturiccio]

We have fixed the bug with opening Import Data Wizard when executing Refresh or Edit Mode for SQL Server database with Windows Authentication is fixed. We will post here when the corresponding build of Excel Add-ins is available for download.

[Pinturiccio]

New version of Devart Excel Add-ins 1.2 is released.
It can be downloaded from http://www.devart.com/excel-addins/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=32345