Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How could VBA connect with another customized application programm
The situation is that.
Right now I have the VBA code as below: Dim test Sub macro1() On Error Resume Next Dim x As Variant If test < Empty And test < Null Then x = test.end() Set test = Nothing End If On Error GoTo 0 Set test = CreateObject("Place.interface") End Sub And there is also a customized appllication programm is with title"Place". And this one a user interface that you could see the detail progress of the data processing. But where I could find the definition of the object "Place", and also class "interface". And also the class of "test". I am confused. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How could VBA connect with another customized application programm
Does your "Place" application support COM automation?
That is, does it have a scripting interface? Tim "Ella" wrote in message oups.com... The situation is that. Right now I have the VBA code as below: Dim test Sub macro1() On Error Resume Next Dim x As Variant If test < Empty And test < Null Then x = test.end() Set test = Nothing End If On Error GoTo 0 Set test = CreateObject("Place.interface") End Sub And there is also a customized appllication programm is with title"Place". And this one a user interface that you could see the detail progress of the data processing. But where I could find the definition of the object "Place", and also class "interface". And also the class of "test". I am confused. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How could VBA connect with another customized application programm
It doesn't.
It is just one small window with kinds of bottons there,but I have no idea how this is created. What kind of tool is used. It is a "exe" file. And how it is connected with the vba. At least I could find any useful information on the website? Do you have any idea what might it related with? And it is an old program,written in 1997. On Oct 18, 4:10 am, "Tim Williams" <timjwilliams at gmail dot com wrote: Does your "Place" application support COM automation? That is, does it have a scripting interface? Tim "Ella" wrote in message oups.com... The situation is that. Right now I have the VBA code as below: Dim test Sub macro1() On Error Resume Next Dim x As Variant If test < Empty And test < Null Then x = test.end() Set test = Nothing End If On Error GoTo 0 Set test = CreateObject("Place.interface") End Sub And there is also a customized appllication programm is with title"Place". And this one a user interface that you could see the detail progress of the data processing. But where I could find the definition of the object "Place", and also class "interface". And also the class of "test". I am confused.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How could VBA connect with another customized application programm | Excel Discussion (Misc queries) | |||
How could VBA connect with another customized application programm | Excel Programming | |||
Best way to learn to programm with Excel | Excel Programming | |||
Where to put the sub-programm, GetOpenFile | Excel Programming | |||
how to set excel pagebreak in programm | Excel Programming |