Welcome to MacForumz.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

Excel VBA to applescript

 
   Macintosh computer (Home) -> General Discussion RSS
Related Topics:
AppleScript warning - Hi, scripts written for older versions X) may not work unchanged with 2008. I recommend using Script Editor to save all of your scripts as plain text files before even Office 2008! even if older versions are still on..

Strange Excel Problem (not printing): Excel 2004 & Leopard - Hi - I'm new here, and I'm happy to see a forum like this around - this is the first time I've stumbled on it. I recently installed Leopard, and I'm waiting until Office 2008 comes to our campus (i'm a staff member at UT). In the meantime, Excel is..

Excel - In Workbook 1 I have a column of numbers. In Woorkbook 2 I have the identical column of numbers. When I change the numbers in Workbook 1 how can I set it up so that the numbers in Workbook 2 change I know how to do it if I am in the same..

Excel in OS X - When I click on Format - Cells all I get is the sun spiral. The only way to get rid of it is Force Quit. Needless to say I can't format dates or numbers.

Excel in OS X - We have a problem when using SMB to connect our file servers (NT & 2003) and it has forced us to switch back to As one step of our Mac folks need to make Excel exhibits linked to one or more Excel files (.dat) as the data
Next:  General Discussion: Word, Excel, PP crash on start, Entourage OK - MS Office 2..  
Author Message
justo

External


Since: Feb 26, 2008
Posts: 1



(Msg. 1) Posted: Tue Feb 26, 2008 9:25 pm
Post subject: Excel VBA to applescript
Archived from groups: microsoft>public>mac>office (more info?)

How do I refer to a cell relative to the activecell in
applscript and then make it the activecell? when apple
scripting?
The Excell 2004 applescript reference manual "How to reference cells and ranges" page 15-18 are all absolute
reference examples. As far as I can see.

 >> Stay informed about: Excel VBA to applescript 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 3827



(Msg. 2) Posted: Wed Feb 27, 2008 5:55 am
Post subject: Re: Excel VBA to applescript [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

In article <ee8eecc.-1.RemoveThis@webcrossing.caR9absDaxw>, justo.RemoveThis@officeformac.com
wrote:

> How do I refer to a cell relative to the activecell in
> applscript and then make it the activecell? when apple
> scripting?
> The Excell 2004 applescript reference manual "How to reference cells and
> ranges" page 15-18 are all absolute
> reference examples. As far as I can see.

One way:

tell application "Microsoft Excel"
set rng to (get offset active cell row offset 2 column offset 3)
select rng
end tell

 >> Stay informed about: Excel VBA to applescript 
Back to top
Login to vote
Display posts from previous:   
   Macintosh computer (Home) -> General Discussion All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]