![]() |
string conversion problem
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. |
All times are GMT +1. The time now is 04:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com