Re: Excel scripting question
Re: Excel scripting question
- Subject: Re: Excel scripting question
- From: David Emmons <email@hidden>
- Date: Sun, 08 Apr 2001 22:12:50 -0400
in VBA it would look like this:
Activecell.offset(1,0).value
not sure in AS...
-Dave
PS: Been doing VBA in Excel since 1995....
>
From: cheri <email@hidden>
>
Date: Sun, 08 Apr 2001 18:05:12 -0400
>
To: <email@hidden>
>
Subject: Excel scripting question
>
>
Hi all,
>
>
I wonder if anyone can help with an excel script that I'm writing...I'm sort
>
of a newbie at this ...
>
>
The script is basically extracting information from one excel document and
>
processing it into a pivot table in another excel document. I have a few
>
places where I need to process the info with subroutines and this is where
>
the questions arise ... Does anyone know the excel syntax for indicating
>
the next cell directly below another cell? I've tried various things from
>
the dictionary, but nothing seems to be working.
>
>
I've put a short example below, but this is only for one cell without the
>
repeat loop. It actually needs to process hundreds of cells.
>
>
>
property microspot : "Microspot Raster"
>
property laserwriter8 : "LaserWriter 8"
>
property adobeps : "AdobePS"
>
property epson : "SC 3000(AT)"
>
>
tell application "Microsoft Excel"
>
Activate
>
>
if (Value of Range "R2C2" is laserwriter8) then
>
set Value of Range "R2C5" to ".09"
>
end if
>
if (Value of Range "R2C2" is adobeps) then
>
set Value of Range "R2C5" to " .09"
>
end if
>
if (Value of Range "R2C2" is epson) then
>
set Value of Range "R2C5" to "6.00"
>
end if
>
if (Value of Range "R2C2" contains phaser) then
>
set Value of Range "R2C5" to " 6.00"
>
end if
>
end tell
>
>
Any help would be appreciated...
>
>
Cheri
>
_______________________________________________
>
applescript-users mailing list
>
email@hidden
>
http://www.lists.apple.com/mailman/listinfo/applescript-users