CreateObject issue (error 13)

S

sc6po

Hi,
I was trying to exchange data between Visio and Excel with VBA, but it seems
nothing works.
Whatever I do, I always have this Error #13 - Type not compatible.
Got the References for OLE automation and Excel 10.0 / Visio 10.0 and Word
10.0...
Whatever Visio/Excel/Word, type are not compatible.
But, when using Visio, the application is launched. Got some ideas?
Thanks.
Stephen

Public Sub vv()
Dim xlApp As Excel.Application
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
xlApp.Quit
End Sub
 

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

Top