Launch Excel 2004 Macro with AS?

Scripting Forums AppleScript | Mac OS X
#1

Hi there,

i’ve left a post over on the apple discussions at apple.com, but i thought I may try my luck here as well :slight_smile:

I’m trying to find a script that can activate a macro within an Excel 2004 workbook with applescript. The dictionary for excel gives the ‘run VB Macro’ command, but I’ve tried that to no avail. Is there any special syntax I should be using, or is there another method of triggering the macro? Any help at all would be appreciated :smiley: :smiley: :smiley:

Jay :slight_smile:

#2

That makes two of us.

Cept, I want to run all macros then save to web.

dzelnio

#3

Hi,

to be prepared for Office 2008
take a look at VBA-Transition-Guide

#4

It’s taking me weeks to do the simple scripts so I’ll probably not upgrade to 2008 until some script guru comes to work for us.