Solved

ActiveX exe start up

Posted on 2000-04-09
14
150 Views
Last Modified: 2010-05-02
In an ActiveX project you typically start it at the sub Main (), but if you leave that empty - where in the code would the program start.
0
Comment
Question by:tyy8
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 2
  • +2
14 Comments
 
LVL 32

Expert Comment

by:Erick37
ID: 2698854
Private Sub Class_Initialize()
0
 
LVL 1

Expert Comment

by:sadcock
ID: 2698970
In whatever is specified in the program properties screen on the general tab.  Look for the startup object selection.


-Scott
0
 
LVL 14

Expert Comment

by:wsh2
ID: 2699004
As with any project.. it is always best to start from a Sub Main module and then Navigate from there.. <smile>.

Sub Main, is a great place to define any/all Global variables, functions, and/or subroutines that you have all in one place. It is a great place to put once and done application open and close processing routines, disencumbering you from coding the same in various other Forms.. which can be a pain to locate if you ever have to go back to your code.

All in all, it is a matter of style.. but I prefer to ALWAYS use a Sub Main.. <smile>.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 10

Accepted Solution

by:
caraf_g earned 50 total points
ID: 2699377
Remember though that this is an ActiveX .exe

You don't start an activeX .exe, a program that *uses* it does.

Having a Sub Main only makes sense if you are using a thread pool with a single thread. The reason is that Sub Main is only executed the very first time any objects from your activeX .exe are instantiated. Even if you set the threading model to Thread per Object.

If you're using a Sub Main to set your globals in the latter threading model, it will work fine the first time around, but not after.

In cases of ActiveX .exes I would actually advise very much against using a Sub Main.
0
 

Author Comment

by:tyy8
ID: 2700631
caraf -

But since it's an exe, it should have a new instantiation every time a user calls it (unlike a dll). So the sub main would get sparked for each user.
0
 

Author Comment

by:tyy8
ID: 2700635
Sadcock -

THe startup property is set to (none) in the dropdown box.
0
 

Author Comment

by:tyy8
ID: 2700639
Erick37 -

WHat if there is more then one class in the project, which class' initialize event would get fired?
0
 
LVL 10

Expert Comment

by:caraf_g
ID: 2700670
tyy8

NO. Try it and see.
0
 
LVL 32

Expert Comment

by:Erick37
ID: 2700727
Class_Initialize is fired for every class that you create an instance of.

Dim c as New Class1
'The Intitalize event for Class1 is
' fired prior to the .test call.
c.test
set c = Nothing
0
 
LVL 10

Expert Comment

by:caraf_g
ID: 2700768
Exactly. If you specify a sub main, this sub is executed the first time ANY object in your ActiveX .exe is instantiated.

As long as the ActiveX .exe remains loaded, this sub won't happen again, no matter *how* many subsequent objects from the ActiveX .exe you load.
0
 

Author Comment

by:tyy8
ID: 2701078
Oops, yeah - your right. I guess I was thinking of the class being set to singleuse - and that make a new exe everytime.

Okay, I think I'm cleared up on this point. Who wants the points?
0
 
LVL 14

Expert Comment

by:wsh2
ID: 2701101
caraf_g:
sub main.. <hat in hand>.. I stand corrected and defer to your wisdom.. <smile>
0
 
LVL 10

Expert Comment

by:caraf_g
ID: 2703147
tyy8, just give the points by accepting whosever comment you deemed most appropriate to your question.
0
 

Author Comment

by:tyy8
ID: 2708462
Caraf_g:

Your comments were the most enlightening, thanks to everybody, so I'll send the points over to you.

Thanks
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question