Automating Save As Tab Deliminated Text

**pradhan** · 10-04-2014, 08:57 AM

Greetings and thanks for your help again!

Upon loading Excel 2013, one of the first thing I checked for is whether MS made it easier to Save As in a format other than xlsx. More to the point, I have to save worksheets as a Tab Delimited Text file literally hundreds of times. And EACH time, I am warned that the format does not support EXCEL functions (I KNOW!), and each time I am asked if I want to save the entire workbook in that format (ALWAYS NO), and when I say no, EACH time I am then asked (in essence), "Well, how do you want to save it then?". I wish MS would trust its users with a little right-mouse click "Save As" and just let me choose a format and save. Ah well, that being said...

Can anyone help me with a macro, code or something that will automate this simple function, or allow me to create my own menu function which will one-step this process. Basically, I need to simply save the current worksheet as a tab-delimited file, give it a unique name and okay without all the warnings and double-checking if I am sure I really want to do this.

This simple function would save me lots of time, and I would be so grateful for any help.

Pradhan

**mrice** · 10-04-2014, 09:50 AM

Try this

Please Login or Register  to view this content.

**pradhan** · 10-04-2014, 11:41 AM

Yes, this works! Thank you so much! But 1 minor problem and a question, if I may. After running the macro, I get a warning "The workbook contains links to one or more external sources that could be unsafe. If you trust the links...Update" etc. All the files are in trusted directories. Any idea why I would get this warning, and how to get rid of it?

Thanks so much again for your help! This has already saved me so much time!

Pradhan