Excel adding quotation marks when saving text file

[theaudiobookguy]

Hi,

Excel is adding quotation marks to my my data when saving as a tab delimited text file.
I know (after some googling) that you can overcome this by using the 'PRINT' command instead of 'WRITE', but I'm not doing any VB coding so it doesn't seem to apply in my case and I wouldn't know how to do it if it did.

I'm simply manually selecting 'Save As' and creating the file that way.

Does anyone have any suggestions please? Thx

[EDIT]Solved Well....Kind of. What I've learned since making my post may help others, so I came back with a bit of an update.

For some reason, it took a while to occur to me that I could just copy and paste my desired selection into a blank text file instead; I think I assumed ti would lose the formatting, but of course it doesn't.

Anyway, I've done that now and it works fine. I can live with this for now, but since the whole point of my Excel tool is to help me automate my workflow, it kinda defeats the purpose.

So I'm still keen to learn how I can stop Excel adding the quotation marks when exporting.

During my search, I came across this: http://www.asap-utilities.com/index.php

It's an action-packed Excel utility suite that integrates seamlessly with Excel and has 300 macros and other functions. It's free for personal use and a reasonable price for commercial use. Definitely worth checking out.

I was eager to try this out to see if the files it exported contained the quotation marks and sadly, they do, so there's obviously still something I need to do with Excel to stand any chance of avoiding them.

Any leads?

p.s.
Hope I didn't break any forum rules with the link I posted. I'm sure it's probably a well-known product in this forum, which may or may not have some history here, good or bad. I wouldn't know, since I'm new to all this, but I felt it was worth mentioning.

[dominicb]

Good afternoon theaudiobookguy

Have a look at the answers I provided in this thread. The OP has the same type of problem as you have with the quotes, but there's no real way around this other than using macros.

HTH

DominicB

[theaudiobookguy]

Thanks Dominic. I really appreciate the reply.

I tried the code, but sadly it didn't work for me.

As you know, there were no line breaks in the first code. So of course, I tried the 2nd example you provided, but that only put line break characters [] in the output and not actual new lines.


Btw, I followed the link in your sig and installed your Ultimate Excel Add-in.
I knew it would be handy and sure enough, within five minutes of installing it I needed to convert a row into a column. I wondered if I'd be so lucky that your add-in would have this function and sure enough, it does!

You little ripper! thought I, as I went to try it out.

But sadly, after selecting a range and hitting OK I got the following error message:

Run-time error '1004':
Method 'Range' of object '_Global' failed

After that, the add-in wouldn't even open anymore without restarting Excel. I tried a few more times, but got the same error.

Also tired disabling other add-ins in case the problem was being caused by a conflict, but still no joy.
I'm running Office 2007 on Win XP, SP2. Any ideas?

:edit: I just learned about the Transpose function in the Special Paste menu which solved my initial problem of converting the row headings to a column list. Found it in this forum.
This place rocks! :thumbsup: