Vba output to a batch file

Hi,
I wrote a vba script that makes a batch file in column A in excel.
Can you please tell me how I can write out column A to a batch file.
I don't want to do a save as since I want to keep my excel program open for other processes.
Thanks you

Hi learner99,

The following macro will help you get started. It creates a .bat file using text from Column 'A' (starting at row 11) in the Active Sheet. You should be able to adapt it to your needs. Also see the attached sample file which implements the macro.

Please Login or Register  to view this content.

To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. Dim i as Integer). http://www.cpearson.com/excel/DeclaringVariables.aspx

Lewis