Bricscad VBA cannot open excel file for retrieve cells values

david_forgiarini
david_forgiarini
in Programming and customization

I'm running on Bricscad 13 (32 bit ) with VBA extension and Excel 2010 (32 bit).Win 7 (64 bit) I have added reference. I have the following problem:
If I used the instruction Object

Dim exapp As Excel.Application ( GETTING ERROR )
Dim exapp As Object ( WORKING )
Dim wsheet As Excel.Worksheet
Dim cll As Excel.Range
Dim rg As Excel.Range
Dim pt(2) As Double

Set exapp = CreateObject("Excel.Application") // HERE I GOT THE ERROR

If I use Object but my file is closed the VBA is not able to open the file correctly. ( working great if excel is open with my file open ).

Any suggestions ? Thanks to everybody