I am currently trying to open an SQL database and convert it to a CSV file from and external program using VBA commands. I am able to open Excel as well as a template file that has the links to the SQL database, but then a security popup appears (stating that the file is accessing external information - is it secure) that requires an acceptance to continue the process.
My question is: is there a way to accept the popup from VB commands, or can the popup be turned off.
Thanks
My question is: is there a way to accept the popup from VB commands, or can the popup be turned off.
Thanks