Run time error '429'

N

Newbie

Hello,
I'm trying to open an Excel file from Project.
In a module of a mpp Project file, the following VBA code runs well.
In another mpp Project file, it generates the "Run time error '429' : An
ActiveX component can't create an object"

Set xlApp = GetObject(, "Excel.Application")
If xlApp Is Nothing Then
Set xlApp = New Excel.Application
End If

Why ???
Thanks for help,

Newbie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging Macros 1
Save as (filename,fileformat) from Word VBA will not work 1
Open password protected excel file 2
Excel won't close properly 2
run VBA from Word and copy all Worksheets of an Excel file to Word 2
Macro won't execute on first run, must do it twice 1
Open Excel workbook from Access 4
Import rates from excel via macro 6

Top