Short and Sweet: How do you deploy a spreadsheet that has queries in it?
Longer Explanation:
I figured out how to automate the process of pulling data out of a text file downloaded from another computer, I created an MS:Text Driver in ODBC, defining fields and a special delimiter "|", and specifying field types. I noticed that a schema.ini file was created in the folder with the text file, and that the odbc folder on the C: drive contains the dsn file for the connection to the text file.
The queries are all created and the spreadsheet works like a dream.
But now I want to deploy the finished product to a shared resource on the network, so that other people can run it.
What I can't figure out, is how to move the program to another folder, and how to make it work without going through some kind of install on each work station.
Any suggestions?
Longer Explanation:
I figured out how to automate the process of pulling data out of a text file downloaded from another computer, I created an MS:Text Driver in ODBC, defining fields and a special delimiter "|", and specifying field types. I noticed that a schema.ini file was created in the folder with the text file, and that the odbc folder on the C: drive contains the dsn file for the connection to the text file.
The queries are all created and the spreadsheet works like a dream.
But now I want to deploy the finished product to a shared resource on the network, so that other people can run it.
What I can't figure out, is how to move the program to another folder, and how to make it work without going through some kind of install on each work station.
Any suggestions?