LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Applescript question

I had an extensive set of Applescripts that I used to use in Excel X. When I
switched to Excel 2004 for Mac, the scripts were rewritten automatically by
the computer. If I look at the identical files on another computer using
Excel X, they return to the way I originally wrote them. I have now started
to rewrite them for Excel 2004, but I am getting hung on trying to identify a
row and column number from the active cell. Here is the script;

tell application "Microsoft Excel"
activate
set RowNum to row of active cell
set ColNum to column of active cell
set formula r1c1 of active cell to "Comm"
set ColNum to (ColNum + 3)
set NewRange to "R" & RowNum & "C" & ColNum
select range NewRange
set formula r1c1 of active cell to "Commission€”GSA"
set ColNum to (ColNum + 1)
set NewRange to "R" & RowNum & "C" & ColNum
select range NewRange
run script alias "OS X
Boot:DOCUMENTS:AppleScripts:SigTaxScripts:SigCheck Num.scpt"
end tell

It works until I hit the line "set ColNum to (ColNum + 3)" at which point it
hangs and highlights the "3". I believe I am not getting the script to return
the row number and column number of the active cell properly. Does anyone
know how to do this, or know of any resource where I could search to discover
this? I tried the "Excel 2004 AppleScript Ref.pdf", but unfortunately it
didn't talk about this aspect.

Any suggestions would be greatly appreciated. I'd hate to have to go back to
Excel X or switch to QuicKeys when I am so close to getting it to work again.

Thanks,
Tom Carlson
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Applescript: get range of selection Richard8A Excel Discussion (Misc queries) 0 September 26th 08 01:59 AM
How to record Excel with AppleScript? Recordable or not? ChipMck Excel Discussion (Misc queries) 0 June 27th 08 01:39 AM
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you [email protected] Excel Programming 0 April 22nd 05 03:30 PM
Need Applescript for Converting Upper/Lower Case Br0wn Recloose Excel Programming 3 July 2nd 04 08:23 AM
Applescript Problem Alex Sossick Excel Programming 0 January 6th 04 05:27 PM


All times are GMT +1. The time now is 05:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"