09-24-2015 03:22 PM
The X command, if enable in your install, will start any program you can run from a command prompt. Pass the name of the file the program is to open and that should work. You will likely need to have the full path the executeable for Access and use the full path to the file.
09-24-2015 03:42 PM
I'm not sure I follow. Here is what Im trying to do: I have a report that uses SAS to pull and organize the data. Once the program completes, it dumps it into an access database a VBA script will run and produce the excel output. Without having to wait for the SAS program to finish and then clicking on the access database, I would like the SAS program to automatically open the access database and begin running the VBA code that I have. At this point, I just need SAS to somehow open my existing ms access file from a specific location where it resides. My ultimate goal down the road is to code and automate the entire process in SAS.
09-24-2015 04:02 PM
I think it would be a lot easier for SAS to send the required output to Excel directly rather than trying to "daisy chain" it via Access. What is this output?
09-24-2015 04:18 PM
It is a dataset of about 1500 records. It would need to be dumped into an existing excel template, run the VBA macros within excel then save as a new file.
09-25-2015 11:31 AM
09-25-2015 11:33 AM