jayant_1970
New Member
- Joined
- Dec 21, 2015
- Messages
- 2
Hello !!
I am completely new to VBA. Can someone from community help me achieve following.
I have an excel 2003 worksheet with three columns data as follows:
<tbody>
</tbody>
1st Row is with heading text (SYMBOL , LISTING_DATE , FV) in column A, B & C.
Column A contains list of SYMBOLS from A2:A1700.
Column B contains list of LISTING_DATE from B2:B1700
Column C contains list of FV from C2:C1700
- I want to create individual .txt files with A2 to A1700 as file name. (example: 20MICRONS.txt)
- Each text file to contains corresponding data from Column B and Column C with comma and space in between them.
example: 20MICRONS.txt file contains data "LISTING_DATE = 06-Oct-08 , FV = 5" in single line.
Any VBA expert help me please.
Thanks in advance.
I am completely new to VBA. Can someone from community help me achieve following.
I have an excel 2003 worksheet with three columns data as follows:
SYMBOL | LISTING_DATE | FV |
20MICRONS | 06-Oct-08 | 5 |
3IINFOTECH | 22-Apr-05 | 10 |
3MINDIA | 13-Aug-04 | 1 |
8KMILES | 29-Jan-14 | 10 |
A2ZINFRA | 23-Dec-10 | 2 |
<tbody>
</tbody>
1st Row is with heading text (SYMBOL , LISTING_DATE , FV) in column A, B & C.
Column A contains list of SYMBOLS from A2:A1700.
Column B contains list of LISTING_DATE from B2:B1700
Column C contains list of FV from C2:C1700
- I want to create individual .txt files with A2 to A1700 as file name. (example: 20MICRONS.txt)
- Each text file to contains corresponding data from Column B and Column C with comma and space in between them.
example: 20MICRONS.txt file contains data "LISTING_DATE = 06-Oct-08 , FV = 5" in single line.
Any VBA expert help me please.
Thanks in advance.