I have a workbook in which the user connects to SQL Server Analysis Service Cubes.
The server is not a part of an Active Directory domain and thus Windows Authentication is not an option.
For security reasons storing the password in the excel file is also not an option.
The workbook uses a form and some VBA to update the connection and refresh the pivottables.
That bit is working fine.
The problem is when the password the user specifies is incorrect, Excel is automatically displaying the Multidimensional Connection Wizard. Since I want to completely handle the connection in code, I would like to prevent this from happening.
Is there a way to prevent Excel from showing the Connection Wizard when the password is incorrect?
Thank you for your time.
The server is not a part of an Active Directory domain and thus Windows Authentication is not an option.
For security reasons storing the password in the excel file is also not an option.
The workbook uses a form and some VBA to update the connection and refresh the pivottables.
That bit is working fine.
The problem is when the password the user specifies is incorrect, Excel is automatically displaying the Multidimensional Connection Wizard. Since I want to completely handle the connection in code, I would like to prevent this from happening.
Is there a way to prevent Excel from showing the Connection Wizard when the password is incorrect?
Thank you for your time.
