HunterN
Active Member
- Joined
- Mar 19, 2002
- Messages
- 479
I have completed an Excel Project (with lots of VBA code). In some lines the VBA code references directory paths like C:\myfiles .... , and also c:\program files\sas\sas 9.1\sas.exe. I need to move the project to another drive and directory. Many people will be able to use this project once its on the new drive. I need a way to figure out where the SAS executable resides on the network, just in case it it not in the same place that it was when I created it on my hard drive.
Then once I find the .exe files, I can put this into a variable name and use the variable name for my shell calls. For example:
Call Shell("c:\program files\sas\sas 9.1\sas.exe -splash -icon -sysin 'c:\myfiles\goodlist_to_sas.sas'", vbMaximizedFocus)
This directory path to SAS, may not be the same on someone else's computer that is why I am thinking of doing this.
Thanks for any help here.
Nancy
Then once I find the .exe files, I can put this into a variable name and use the variable name for my shell calls. For example:
Call Shell("c:\program files\sas\sas 9.1\sas.exe -splash -icon -sysin 'c:\myfiles\goodlist_to_sas.sas'", vbMaximizedFocus)
This directory path to SAS, may not be the same on someone else's computer that is why I am thinking of doing this.
Thanks for any help here.
Nancy