Using an EXCEL template within VB

Question

I am importing date into a Arizona supplied template for motor fuel taxes.  Normally the user would bring up this template in EXCEL and manually enter the required data on the various worksheets.  After entering the data the user  clicks a button called Calculate Totals on one of the worksheets.  After enabling this button, the data is validated and various totals are calculated.

My question is there any way I can invocke this button from my vb code after I import the requred data?  If so, how?

Answer 1

If I understand correctly this workbook contains macros. If the button click routine is public, you can execute it using the application.run command.

---

Kind Regards, Rich ... http://greatcirclelearning.com