|
Nick
Yes, process_create() is similar to Shell.
If I can pass the filename to SaveAs as a parameter in the command line, then perhaps a macro would not be needed: how could I do this? Is there a definitive list of command line options somewhere?
Thanks
Alan
[quote=NickHK]Alan,
What is "process_create" ? Similar to Shell ?
You could specify a workbook that has a suitable routine in its
Workbook_Open event instaed of the "file.txt".
And there are ways to read the command line to Excel so you can pass more
parameters, e.g. the text file to open, the .SaveAs file name etc.
Declare Function GetCommandLine Lib "kernel32" Alias "GetCommandLineA" () As
String
But still need a macro in the WB open to do the saving.
Or use a VBScript + Automation
NickHK
|