Hi, I am newbie in SAS. I am trying to run a sas code via VBA after setting up SAS Reference in VBA. However i am getting an error massage "Active X component Cann't create object". please note i am using BASE SAS 9.3 and windows 7- 64 bit and excel 64 bit too. for me its seems like, VBA is unable to communicate with SAS and its unable to create a workspace object at first place. I have tried my best but didn't get any concrete answer through google. Expert please advise and help me. Thanks a lot in advance for giving your valuable time to look into this.
... View more