Running VBA macro in Excel from Command Line

[jinho89]

Can a VBA macro in Excel 2K be run from a command line? I assume that the Excel workbook and VBA IDE is already open and running. I just need to run a specific Sub function in a module of the workbook project in a DOS command line. I'm a novice of VBA. Sorry if this question doesn't make sense at all. Any idea would be appreciated.

 

[johnwm]

DOS command line interfaces with the OS via streams called STDIN and STDOUT. These are not easily accessible to Windows environment. If you're prepared for some serious work there are a few clues on how to start in our sister site for computer professionals. You could start with

http://www.tek-tips.com/viewthread.cfm?qid=255803

and then do search on that forum for STDIN and STDOUT

Warning - you're in for some heavy stuff!

Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting
Steam Engine enthusiasts
Steam Engine Prints

 

[handleman]

Does it have to work with Excel, or could the macro be rewritten in VBScript?