Applescript to set excel window default size?

[whitecloud1]

I just installed Office 2009 for Mac, having used Office X (a much earlier version). I'm using a small powerbook 12' and found that office programs open in windows which are not maximized and so I always had to use the mouse to drag and expand the window to fill the available screen area.

In Office X I was able to install a VB macro to set default in Word and Excel.
I found a website offering 2 useful applescripts for Word, including
1. Measure the dimensions and zoom of an open Word document (script 1)
2. Alter and save script 2 (template) to do this
3. Add a keyboard shortcut to do this.

Is there a similar option for Excel?
I can supply the original macro if necessary.

John

 

[whitecloud1]

Ok, the duplication has been removed or closed.

I assume the link to "show your sheet" etc. is not relevant to me

John

 

[whitecloud1]

OK, I installed the HTML addin in the correct folder but "Visual Basic Add-ins do not work in Office for Mac" (2008)
That's the error message.

JB

 

[Von Pookie]

No, the 'show your sheet' link is my signature. Nothing to do with your post. Signatures appear at the end of every post a person makes.

As far as the HTML Maker goes, nothing that can be done about that. Excel 2008 for Mac decided to go with AppleScript and remove VBA entirely.

 

[whitecloud1]

Thanks for explaining that. I'll investigate the applescript option. I can still use my Excel X for mac and visual basic.

Thanks
John