Ask Question Forum:
C
O
M
P
U
T
E
R
2
8
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Y-position of the mouse cursor
Attachment:===
Pass variabel to Excel open in VBA

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
BTW
I would suggest a B grade is unfair, the original question was about command line parameter passing, and was answered in full by the link, (and since the link is definitive there is nothing inappropriate in that).
Had I failed to respond to specific question thereof then perhaps. Note the question re read only was additional but even then you should allow time to respond.
No point in chasing the admins to change the award though (even if you agree) i'm simply advising you on the normal etiquette.
Chris
BTW
I would suggest a B grade is unfair, the original question was about command line parameter passing, and was answered in full by the link, (and since the link is definitive there is nothing inappropriate in that).
Had I failed to respond to specific question thereof then perhaps. Note the question re read only was additional but even then you should allow time to respond.
No point in chasing the admins to change the award though (even if you agree) i'm simply advising you on the normal etiquette.
Chris
BTW
I would suggest a B grade is unfair, the original question was about command line parameter passing, and was answered in full by the link, (and since the link is definitive there is nothing inappropriate in that).
Had I failed to respond to specific question thereof then perhaps. Note the question re read only was additional but even then you should allow time to respond.
No point in chasing the admins to change the award though (even if you agree) i'm simply advising you on the normal etiquette.
Chris
BTW
I would suggest a B grade is unfair, the original question was about command line parameter passing, and was answered in full by the link, (and since the link is definitive there is nothing inappropriate in that).
Had I failed to respond to specific question thereof then perhaps. Note the question re read only was additional but even then you should allow time to respond.
No point in chasing the admins to change the award though (even if you agree) i'm simply advising you on the normal etiquette.
Chris
BTW
I would suggest a B grade is unfair, the original question was about command line parameter passing, and was answered in full by the link, (and since the link is definitive there is nothing inappropriate in that).
Had I failed to respond to specific question thereof then perhaps. Note the question re read only was additional but even then you should allow time to respond.
No point in chasing the admins to change the award though (even if you agree) i'm simply advising you on the normal etiquette.
Chris
BTW
I would suggest a B grade is unfair, the original question was about command line parameter passing, and was answered in full by the link, (and since the link is definitive there is nothing inappropriate in that).
Had I failed to respond to specific question thereof then perhaps. Note the question re read only was additional but even then you should allow time to respond.
No point in chasing the admins to change the award though (even if you agree) i'm simply advising you on the normal etiquette.
Chris
BTW
I would suggest a B grade is unfair, the original question was about command line parameter passing, and was answered in full by the link, (and since the link is definitive there is nothing inappropriate in that).
Had I failed to respond to specific question thereof then perhaps. Note the question re read only was additional but even then you should allow time to respond.
No point in chasing the admins to change the award though (even if you agree) i'm simply advising you on the normal etiquette.
Chris