Hi all,
Hoping someone can guide me or help me?
I have an excel work book which has multiple MSSQL queries which pulls data and puts it in to tables for reports.
The issue I have is I have created an update button (refreash all basicly) however I have to keep entering the password.
I know I can save it to connection however its visable so this does not work.
Is there away to include the password in the refreash all so it only gets entered once and then I can then secure the button.
I think you can write a VBA module to update all connection strings and include the username and password here but not sure where to start.
I am a very basic VBA so as much detail as possible please.
Thank you in advance.
J
Hoping someone can guide me or help me?
I have an excel work book which has multiple MSSQL queries which pulls data and puts it in to tables for reports.
The issue I have is I have created an update button (refreash all basicly) however I have to keep entering the password.
I know I can save it to connection however its visable so this does not work.
Is there away to include the password in the refreash all so it only gets entered once and then I can then secure the button.
I think you can write a VBA module to update all connection strings and include the username and password here but not sure where to start.
I am a very basic VBA so as much detail as possible please.
Thank you in advance.
J
