Opening A Excel Workbook with Embedded Connections Using VBA and Auto Refreshing

Hello

Quick question:

I have an Excel Workbook with Showcase Queries embedded into it.

Upon a manual open, the user is prompted to either refresh data or keep data since last save, the user then has to enter a username and password to allow the query to access the database.

Using the code below to open the workbook, no such prompts are given. Is the code overriding the prompts and automatically refreshing the data without password? [Given nature of data, visual validation of refresh is not possible]

If not, how can we code a data refresh through showcase query with user/pw req's?

Thanks!

Please Login or Register  to view this content.

bumpbumpbump