Hi All,
I am looking for a macro which will save out the DATA RANGE as a '.txt' file and for the filepath to be a msgbox pop-up for the user to browse and pick the correct folder to choose where the new '.txt' file should be saved. The new '.txt' filename can be "test".
DATA RANGE: starts in cell H7 and should pick up the last cell with data in column H (the dataset length will constantly be changing).
In addition, I would like the macro to take the data from each cell and record it on a separate line in the new 'test.txt' file.
Example:
cell D7= Graphic tee
cell D8= Trousers
Test.txt output:
Graphic tee
Trousers
This will be of tremendous help to me, so thank you in advance!!! And please don't hesitate to ask any questions.
I am looking for a macro which will save out the DATA RANGE as a '.txt' file and for the filepath to be a msgbox pop-up for the user to browse and pick the correct folder to choose where the new '.txt' file should be saved. The new '.txt' filename can be "test".
DATA RANGE: starts in cell H7 and should pick up the last cell with data in column H (the dataset length will constantly be changing).
In addition, I would like the macro to take the data from each cell and record it on a separate line in the new 'test.txt' file.
Example:
cell D7= Graphic tee
cell D8= Trousers
Test.txt output:
Graphic tee
Trousers
This will be of tremendous help to me, so thank you in advance!!! And please don't hesitate to ask any questions.
