Main first

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!

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

"Jenni_Sweden" <[email protected]> wrote in message
news:[email protected]...
> 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!

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!
--
I am very thankful for any fast assistance!


"NickHK" skrev:

> 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
>
> "Jenni_Sweden" <[email protected]> wrote in message
> news:[email protected]...
> > 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!
>
>
>

You could rename it Auto_Open.

--
HTH

Bob Phillips

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

"Jenni_Sweden" <[email protected]> wrote in message
news:[email protected]...
> 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!

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

"Jenni_Sweden" <[email protected]> wrote in message
news:[email protected]...
> 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!
> --
> I am very thankful for any fast assistance!
>
>
> "NickHK" skrev:
>
> > 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
> >
> > "Jenni_Sweden" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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!
> >
> >
> >

Which is probably where her code is Nick.

--
HTH

Bob Phillips

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

"NickHK" <[email protected]> wrote in message
news:[email protected]...
> 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
>
> "Jenni_Sweden" <[email protected]> wrote in message
> news:[email protected]...
> > 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!
> > --
> > I am very thankful for any fast assistance!
> >
> >
> > "NickHK" skrev:
> >
> > > 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
> > >
> > > "Jenni_Sweden" <[email protected]> wrote in
message
> > > news:[email protected]...
> > > > 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!
> > >
> > >
> > >
>
>