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:===
How to run excel macro at command line

this several ways but it fail and only Excel window is activated and report no such file
of myfile.xls!main, please advise since I would like put the command
in Window's Schtask for automation excel macro running.
1----C:>excel.exe D:datamyfile.xls!main
2----C:>excel.exe D:data'myfile.xls'!main
3-----C:>excel.exe D:data"'myfile.xls'!main"
4-C:>excel.exe "D:data'myfile.xls'!main"
All 4 tries are failed, I tried it in VBA that is okay
chdir D:data
application.run "'myfile'!main"
Duncan
Dear Tommy,
You mean i put the code in one file, for example, myfile.vps and put it in schtask
like C:excel myfile.vps, it will run auto
Dear Tommy,
You mean i put the code in one file, for example, myfile.vps and put it in schtask
like C:excel myfile.vps, it will run auto
Dear Tommy,
You mean i put the code in one file, for example, myfile.vps and put it in schtask
like C:excel myfile.vps, it will run auto
Dear Tommy,
You mean i put the code in one file, for example, myfile.vps and put it in schtask
like C:excel myfile.vps, it will run auto
Dear Tommy,
You mean i put the code in one file, for example, myfile.vps and put it in schtask
like C:excel myfile.vps, it will run auto
Dear Tommy,
You mean i put the code in one file, for example, myfile.vps and put it in schtask
like C:excel myfile.vps, it will run auto
Dear Tommy,
You mean i put the code in one file, for example, myfile.vps and put it in schtask
like C:excel myfile.vps, it will run auto
Dear Tommy,
You mean i put the code in one file, for example, myfile.vps and put it in schtask
like C:excel myfile.vps, it will run auto
Dear Tommy,
You mean i put the code in one file, for example, myfile.vps and put it in schtask
like C:excel myfile.vps, it will run auto
Dear Tommy,
You mean i put the code in one file, for example, myfile.vps and put it in schtask
like C:excel myfile.vps, it will run auto
Dear Tommy,
You mean i put the code in one file, for example, myfile.vps and put it in schtask
like C:excel myfile.vps, it will run auto
Dear Tommy,
You mean i put the code in one file, for example, myfile.vps and put it in schtask
like C:excel myfile.vps, it will run auto