Code to export data to a .dat file

**aadarsh** · 10-14-2010, 01:53 PM

Hello All,

I need to export data from excel to a .dat file. This DAT file is an input to another application and the exported data (the numbers) has to be in specific locations so the syntax is not disturbed . Please see attached .txt file for clarity.

Is it possible that only the numbers are exported from excel into this file at appropriate places, if not how do I write a code in excel to export the entire data including the syntax to .txt or .dat file.

Appreciate your help.

**Leith Ross** · 10-14-2010, 03:42 PM

Hello aadarsh,

Welcome to the Forum!

Did the Excel workbook not post? You should try posting it again.

**aadarsh** · 10-15-2010, 04:32 AM

Hi,

Please see the excel attached. The data in the blue cells needs to be exported. This is only sample data, the code needs to be scalable so that I can increase it for 22 carriers in each lane for 15 lanes.

For scalability, there would only be new additions in Lanes. The ranges are fixed.

**aadarsh** · 10-18-2010, 04:13 AM

Hi All,

I have found some code on internet and tried to modify it to solve my case but I have few problems.

1. Within the code it accepts only two arrays. (See the comment in VBA editor)

2. How do I introduce a space between the cells being exported to the txt document

3. In the code though I specify cells F16:I19, it exports from F15:I19 instead

Can some one help with these problems please.

Regards,
Adarsh

P.S My VBA skills are very basic