Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to run an apple script that incorperates an excel file and
I keep getting an error. The programmer is out of town. The error message from the script is: "Can't make «class pval» of «class ccel» "R5C3" of application "Microsoft Excel" into type string" The section of apple script code that produces the error is (braces show where the error occurs): -- getting values from excel repeat with x from 1 to maxRows set ctID to the Value of Cell ("R" & x & "C1") as string set ctMName to the Value of Cell ("R" & x & "C2") as string set ctMNum to the Value of Cell ("R" & x & "C3") as [string] set ctIDate to the Value of Cell ("R" & x & "C4") as string set ctXDate to the Value of Cell ("R" & x & "C5") as string I tried setting the value of all the cells to "text" as to avoid the other special date classes and such. Can anyone give me a clue as to what might be wrong? Any help would be much appreciated. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
String formula conversion | Excel Discussion (Misc queries) | |||
dot / comma and string to double conversion | Excel Programming | |||
Simple String Conversion - HELP | Excel Programming | |||
Range < - String conversion. | Excel Programming | |||
String to Array Conversion | Excel Programming |