Automating Excel from VB 6

• • Reply

  14 years ago

  by synapse5150

  Scott Utecht

  St. Louis, United States

  Joined 14 years ago

  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!

  Report abuse
• • Reply

  14 years ago

  by ErwinB

  Erwin Bergsma

  Leuven, Belgium

  Joined 15 years ago

  I don't know how to click the button, but running the assigned macro is pretty straightforward:

  oExcel.Run ("YourMacroName")

  Where oExcel is the instance of the Excel-object.

  I hope this helps,

  Erwin

  Report abuse