In the Excel workbook I'm using, I have a macro that refreshes the PivotTables, which pull data using the Oracle ODBC.
However, there are several worksheets in the file, and for each one a different instance of the ODBC login is called.
Is there a way to automate this in Excel via macro so that I only have to enter the username/password info once for the entire workbook when it refreshes the data, rather than several times?
However, there are several worksheets in the file, and for each one a different instance of the ODBC login is called.
Is there a way to automate this in Excel via macro so that I only have to enter the username/password info once for the entire workbook when it refreshes the data, rather than several times?
