Two versions of Excel

Scripting Forums AppleScript | Mac OS X
#1

Yesterday, I installed Excel 2011. Excel 2004 is still installed on my machine.

I would like to access some things in the 2004 version (like Help), but can’t figure out how to get that file’s application object. Application “Microsoft Excel” refers to the 2011 version.

How would I do this?
Thanks.

#2

Have you tried changing the app name to “Excel 04” and calling that app?

#3

Fistoprince,
Thanks, for the response.

I’ve been leary of changing anything with Excel 2004. 2011 is buggy (for example, VBA help is virtualy non-existant) and I’m waiting for updates before jumping into the deep end of the pool. :slight_smile:

How would one change the “application name”? Just change the file name of Excel or the folder named (something like) Microsoft Office 2004? Or is “application name” something more involved?

#4

Does this work?


set theApp to (path to applications folder as string) & "Microsoft Office 2004:Microsoft Excel.app" as string

tell application theApp
	tell document 1
		--do you thing here
	end tell
end tell
#5

Thank you DJ. That worked.
This is the test script that worked for me.

tell application "Macintosh HD:Applications:MSOld:Microsoft Office 2004:Microsoft Excel"
	activate
	
end tell

Now all I have to do is figure out how to script the VB Editor Help system. (Unlikely.)