Re: Excel scripting question
Re: Excel scripting question
- Subject: Re: Excel scripting question
- From: "Kabbes, Dan-DLI" <email@hidden>
- Date: Mon, 09 Apr 2001 07:24:27 -0400
Hi Cheri;
I have used the following method when moving to the next row in Excel 98.
Try splitting the row and column identities into multiple elements. Use your
repeat loop to increment the row number, and put it back together as a
string. The string is your cell range. Here is a rough example:
snippet not tested but it works in theory
tell application "Microsoft Excel"
Activate
set rowNum to 1 --the starting row
repeat with i from rowNum to 20--the number of repeats
set theCell to "R" & rowNum & "C5" as string
set printerName to text of Cell theCell
--do the other stuff
end repeat
end tell
Very rough, I know, but I am not sure what else you may need to do.
Good luck
Dan Kabbes
>
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.