Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
developer
active.documents
automation
binary.file_format
clipboard.dde
com.add_ins
hosting.controls
internet_other
office.sdks
officedev
officedev.other
outlook.forms
outlook.vba
smarttags
vba
web.components
  
 
date: Thu, 11 Sep 2008 01:55:01 -0700,    group: microsoft.public.office.developer.automation        back       


How to access properties with array?   
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
date: Thu, 11 Sep 2008 01:55:01 -0700   author:   Daniel Kim

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us