Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,588
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How could VBA connect with another customized application programm Ella Excel Discussion (Misc queries) 1 October 20th 07 11:40 PM
How could VBA connect with another customized application programm Ella Excel Programming 1 October 18th 07 04:29 AM
Best way to learn to programm with Excel BTNA Excel Programming 2 April 28th 07 04:22 PM
Where to put the sub-programm, GetOpenFile Mark van der Sluis Excel Programming 1 September 16th 04 12:27 PM
how to set excel pagebreak in programm chengquan Excel Programming 0 August 12th 03 10:02 AM


All times are GMT +1. The time now is 11:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"