ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   string conversion problem (https://www.excelbanter.com/excel-programming/373276-string-conversion-problem.html)

tr.andrus

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