EditNew topicPost responseAdd to My Interests Previous Next
OLE: Automation Error
Posted by Stuart Banks on 24.Mar.04 at 09:40 AM using a Web browser
Category: Domino DesignerRelease: 6.0.2Platform: Windows 2000
Hi,
I’m having a problem with some code I’ve downloaded from the Sandbox. The code is to export a view into excel. The one I’ve downloaded is:
This is a fantastic exporting tool but my problem is that it works for a few documents and then falls over with:
“Error on Line 172 (213) - OLE: Automation Error”
I’ve looked into the code and line 172 is:
excelSheet.Cells(lngCount, iNumColumns)).value = arrCellValues
Can anyone think why I might be getting this error. I really would like to use this example if I can get it to work.
TIA
Stuart