Office Dev Center >
> 
> 
Using an EXCEL template within VB

Unanswered Using an EXCEL template within VB

  • Friday, May 04, 2012 4:44 PM
     
     
    Sign In to Vote
    0

    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?

    • Moved by Cindy Meister MVPMVP Saturday, May 05, 2012 7:15 AM Excel-specific question; not using VSTO technology (From:Visual Studio Tools for Office)
    •  
     

All Replies

  • Friday, May 04, 2012 10:57 PM
     
     
    Sign In to Vote
    0
    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