ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Complete list of Excel Command line switches/parameters (https://www.excelbanter.com/excel-programming/366751-complete-list-excel-command-line-switches-parameters.html)

NHRunner[_2_]

Complete list of Excel Command line switches/parameters
 
I would have thought a simple Google search would have located a Complete
list of Excel Command line switches/parameters.

All I can seem to find is a short Microsoft list that contain only minimal
stuff for opening excel itself.

What I need is a list of how to call excel and open a particular file and
pass macro names and parameters with data content.

I had such a thing but lost it.



NickHK

Complete list of Excel Command line switches/parameters
 
AFAIK, Excel does not support specifying a macro to run, unlike Word
apparently.
This works in a short cut, so imagine it's similar in Shell
"C:\Program Files\Microsoft Office\Office\EXCEL.EXE"
"C:\PathToFile\Book1.xls"
Any WB_Open code will run upon opening.

You other alternative is use Automation, then you can do pretty much
anything. Command lines are not relevant in this situation.

NickHK

"NHRunner" wrote in message
...
I would have thought a simple Google search would have located a Complete
list of Excel Command line switches/parameters.

All I can seem to find is a short Microsoft list that contain only minimal
stuff for opening excel itself.

What I need is a list of how to call excel and open a particular file and
pass macro names and parameters with data content.

I had such a thing but lost it.






All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com