Create a TXT file from contents in a XLSM file

[VJ1985]

Hi Guys,

I'm new to Excel with regards to Macros/VBA and hence need help to create a TXT file from the contents in a XLSM file.

The user enters the information in an XLSM file as follows:

Company Name:	CarSalesPtyLtd		Code:	CSPL04
VEHICLE NUMBER	MAKE	MODEL	YEAR	COLOUR
ABC123	TOYOTA	HILUX	2000	WHITE
DEF456	FORD	FOCUS	1998	RED
GHI789	MERCEDES	SLK GTR	2011	GREY
JKL012	TOYOTA	CAMRY	2013	BLACK
PQR678	NISSAN	SKYLINE	1999	WHITE

<tbody>
</tbody>

Once done, the user clicks on a button which should create a TXT file as follows:
CarSalesPtyLtd

CSPL04​

YYYYMMDDHHMMSS Start
Vehicle, 1, ABC123, TOYOTA, HILUX, 2000, WHITE
Vehicle, 2, DEF456, FORD, FOCUS, 1998, RED
Vehicle, 3, GHI789, MERCEDES, SLK GTR, 2011, GREY
Vehicle, 4, JKL012, TOYOTA, CAMRY, 2013, BLACK
Vehicle, 5, PQR678, NISSAN, SKYLINE, 1999, WHITE

CarSales​

PtyLtd

CSPL04​

YYYYMMDDHHMMSS End



Also, once the user clicks the button, is it possible to save the TXT file with a filename from the cell contents, but prompt the user for the save location?

For instance, save the above TXT file as "

CarSalesPtyLtd-CSPL04.TXT"
Many thanks in advance!
Cheers,
VJ​

 

[VJ1985]

Not sure why the above text is aligned like that... looked fine in the editor!

Anyway, this how the TXT file should appear:

CarSalesPtyLtd, CSPL04, YYYYMMDDHHMMSS, Start
Vehicle, 1, ABC123, TOYOTA, HILUX, 2000, WHITE
Vehicle, 2, DEF456, FORD, FOCUS, 1998, RED
Vehicle, 3, GHI789, MERCEDES, SLK GTR, 2011, GREY
Vehicle, 4, JKL012, TOYOTA, CAMRY, 2013, BLACK
Vehicle, 5, PQR678, NISSAN, SKYLINE, 1999, WHITE
CarSalesPtyLtd, CSPL04, YYYYMMDDHHMMSS, End

Thanks again!
VJ