Hi,
Sorry. This is straight-forward. Amend a connection from table to sql to call a stored proc. My existing code will work, which deletes all connections in an excel workbook.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
Is it possible to delete a power query via Excel interop? Or stop it refreshing?
My process is Open spreadsheet, Refresh all (get the latest data from SQL Server), Delete connections, send to internal customer.
But I do not want the power query to still be there.
Alternatively is there a different option from power query (and VAB) to call a SQL Stored proc.
Thanks
Hi,
Sorry. This is straight-forward. Amend a connection from table to sql to call a stored proc. My existing code will work, which deletes all connections in an excel workbook.