How to save as .dat file?

[Hjahren]

Hello!

I am trying to save a excelsheet as a .dat file, but when I do this the macro adds "" in front and at the end of each line. Anyone who knows why?

Please Login or Register  to view this content.

[MarvinP]

Try some of the other FileFormats on the list from the link below.
I'd try FileFormat:= xlTextMSDOS
http://msdn.microsoft.com/en-us/libr...ileformat.aspx

[Hjahren]

didn't help. the problem is that whatever fileformat I am saving it into it adds "", but if I copy into notepad and save as dat it doesn't.

[romperstomper]

What format is your .dat file supposed to be?

[Hjahren]

It is supposed to be as they are in the excelsheet, without anything added to it..? Not delimited or anything. Just the spreadsheet.

[romperstomper]

It must be delimited, otherwise your data file is either just an .xls with a different name, or it's gibberish (unless all rows in each column have the same number of characters).

[Hjahren]

I want it to be as if I copy the spreadsheet and paste into a notepad text, was that anymore clearifying?

[romperstomper]

So tab delimited then.
Using your code works fine for me - no "" added anywhere.