View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill Grigg Bill Grigg is offline
external usenet poster
 
Posts: 7
Default 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