Main first

[Guest]

How do I get my program to start at the subroutine main? (I have Visual Basic
6.3). My code is:
Public Sub Main()
Public lengthDate As Integer
Worksheets("Indata").Range("f9") = "main"
dagensDatumKnapp.Show
skapa
End Sub
End Sub

In main I want to create certain things e.g. display text in a cell. However
main is nerevr executed? Help!

 

[NickHK]

Jenni,
"Sub Main" has no special meaning in VBA as it does in VB standalone.
But in the Workbook_Open event you can call it, or any other sub/function
you wish.
e.g. Call Main()

NickHK

 

[Guest]

thankx. but how do you specify where the program begins? as it is now i am
not sure where in the code the program starts running!

 

[Bob Phillips]

You could rename it Auto_Open.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[NickHK]

Jenni,
As Bob pointed you can rename "Auto-Open" to achieve the same, although
Workbook_Open fires first.
And a "Auto-Open" routine needs to be in a module, not in a worksheet or
ThisWorkbook.

NickHK

 

[Bob Phillips]

Which is probably where her code is Nick.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)