ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problems with Automaint Excel (https://www.excelbanter.com/excel-programming/423280-re-problems-automaint-excel.html)

NOPIK

Problems with Automaint Excel
 


Data * * * * * *{System.Collections.ListDictionaryInternal}

* * * * * * * * Count * * * * * 0
* * * * * * * * IfFixedSize * * False
* * * * * * * * IsReadOnly * * *False
* * * * * * * * IsSynchronized *False
* * * * * * * * Item * * * * * *In order to evaluate an indexed property, the property must be
qualified and the arguments must be explicitly supplied by the user.



Looks like there is no Template for your current context...
Did you tried to provide any?
Have you tried to open existing file?

NOPIK

Problems with Automaint Excel
 
Oops!

oXLBook = oXLApp.Workbooks.Add ???
For VB, objects assigned with SET (equlality will copy properties
between objects):
set oXLBook = oXLApp.Workbooks.Add


All times are GMT +1. The time now is 12:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com