AnsweredAssumed Answered

Do you have a piece of VBA code that will auto-connect to the default server within Excel?

Question asked by Bakerr on Oct 31, 2019
Latest reply on Oct 31, 2019 by tperovic

I am using PIPUTVAL to allow operators to input sample data into the database.  Everything works exactly like I would like it to on my computer.  However, when I moved the Excel Workbook to the network, it stopped working.  I traced the problem to their connection to the database on their computer.  For some reason, their machine will not automatically connect to the default server.  When I open the workbook and force a connection then run my code, it works.  I don't want to get called at 4am just because they don't make the connection first.  So my question is, do you have a piece of VBA code that will auto-connect to the default server?

Outcomes