topic Re: VBA - Undefined user defined type - type defini par l'utilisateur non défini in VBA Forum

VBA - Undefined user defined type - type defini par l'utilisateur non défini

emile.bergin3WG83 — Tue, 16 Feb 2021 15:22:15 GMT

Dear all,

with VBA in autocad 2021, I want to read inside an excel file.

The code is pretty simple :

Private Sub CommandButton2_Click()
Dim ExcelAppObj As Excel.Application

Set ExcelAppObj = New Excel.Application ' Lance Excel
ExcelAppObj.Visible = True ' Affiche Excel
ExcelAppObj.InputBox ("Coucou de la part d'AutoCAD !") ' Affiche un message depuis Excel
ExcelAppObj.Application.Quit ' Quitte Excel
End Sub

First line "Dim ExcelAppObj As Excel.Application" creates an "Undefined user defined type" error and I cannot understand why. Can someone help ?

Autocad is installed in C:/program files/, so should be 64bits

I use Excel from Office 365

Re: VBA - Undefined user defined type - type defini par l'utilisateur non défini

norman.yuan — Tue, 16 Feb 2021 16:48:16 GMT

Assume you have Excel installed in the computer (any computer where your AutoCAD VBA code is to run).

You need to add reference to MS Excel object library (VBA editor->menu "Tools..."->References...-> select/check the item "Microsoft Excel 16.x Object Library").

Re: VBA - Undefined user defined type - type defini par l'utilisateur non défini

emile.bergin3WG83 — Thu, 18 Feb 2021 09:38:35 GMT

Thanks Norman!

It was already selected ... but did not work.

So I unselect all and reselect ... and it works !!