Excel.Application

Question

Bonjour,

J'essaye de créer un fichier excel de word (VBA).

Par contre, dès le début de mon code, j'ai une erreur avec la première ligne.

Que ce passe-t'il?

   Dim xlpp As Excel.Application

Erreur de compilation

Merci,

Answer 1

If you are going to use Early Binding based on your declaration of  xlpp in that way, you will need to set a reference under Tools>References in the Visual Basic Editor to the Microsoft Excel 16.0 Object Library.

If your application is likely to be used by people with earlier versions of Office, you should use Late Binding as follows:

Dim xlapp As Object

Dim xlbook As Object

Dim xlsheet As Object

On Error Resume Next

Set xlapp = GetObject(, "Excel.Application")

If Err Then

    bstartApp = True

    Set xlapp = CreateObject("Excel.Application")

End If

On Error GoTo 0

When you use Late Binding, you do not need a reference to the Excel Object Model and your code will run on any version of Office.

See the article "Early vs. Late Binding” at:

http://wordmvp.com/FAQs/InterDev/EarlyvsLateBinding.htm