13

I have to download multiple csv reports from the Internet throughout the day, make a tiny change to them, and save the change. Excel adds 3 completely unnecessary dialogs to what should really be a 5-second operation.

  1. It makes you select a file name in a "Save As..." dialog, even though you just want to save the existing file
  2. It makes you confirm the file name, because it thinks you're overwriting the original file
  3. It asks you if you really want to save in the CSV format

Is there a way to kill at least one or two of these dialogs, but ideally all of them? This is completely infuriating.

8
  • 3
    Not a duplicate. This deals with 3 prompts, not just 1. Also, that solution is for 1 file only. The macro has to be run on each new file. My issue is dealing with a large number of files. – Knocks X Feb 3 '14 at 22:51
  • You could use another software such as Notepas++ for this purpose. It lets you handle multiple files in tabs and is much simpler for .csv files. Unless of-course you need any of MS Excel features. – agirish Feb 4 '14 at 1:42
  • I'm open to using other programs, but I need the data displayed as a table instead of a bunch of data, and I need to be able to sort the columns from smallest to largest. Those are the only functions I need. – Knocks X Feb 4 '14 at 1:52
  • try this – Raystafarian Feb 4 '14 at 15:41
  • @Raystafarian What's the code they are referring to? I am not familiar with customizing Excel. Where does this code go? – Knocks X Feb 4 '14 at 16:19
8

I have consulted multiple sources, and there is no fix for Microsoft Office.

However, I installed LibreOffice, and it handles CSV files the exactly correct way. I made LibreOffice the default program for opening CSV files, and the problem is now solved.

Not the answer you're looking for? Browse other questions tagged or ask your own question.