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 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.

 
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
String formula conversion Erik Excel Discussion (Misc queries) 1 February 13th 10 01:09 AM
dot / comma and string to double conversion snaggy^^ Excel Programming 2 January 30th 06 07:56 PM
Simple String Conversion - HELP prepotency[_3_] Excel Programming 4 June 10th 05 02:56 PM
Range < - String conversion. y Excel Programming 3 April 8th 04 12:01 AM
String to Array Conversion Ussiddiqui[_14_] Excel Programming 1 January 31st 04 10:04 AM


All times are GMT +1. The time now is 09:41 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"