Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Currently we have a macro that kicks off different queries to access data
from the same datasource. Before each query runs, it will ask for the userid and password. Unfortunately, we can't save the password because of security reason. So we need type in the same userid & password many times. When the first query runs, the connection to the datasource is established. I was wondering if there is a way we can do to reuse that connection and eliminate the need of repeatedly typing in the userid & password for connecting. Any help is appreciated. Thanks! Sharon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CREATE MACRO TO COPY MULTIPLE WORKSHEETS | Excel Discussion (Misc queries) | |||
Problem executing a macro from different workbook where it is | Excel Discussion (Misc queries) | |||
How do I record a macro which should work on multiple files ? | Excel Discussion (Misc queries) | |||
Executing macro for all worksheet from a different worksheet | New Users to Excel | |||
Macro for multiple charts | Excel Worksheet Functions |