Create a Txt File, Rename and Save It

Hi There,

I need your help.

I would like to create a macro, such that at a click of a button would accomplish the following:

1. Create a new txt file where the number "123456" is provide by a text box on a user form followed by a "1" on the next line.

eg. of what is in [test.txt]

123456
1

2. Rename the file to "123456.ccm" and save the ouput to file to C:\Temp

Your help and support with this is grealy appreciated.

A Huge thanks in advance.

Like so:

Please Login or Register  to view this content.

Does that work for you?