A macro to produce a .dat file from a column on a spreadsheet?

Okay so I'm curious if it's possible to create a dat file from a column on a spreadsheet?

I've attached a spreadsheet with two tabs. I intend to copy and paste information on the Drop_Data tab. That will populate columns C and E (and then consequently column F) on the Use tab. The rest of the columns on the Use tab will be filled out through copy and paste.

Anyway, on the Use tab, I want to know if the I can take the data in column F and convert it (through a macro) to a .dat file to my desktop.

Is this possible?

Of course, but for what? There isn't a standard format for dat files, so if you're wanting to use it in another application, you'll need to know the structure

Originally Posted by Kyle123

Of course, but for what? There isn't a standard format for dat files, so if you're wanting to use it in another application, you'll need to know the structure

Ultimately it's going to be compressed and then uploaded into a system. I'm not terribly familiar with .dat files so I can't speak to the structure.

The process I'm doing now is to open a notepad, input the data:
Stuff|Things|2023/03/19|N|ABC-123
Stuff|Things|2023/03/19|N|ABC-234
Stuff|Things|2023/03/19|N|DEF-482
Stuff|Things|2023/03/19|N|DEF-500
Stuff|Things|2023/03/19|N|FEG-756

and save it as a .dat file (then compressing it).

This does basically what you're doing, it'll save the file to your desktop

Please Login or Register  to view this content.

That works! Thanks!