View Single Post
#32: 04-20-2012, 04:08 PM
 
 NSFW
NSFW's Avatar
Title: Stage Free
Location: Seattle-ish
Car: 6mtblackturbowagon
Posts: 8,954
iTrader: (9)
Send a private message to NSFW Find all posts by NSFW Reply With Quote
I have a very-slightly less hacky way to do that sort of thing.... After doing that once, delete the contents of all of the cells with the raw log data, and save the spreadsheet someplace safe. Consider making it read-only as well.

The next time you want to view log data, open the log, open that saved spreadsheet, and copy-paste the log into the saved spreadsheet. I have a spreadsheet like this with a whole bunch of computed columns, scatter plots, etc. Just be sure you don't accidentally save over the top of your emptied spreadsheet. Or, get into the habit of re-opening your previous spreadsheet and pasting new raw CSV data into it.

Some day I'd like to learn how to put an "Open CSV File" button on my spreadsheet, so I could skip a couple steps. But VBA is hard.