Columns from Excel to Text file

**vijay2482** · 09-14-2009, 04:19 AM

Hi all,
I need help in writing a macro, that retrives 2 column values from an excel sheet and write it as a text file.

Any help will be helpful.
Thanks in advance

**JBeaucaire** · 09-14-2009, 10:29 AM

1) Copy the two column onto a new blank sheet

Please Login or Register  to view this content.

2) Save the sheet as text - Saving as text will only save the active sheet

Please Login or Register  to view this content.

A macro would need to know:
a) What columns?
b) What path to save files to?
c) What naming system to use on the saved file?

**vijay2482** · 09-16-2009, 10:02 AM

Thanks for the reply and code.
I'm working on it.
If found difficulty to sort the problem, will be back.

**JBeaucaire** · 09-16-2009, 11:45 AM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)