![]() ![]() Now I just have another 59 minutes to trim! '. It only took me a couple of minutes to add the code, so the time invested was quickly repaid. The Excel VBA code saves a copy of the active workbook, into the Backup folder, and adds the previous day’s date to the file name. To get rid of that manual step, I added a few lines of code to the existing macro. ![]() ![]() Not a huge productivity drain, but why do something manually, if it can be easily automated? Make It Automated Don’t ask me why.Įxcel is a bit slow when opening the Save As dialog box, so that final step was taking 30-60 seconds. For some reason, I was doing the last step manually. download some website statistics to Excel,įortunately, I have a macro that does the first 2 steps.What can you change about your Excel habits, to save an hour a day, or even a few minutes?.Well, you’re a geek, so you don’t have to hire one! Just pay attention as you run through your morning office routine, and answer this question: Last week, Seth Godin recommended hiring a geek to help you save an hour a day. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |