Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Heres my setup.
I have an Excel Workbook that receives data from a SqlServer Database thru an Access DataBase. Currently, I have eleven(11) Access queries running against the SQL Server Database. The Excel Workbook has twelve(12 worksheets). One sheet per query plus a summary sheet. Heres the problem whenever the worksheet is refreshed. the login is for the SQL Server database is required eleven(11) different times. How do I reduce the number of times the login is required? I've read where I should use a macro, I have zero experience using Macros and just a smidgen more in using Excel. Any help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA Code to Login to Excel | Excel Discussion (Misc queries) | |||
Inserting windows login name to a new column? | New Users to Excel | |||
Login and logoff to active directory by VBA | Excel Discussion (Misc queries) | |||
Q:Excel/ODBC/Login .... | Excel Discussion (Misc queries) | |||
How can I make a login styled spreadsheet? | Excel Discussion (Misc queries) |