PDA

View Full Version : Macro To Start An External Tool Process?



tonyrosen
06-20-2007, 12:17 PM
We have some Excel files that we need to upload to HP's Quality Center. I have written all the macros to do what I need them to; however, there is one that I can't figure out.

To upload to Quality Center from Excel, there is an add-in that has to be run. To run this add-in, I click "Tools -> Upload to Quality Center" ...

I don't need the macro to do the upload, I just want it to simulate the user clicking "Tools -> Upload to Quality Center" so that the user does not have to do it.

Is this possible?

Bob Phillips
06-20-2007, 12:21 PM
Set a reference to the addin in the VBIDE, then just call that procedure from your VBA code.