Export to mulitple TXT files

[92merc]

Looking for some help. I'm a novice Excel user. So VBA is out of my realm. I have an Excel 2013 file with weather data. Basically columns A through M with data. I have one row for each day of the year, plus an extra row for leap year.

Column A is the 2 digit number for month
Column B is the 2 digit day number
Column G is a rain data.

I'd like to make a macro that will go through each row and create a TXT file for each day of the year. So each row creates one text file.
The file name would be a concatenation of ColumnsA+B followed by .txt.
So the row with June 27th data would take Column A of 05, plus column B of 27, and create a file 0527.txt

The data within the TXT file would be filled with the same row, column G data. Hopefully I made sense. So hopefully the macro would then create 366 files in a specified folder.

I have a few more macro's to build once I get this one working. But they are all variations of the above. So I can probably figure it out from there.

Thanks in advance.

[mrice]

Try this.

Please Login or Register  to view this content.

[92merc]

That pretty much did it. But something odd starts happening starting with my 0705.txt file. It starts showing values out past 2 decimal places. I double checked the data I entered. None of the data has more than 2 decimals. I even formatted that column to be a number and 2 decimal places. But the files still have some extra digits. Not all. Just some

The only other thing I'll need to do is have another macro that picks column H, and the file name will be 0527rh.txt instead. What would that one look like?

Thanks again.

[92merc]

Probably just as easy to attach my Excel file. Basically need 6 sets of files, made by 6 macros. Data from columns C, G, H, I, J, and K. Just with slightly different file names.

Hopefully I attached this right.

Thanks

[jindon]

Try

Please Login or Register  to view this content.

[92merc]

That worked perfectly. Thanks Jindon.

[jindon]

You are welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[92merc]

Sorry to dig up an old thread, but I went to update the data in my Excel file. Did a save as Excel-macro enabled file as it wasn't before. But now I'm getting a "Run-time error '52': Bad file name or number error.

When I go to debug, "Open myDir & .Cells(i, "a").Text & .Cells(i, "b").Text & ".txt" For Output As #ff" is highlighted.

Any help is appreciated.

[92merc]

I should add, I'm using Office 365 on my PC now.

[jindon]

When you change the path...

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[92merc]

Thank you for that. Now I need to go through my data and see what needs updating.