Alaska Software Inc. - EXCEL reading values
Username: Password:
AuthorTopic: EXCEL reading values
Reinthaler RudolfEXCEL reading values
on Tue, 13 Jan 2009 10:05:21 +0100
Hello,
has anyone a sample how to read values from EXCEL tables ? Found only 
samples with writing to tables.
regards
Rudolf
Dirk JuckniesRe: EXCEL reading values
on Tue, 13 Jan 2009 10:39:17 +0100
Hi,

    oExcel      := CreateObject( "EXCEL.APPLICATION" )
    IF !( oExcel == NIL )
        oWorkBook := oExcel:workbooks:open(cName)
        aValues := oWorkBook:workSheets(nSheetNr):usedRange:value
    ENDIF

Dirk


"Reinthaler Rudolf" <office@c-tec.at> schrieb im Newsbeitrag 
news:7ad7428$5d418ec8$9f9@news.alaska-software.com...
> Hello,
> has anyone a sample how to read values from EXCEL tables ? Found only 
> samples with writing to tables.
> regards
> Rudolf
>
Reinthaler RudolfRe: EXCEL reading values
on Tue, 13 Jan 2009 11:28:51 +0100
Hello Dirk
thank you, that works for me !
regards
Rudolf


"Dirk Jucknies" <Dirk.Jucknies@mmorthosoft.de> schrieb im Newsbeitrag 
news:3c24e039$68a108e3$828@news.alaska-software.com...
> Hi,
>
>    oExcel      := CreateObject( "EXCEL.APPLICATION" )
>    IF !( oExcel == NIL )
>        oWorkBook := oExcel:workbooks:open(cName)
>        aValues := oWorkBook:workSheets(nSheetNr):usedRange:value
>    ENDIF
>
> Dirk
>
>
> "Reinthaler Rudolf" <office@c-tec.at> schrieb im Newsbeitrag 
> news:7ad7428$5d418ec8$9f9@news.alaska-software.com...
>> Hello,
>> has anyone a sample how to read values from EXCEL tables ? Found only 
>> samples with writing to tables.
>> regards
>> Rudolf
>>
>
>
Jorge LRe: EXCEL reading values
on Tue, 13 Jan 2009 10:35:22 -0300
Hello

You have the detail of all macros (excel, word, etc...) in C:\Program 
Files\Microsoft Office\OFFICE11\3082\VBAXL10.CHM


"Reinthaler Rudolf" <office@c-tec.at> escribió en el mensaje de noticias 
news:6bc544b1$2af364fe$8ab@news.alaska-software.com...
> Hello Dirk
> thank you, that works for me !
> regards
> Rudolf
>
>
> "Dirk Jucknies" <Dirk.Jucknies@mmorthosoft.de> schrieb im Newsbeitrag 
> news:3c24e039$68a108e3$828@news.alaska-software.com...
>> Hi,
>>
>>    oExcel      := CreateObject( "EXCEL.APPLICATION" )
>>    IF !( oExcel == NIL )
>>        oWorkBook := oExcel:workbooks:open(cName)
>>        aValues := oWorkBook:workSheets(nSheetNr):usedRange:value
>>    ENDIF
>>
>> Dirk
>>
>>
>> "Reinthaler Rudolf" <office@c-tec.at> schrieb im Newsbeitrag 
>> news:7ad7428$5d418ec8$9f9@news.alaska-software.com...
>>> Hello,
>>> has anyone a sample how to read values from EXCEL tables ? Found only 
>>> samples with writing to tables.
>>> regards
>>> Rudolf
>>>
>>
>>
>
>
>
Reinthaler RudolfRe: EXCEL reading values
on Thu, 15 Jan 2009 08:32:30 +0100
Hello Jorge
thank you,
regards
Rudolf

"Jorge L" <jlborlando@way.com.ar> schrieb im Newsbeitrag 
news:1fc579b6$10c3f061$f95@news.alaska-software.com...
> Hello
>
> You have the detail of all macros (excel, word, etc...) in C:\Program 
> Files\Microsoft Office\OFFICE11\3082\VBAXL10.CHM
>
>
> "Reinthaler Rudolf" <office@c-tec.at> escribi en el mensaje de noticias 
> news:6bc544b1$2af364fe$8ab@news.alaska-software.com...
>> Hello Dirk
>> thank you, that works for me !
>> regards
>> Rudolf
>>
>>
>> "Dirk Jucknies" <Dirk.Jucknies@mmorthosoft.de> schrieb im Newsbeitrag 
>> news:3c24e039$68a108e3$828@news.alaska-software.com...
>>> Hi,
>>>
>>>    oExcel      := CreateObject( "EXCEL.APPLICATION" )
>>>    IF !( oExcel == NIL )
>>>        oWorkBook := oExcel:workbooks:open(cName)
>>>        aValues := oWorkBook:workSheets(nSheetNr):usedRange:value
>>>    ENDIF
>>>
>>> Dirk
>>>
>>>
>>> "Reinthaler Rudolf" <office@c-tec.at> schrieb im Newsbeitrag 
>>> news:7ad7428$5d418ec8$9f9@news.alaska-software.com...
>>>> Hello,
>>>> has anyone a sample how to read values from EXCEL tables ? Found only 
>>>> samples with writing to tables.
>>>> regards
>>>> Rudolf
>>>>
>>>
>>>
>>
>>
>>
>
>