Macro to save text string as an MS-DOS format text document

**bwink88** · 12-13-2013, 02:06 PM

I have a template in excel that is set up to take data entered into a table, and convert it into a text sting to import into another program I use for work. Currently, to import the data into the program, we copy the text string without formatting into wordpad, and save it as a Text Document MS-DOS format .dat file.

To import the data into the program, I must copy the link to the program into Run followed by the link to the .dat file.

Is there a way to automate this function with a macro in wordpad?

If it isn't possible to do this through wordpad, is it possible to save to a text document MS-DOS format .dat file through a different method?

**xlbiznes** · 12-13-2013, 02:30 PM

Hi,

Can you post a sample file and the output (dat file) to suggest a solution apt for your requirement.

**LJMetzger** · 12-13-2013, 02:43 PM

You can probably do what you want in Excel. See the following code that writes directly to a text file from Excel. You may be able to replace the text I have with the contents of cells in the workbook.

Please Login or Register  to view this content.

Lewis

**bwink88** · 12-13-2013, 02:49 PM

The site won't let me upload a .dat file, so I converted it to .txt for the purpose of this example.

The link I would copy into Run to use to upload looks like:

S:\wfx32\TDIN Admin S:\SHARED\TD IN\examp_0120131213.dat
^Link for import program ^Link to test string .dat file

**xlbiznes** · 12-13-2013, 03:34 PM

Hi,

here you go.

**bwink88** · 12-16-2013, 12:57 PM

Thank you very much for the posts, they were very helpful. I have just started fumbling around with macros, and am trying to learn more about them, but I only get to work on them every now and then in down time. I have been using posts on the internet to help find my way around them. I'm considering buying a couple books off amazon on macros. Do either of you have a recomendation for a beginner?