Excel scripting question
Excel scripting question
- Subject: Excel scripting question
- From: cheri <email@hidden>
- Date: Sun, 08 Apr 2001 18:05:12 -0400
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