Originally Posted by dbs179

Fumei and Charles,





2. All of my coding is reliant on file location, which right now is on my desktop, however in the future, it may or may not be, and I may even have other users running this code. What is an easy and effective way to handle that? An option I have used in the past with other coding projects I have undertaken is placing all of the working documents in the same folder and then being able to use the directory of that folder once a file is opened. For example, I've used AutoIT in the past to automate a different process. Once the .exe I created was launched it was able to determine the path the .exe was located at and used that as a variable.


End Sub