Sorry in advance, I may not explain myself correctly.
I have downloaded the trial version of the software, and would like to know if there is a way to compile only a specific test string
I have a macro that uses an SQL query to connect to our ERP systems database to bring back specific results for a dashboard. I want to try and use the compiler to hide the specific location of the servers.
For example, to connect to the ADODB.Connection (to another Excel document) I use (parts extracted);
Server_Name = "\test1server\test1.xlsm"
Default_Dir = “\test1server”
“DSN=Excel Files;DBQ=” & Server_Name & “;DefaultDir=” & Default_Dir & “;DriverId=1046;MaxBufferSize=2048;PageTimeout=5;”
Can I use the compiler to hide the server name and directory so when the macro runs it’ll access the server_name and Default_Dir strings from the compiled data?