Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Stop Excel 2010 from appending .txt to file with existing extension

31 Mar 2013   #11
UsernameIssues

W7 Pro SP1 64bit
 
 

Quote   Quote: Originally Posted by carwiz View Post
All the OP has to do is select Save As then change the file type to cvs. The drop-down on the right will list the file types allowed.
Maybe I have failed to grasp the OP's problem, but the types of files allowed is not the issue.

The issue is how a tab delimited file is named once saved and the W7 annoyance of not leaving the file name in the save as dialog box as detailed in post #7. This was not a problem in XP. I had to re-write several scripts just to handle this inexplicable OS change. This "tiny" change cost the company that I work for many man-hours of labor. And it is not just a problem in Office; it happens in other apps that call the OS's file handling APIs.

With XP, you could start with a file names TAB.UPL and end with a file named TAB.UPL.

With W7, that same file becomes TAB.UPL.CSV unless you jump thru some annoying extra hoops.


My System SpecsSystem Spec
.
31 Mar 2013   #12
carwiz

Windows 7 Pro-x64
 
 

I missed the "tab" delimited part any way. A work around would be to rename the file(s) afterward. Standardization does have it's hard knocks.
My System SpecsSystem Spec
01 Apr 2013   #13
UsernameIssues

W7 Pro SP1 64bit
 
 

Funny that you should mention standardization in a thread talking about CSV files:

http://en.wikipedia.org/wiki/Comma-s..._of_a_standard

:-)
My System SpecsSystem Spec
.

01 Apr 2013   #14
carwiz

Windows 7 Pro-x64
 
 

Wow! That brought back some terrible memories. I recall writing in Fortran and using CSV in punched card format.

While not official, it did have somewhat of a standard. It allowed the programmer to parse a string for the data in a free-form record. It worked well at the time and still does. What I never heard of, until looking it up, is UPL files. Software companies come up with file types all the time to help keep their programs proprietary. I still don't see any reason to expect Microsoft to follow every software manufacturer's whim. I don't see anyone ripping Adobe because Reader doesn't recognize MS Word files. Get over it and move on.
My System SpecsSystem Spec
01 Apr 2013   #15
stones710

windows 7 64 bit
 
 

Hello and thanks to everyone who has posted a response to this problem. I have been away for a while so I want to apologize for my late respose to you. UsernameIssues has hit the nail on the head with posts #7 and #11; I couldn't have said it more clearly, thanks for you help. I thought there might be a way to fix this in the registry, but haven't been able to figure it out yet. I have the same problem where I have to constantly manually edit the tab delimited text files to remove the automated appending ot the .txt extension. Since MS has a way to force this to be appended to the file name, there must be a way to "undo" what they did to keep it from happening. I will continue to look....
My System SpecsSystem Spec
01 Apr 2013   #16
UsernameIssues

W7 Pro SP1 64bit
 
 

Post #5 is how I solve this annoyance each work day. Let me know if you opt to try it.
My System SpecsSystem Spec
01 Apr 2013   #17
UsernameIssues

W7 Pro SP1 64bit
 
 

Quote   Quote: Originally Posted by carwiz View Post
Wow! That brought back some terrible memories. I recall writing in Fortran and using CSV in punched card format.

While not official, it did have somewhat of a standard. It allowed the programmer to parse a string for the data in a free-form record. It worked well at the time and still does. What I never heard of, until looking it up, is UPL files. Software companies come up with file types all the time to help keep their programs proprietary. I still don't see any reason to expect Microsoft to follow every software manufacturer's whim. I don't see anyone ripping Adobe because Reader doesn't recognize MS Word files. Get over it and move on.
FORTRAN and punch cards - we hail from the same era.

The file in the OP is not really in a non standard format, it just uses a nonstandard file extension. I'm not so concerned about the CSV file format variations as much as I am the seemingly arbitrary decision to change the way the "File > Save As" dialog box works in W7 (this impacts most apps, not just Office ones):

Why remove the file name? Thus forcing the user to type it in again. In my case, my scripts had been using the existing file name (which was there in XP) and only changing a few characters to represent the changes to the file.

And why append an unwanted file extension? Forcing user to use quotes to get their way or to rename the file via a file explorer/manager/app.

I'm certainly not expecting MS to change W7 to suit me... but if someone had a good explanation as to why these changes took place in the OS, then maybe they would not bug me so :-)
My System SpecsSystem Spec
Reply

 Stop Excel 2010 from appending .txt to file with existing extension




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Excel 2013 cannot open simple text file with .acc extension
Inside .acc file is a simple text, but the mighty Excel tries to open it like some kind of database. It is asking for accounts, sources, passwords etc. and finally it cannot open it at all. It can open this file if I change extension to something else like .txt or .xls. How can I turn off this...
Microsoft Office
Excel 2010 "File In Use" notification doesn't show
Hello! We have shared folder on server that specific users can open it. In that folder there are bunch of excel files that they need to fill in. Problem starts when one user opens the document and starts filling the excel file, in that moment other user opens the same excel file but doesn't get...
Microsoft Office
Can I create a pie chart with data in an existing excel file?
Where I work an excel sheet with any and all "failed activities" (we're not getting paid) is sent out every wednesday. How can I highlight specific cells (for a specific person) and have that chart show how much of the failed activities belong to them. They obviously know that, but this will...
Microsoft Office
Excel 2010 crashes (BSOD) when opening a file
Hi Folks, I just changed out my President's XP-Pro to Win7 Pro 64 bit. We store all of our Word & Excel docs on a 6.5 Netware server. Yes it's old and out of date - but it cost money to change it. so..... I had no problems ever with XP but with Win7 when you open a Excel file it ...
BSOD Help and Support
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
How to stop appending 'shortcut'
Windows 7 Professional 64bit -Purchased :D I tried a registry hack, no change. This 'feature' has been irritating me for YEARS in the different OS's, and I don't understand the insistence to not provide and option to stop it? Don't get me wrong, I LOVE Windows 7. You'll make my day with a...
General Discussion


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 18:13.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App