Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
form not opening when started from command line
All,
After searching around I guess that I now can start my Excel app from a batch file. However, I also need to open a form automatically also. Here is the code: Private Sub Workbook_Open() Dim cmdLine As String Dim lst() As String Dim ky As String Set App = Application CreateMenus ' Check to see if this is a "scheduled task" ' cmdLine = GetCommLine (code is elsewhere but it does work) If Len(cmdLine) = 0 Then Exit Sub If Not InStr(cmdLine, "/") Then Exit Sub ' Get rid of alerts ' App.DisplayAlerts = False ' Check out the passed arguments ' lst = Split(cmdLine, "/") ' Assume we always want the AutoRelease form for now ' frmRelease.Show (nothing happens) The form "frmRelease" does not open. Any suggestions? TIA, Bill |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
form not opening when started from command line
oops there was a bug in the code - If Not InStr(cmdLine, "/") Then Exit Sub
does not work. I am forever forgetting that "..Not InStr(..." does not do what it reads as. The form opens just fine. Sorry about that, Bill "Bill Grigg" wrote: All, After searching around I guess that I now can start my Excel app from a batch file. However, I also need to open a form automatically also. Here is the code: Private Sub Workbook_Open() Dim cmdLine As String Dim lst() As String Dim ky As String Set App = Application CreateMenus ' Check to see if this is a "scheduled task" ' cmdLine = GetCommLine (code is elsewhere but it does work) If Len(cmdLine) = 0 Then Exit Sub If Not InStr(cmdLine, "/") Then Exit Sub ' Get rid of alerts ' App.DisplayAlerts = False ' Check out the passed arguments ' lst = Split(cmdLine, "/") ' Assume we always want the AutoRelease form for now ' frmRelease.Show (nothing happens) The form "frmRelease" does not open. Any suggestions? TIA, Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to launch Macro/Code form command line | Excel Programming | |||
Date field in user form & Loading a user form on opening workbook | Excel Programming | |||
opening a worksheet with a command button on a form | Excel Discussion (Misc queries) | |||
Print an excel file from command line or "cron" type command ??? | Excel Programming | |||
Getting started with a User Form | Excel Programming |