Asked by duncanb7
at 2024-11-09 00:25:39
Point:500 Replies:8 POST_ID:828409USER_ID:11059
Topic:
Visual Basic Programming;;
When we open excel file at command line and running its macro , we will put the
code in Thisworkbook sheet of the excel file to run the macro autmatically
once the file is opend. I would like to know how to put variabe to the marco at
the command line. Please advise, I try this command but it fail
C:> myexcel.xls 1
Duncan
----'Mymacro in the Thisworksheet
Sub workbook_open( i as integer )
if i= 0 then
call previousmarco
Else
call udpatemacro
End Sub
code in Thisworkbook sheet of the excel file to run the macro autmatically
once the file is opend. I would like to know how to put variabe to the marco at
the command line. Please advise, I try this command but it fail
C:> myexcel.xls 1
Duncan
----'Mymacro in the Thisworksheet
Sub workbook_open( i as integer )
if i= 0 then
call previousmarco
Else
call udpatemacro
End Sub