T
TGV
In my workbook there are several work sheets are available and I want to save
the each worksheets B COLUMN CELL CONTENTS in a SEPARATE NOTEPAD FILES with
the SHEET NAMES AS FILE NAME.
For example in sheet1 the B COLUM cell contents should be exported as a
notepad file with the sheet name as file name in my desktop and like that it
should export the remaining sheets B column contents in a separate separate
notepad files and it should automatically save the files in my desk top when
I run a macro.
At the same time the note pad file should be generated by way of selecting
the start to end of the cell contents in b column and there will not be any
blank cell in between the B column range. So the macro should export only
the cells which are having the content continuously in B column.
If, anyone knows it, then please provide the VB code for the same and thanks
in advance.
TGV
the each worksheets B COLUMN CELL CONTENTS in a SEPARATE NOTEPAD FILES with
the SHEET NAMES AS FILE NAME.
For example in sheet1 the B COLUM cell contents should be exported as a
notepad file with the sheet name as file name in my desktop and like that it
should export the remaining sheets B column contents in a separate separate
notepad files and it should automatically save the files in my desk top when
I run a macro.
At the same time the note pad file should be generated by way of selecting
the start to end of the cell contents in b column and there will not be any
blank cell in between the B column range. So the macro should export only
the cells which are having the content continuously in B column.
If, anyone knows it, then please provide the VB code for the same and thanks
in advance.
TGV