123raajesh
New Member
- Joined
- Apr 28, 2014
- Messages
- 4
Hi,
I am new vba and like to know if there is a way using excel macros or VB in Windows to:
1) create .txt file name using value or content of a cell say A1. It could be alphanumeric.
2) Then get excel data from range column B, where the rows count varies. Should get only data not empty rows of column B.
3) Save the text file on desktop, show message of exact location of file saved.
4) Now as its saved, if macro is run again with same text file name, should replace the previous file if its name is same.
5) The macro is run from another sheet in same workbook, not from the sheet which contains data. Say Macro is from sheet1 and data is in sheet2, the data contains quotes singe or double and pipe, which should not be affected on export.
6) And the clipboard should be cleared after export, as in this code.
We are using office 2010. Pleas suggest simple and easiest way.
Please suggest.
I am new vba and like to know if there is a way using excel macros or VB in Windows to:
1) create .txt file name using value or content of a cell say A1. It could be alphanumeric.
2) Then get excel data from range column B, where the rows count varies. Should get only data not empty rows of column B.
3) Save the text file on desktop, show message of exact location of file saved.
4) Now as its saved, if macro is run again with same text file name, should replace the previous file if its name is same.
5) The macro is run from another sheet in same workbook, not from the sheet which contains data. Say Macro is from sheet1 and data is in sheet2, the data contains quotes singe or double and pipe, which should not be affected on export.
6) And the clipboard should be cleared after export, as in this code.
We are using office 2010. Pleas suggest simple and easiest way.
Please suggest.
