I have a VB 6 project where I open an Excel worksheet. On that worksheet, there is a button that runs a macro. I don't know how to either: 1) click the button programmatically from VB or 2) run the Excel macro from VB. Any ideas would be greatly appreciated. Thank you!
|