By synapse5150 - 4/10/2006
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!
|
By Arnie1066 - 5/31/2006
Could you not just program it in VBA (VB for Excel)
If you make a procedure called..
auto_open()
End sub
Code in here will automatically be started when the excel workbook that it is part of runs.
|
|