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.

.

Relevant Pages

  • Re: Need help with SeriesCollection Object Please !
    ... Well Peter your explanation of my questions make sense and are sound answers. ... You seem very experienced with Excel and VBA:) ... Function GetSourceSheet(sFmla As String, sWSname, sFile As String) As ... ran my code on certain other charts sometimes it would return ...
    (microsoft.public.excel.programming)
  • Re: Format Excel - Object required error
    ... tell excel to autofit the columns. ... Public Sub FormatXLReport(strPath As String, ... Dim blnExcelExists As Boolean ... Private Const SW_SHOWNORMAL = 1 ...
    (microsoft.public.access.modulesdaovba)
  • Re: XP and string paths
    ... > the "Lcase" function is suddenly no longer available to Excel? ... > that occurs because of Windows XP. ... > string functions that Excel uses has become ... > is the usual "missing reference" problem. ...
    (microsoft.public.excel.programming)
  • RE: Issue with UNC Path (I think). Trying to build Dynamic Report
    ... Dim strBroker As String ... You may just have to determine the UNC path, ... Table and then suck in all the data from my Excel sheet on the network drive. ...
    (microsoft.public.access.formscoding)
  • Re: Opening Excel from Access
    ... Tried changing it to an MDB but no luck. ... Dim MDBName As String, DefaultDirectory As String, SQLStg As String ... .RefreshStyle = xlOverwriteCells ... comes when I click the button on Access form to show the Excel file. ...
    (comp.databases.ms-access)
Loading