Based on what you're telling me I think you may go another route. I also use the Putty suite of applications. Two components that would play a role in what you want to do is PLINK (to send a script to execute) and PSCP to copy files. Since the beginning and end of your process requires VBA then I think it's best to create a BAT file that will do the following: execute the VBA script in #2, transfer the files using PSCP for #3, execute the SAS logic (.sas file) using PLINK to transfer and execute an shell script from your machine for #4, download the exported Excel file using PSCP for #5 and execute the VBA code, and finally for #6 I would hope you can email the end result using VBA. http://www.chiark.greenend.org.uk/~sgtatham/putty/ Minus the VBA components I use the above process every week.
... View more
