Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I am trying to create an automation program for Excel. I have found this article http://support.microsoft.com/kb/216686 and everything works fine. But there's one problem. I need to access "ID" property of a cell, not just a "value". For "value" property, I can read and write with array, so it is done in few seconds with millions of data. But for "ID" property, I can only access one cell at a time, so I have to play with loop things, and it is toooooooo slow. If I set range and use it for getting "ID" property, it fails with code "0x80020005". Is there any way to access with array for excel properties? Thanks in advance. With BR, Daniel Kim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Please help, Preparing properties automation needed? | Excel Discussion (Misc queries) | |||
Multidimensional Arrays as Properties in Class Files? | Excel Programming | |||
Automation Error(-2147467259) in Properties Collection | Excel Programming | |||
Automation Error(-2147467259) in Properties Collection | Excel Programming | |||
How can I access/display File -> properties in a cell | Excel Discussion (Misc queries) |