Hey all,
I have an excel document that when opened takes the users ID and password and creates an OLEDB connection to a Netezza database. I have no problem opening this connection but when the workbook_open sub is finished running, the connection is no longer accessible by other subs/functions. I need a way for this connection to be left open until the file is closed (or activity timed out) so that query parameters can be changed within the excel document and then a query run by a separate macro. I have the connection declared as Public in a regular module but still once that opening sequence is complete that connection value goes away.
Thanks