I know this is an old post but I have something that might help,
If you have a batch file already created and ask Excel to open the batch file then you can get Excel to paste/export the information into the file at your own commands through the macro.

However I have fallen short of finishing my own goals that I had in mind by using excel to string LDAP scripts together, piecing certain strings and input variables to create the complete string. This is repeated through the document creation 60 scripts that I have successfully exported to a batch file, however I am struggling with the Forced format that excel then places around a Excel edited batch file. Excel puts " " marks around the scripts that I have created rendering them useless.

If someone can advise how to stop Excel from Force Formatting my scripts in the batch file, I would be happy to share my code to actually setup the macro for the batch file.


[quote=CB;24732]I tried this, but once you leave excel it doesn't record the macro anymore.
Also there is not, afaik, an option to save to bat in excel..