AnsweredAssumed Answered

ODBC processbook and excel connection on network

Question asked by RyanVal on Jun 20, 2018

I have an ODBC pulling data from excel into a dataset in processbook. The excel file and processbook files are on a shared network. However when opening the processbook page on another computer the excel file has to be picked each time. Other than setting up a new ODBC on every computer is there a way to have this work on any network computer who opens the processbook file and has access to the excel file? Through settings or perhaps vba?

Outcomes