Executing an Excel Macro w/ Vbscript

Discussion in 'Software' started by Mada_Milty, Feb 27, 2006.

  1. Mada_Milty

    Mada_Milty MajorGeek

    I was just wondering if there was a way for a vbscript to execute an excel macro, short of using the sendkeys method to run it via the menu.

    Code:
    Set o_excel = CreateObject ("Excel.Application")
    o_excel.visible = True
    o_excel.workbooks.open c_hardsheet
    This is the code I'm using to open the spreadsheet who's absolute path is contained in the constant c_hardsheet. Is there a property or method of either the excel application, workbook or worksheet objects that will execute a macro in this sheet?

    Any and all help is appreciated.
     
  2. Mada_Milty

    Mada_Milty MajorGeek

    For future reference this link helped me out immensely.
     

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds