opening SPSS and a macro from Excel VBA
What exactly are you up to with SPSS. If it is Essbase then there are a whole
pile of API's that you can access. If it is Showcase then you are much more
limited. Post your code and give us a better description of what you are up
to.
--
HTH...
Jim Thomlinson
"alphapoint05" wrote:
I have Excel VBA code that opens and passes a worksheet to SPSS. This
has not been a problem. Right now, Excel now tells the user to open and
run a file called Run.sbs once SPSS opens. I would like to skip this.
In other words, how would I program Excel to open SPSS and then run the
syntax with no user operations?
Thanks,
Jeff Miller
|