Just the tip
12-15-2012, 12:12 PM
Hello all, this is my first post!
I've been tinkering with vba for a couple of years and I've recently encountered this problems using an object from a non office application. The code is as follows:
Dim LSapp As LSPLUS.Document
Dim Result As Boolean
Dim Path As String
Path = "F:\yadayadayada\lalala.lbe"
Set LSapp = CreateObject("Label32")
LSapp.ShowWindow (1)
Result = LSapp.Label.OpenLabel(Path)
This code works, it opens the Labelstar app and loads a file. The program is left open and I want to use the object again, like I would do with an excel.application.
Therefore I use this code:
Set LSapp=GetObject(,"Label32")
Unfortunately I get an error 429: ActiveX component can't create object!
What should I do?
Thanks in advance!
I've been tinkering with vba for a couple of years and I've recently encountered this problems using an object from a non office application. The code is as follows:
Dim LSapp As LSPLUS.Document
Dim Result As Boolean
Dim Path As String
Path = "F:\yadayadayada\lalala.lbe"
Set LSapp = CreateObject("Label32")
LSapp.ShowWindow (1)
Result = LSapp.Label.OpenLabel(Path)
This code works, it opens the Labelstar app and loads a file. The program is left open and I want to use the object again, like I would do with an excel.application.
Therefore I use this code:
Set LSapp=GetObject(,"Label32")
Unfortunately I get an error 429: ActiveX component can't create object!
What should I do?
Thanks in advance!