Visual Basic Code , VB.NET Code, VB Code
  Home   :  Code   :  Forums   :  Submit   :  Mailing List   :  About   :  Contact


VB6 / Excel question


VB6 / Excel question

Author
Message
synapse5150
synapse5150
Forum God
Forum God (423 reputation)Forum God (423 reputation)Forum God (423 reputation)Forum God (423 reputation)Forum God (423 reputation)Forum God (423 reputation)Forum God (423 reputation)Forum God (423 reputation)Forum God (423 reputation)

Group: Forum Members
Posts: 5, Visits: 8
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!
Arnie1066
Arnie1066
Forum God
Forum God (1.2K reputation)Forum God (1.2K reputation)Forum God (1.2K reputation)Forum God (1.2K reputation)Forum God (1.2K reputation)Forum God (1.2K reputation)Forum God (1.2K reputation)Forum God (1.2K reputation)Forum God (1.2K reputation)

Group: Forum Members
Posts: 10, Visits: 27
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.

signature coming soon....



or as soon as i find something whitty to say :o)
GO


Similar Topics


Reading This Topic


Login
Existing Account
Email Address:


Password:


Social Logins

Select a Forum....

















A1VBCode Forums


Search