Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Main first
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" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Main first
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" wrote in message ... 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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Main first
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" wrote in message ... 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" wrote in message ... 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! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Main first
Which is probably where her code is Nick.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "NickHK" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Main first
You could rename it Auto_Open.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jenni_Sweden" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Main history of car insurance | Excel Discussion (Misc queries) | |||
Main history of car insurance | Excel Discussion (Misc queries) | |||
Main and subject spreadsheets | Setting up and Configuration of Excel | |||
Call from a Main program | Excel Programming | |||
New Main menu item | Excel Programming |