There is a great article over at MSN Finance on how to have a cooler house this summer, without heating up your wallet. This covers great ideas such as using your landscaping to help cool your house and making sure your not leaking that cool air out into the neighborhood via leaky doors and window.
With the really hot days of summer to come, I’m sure we can all find a thing or two here to help keep us just a little bit cooler.
If you’re like me, you use MS Excel quite a bit. I love Excel. I personally think that it is the greatest piece of software ever created. In my position with my company I get a chance to use it quite a bit, and often find myself reusing the same bit of VBA script or the same formula for many different projects. I get really tired of rewriting the same script, recording the same macro, or trying to remember exactly how I built that last formula before I can use it again. If this ever happens to you, you will understand the frustration.
Well, a couple of years ago I stumbled upon a great tip that has saved me considerable time and frustration, and has even made me look like a hero several times. The magic lies in a small, somewhat hidden folder within the Microsoft Office installation folder called “XLStart”.
“What’s so magical about this folder,” you may ask.
Well, that’s what I am about to show you.
First, let’s focus on those often used macros, scripts, and formulas that you have saved in many other Excel workbooks, text files, Post-It Notes, and other divers sources. Round all of the little nuggets up and save them to one work book. Make sure that your macros and scripts do not make references to specifically named sheets in the original source. If they do, I have found that it is best to either change them to the generic “Sheet#” naming that Excel uses by default. You can also have the script prompt you for the desired sheet name if you like.
Second, try to find a way to organize all of the formulas and macros in a way that you will be able to easily find them. I find it very useful to put the name of the formula and/or a small explanation of it just above the cell you are saving the formula in. You should also have some sample data for the formula to use, just so you can remember exactly what it does, just in case you don’t use it for a long time.
Next, save the workbook you have just populated to the “XLStart” folder. If you used the default installation, the folder should be located using the following path:
C:\Program Files\Microsoft Office\OFFICE11\XLSTART
Just remember to name this something beside Book1. I named mine “MacroBook”, just to make things obvious for me.
The last and my favorite part of this is to hide the workbook so that it doesn’t get in your way every time you open Excel. To do this, just go to the menu bar and click “Window” and the “Hide” and select the workbook you saved. Now, close Excel. It will ask if you want to save the changes you made to your workbook. Click “Yes”.
Now, every time you open Excel, this new workbook with your great macros and formulas will be opened in the background and ready for use. To use a macro, simple click on the macro button like you would to run a macro as if you just made it in your current workbook. The macro selection box will pop up and you will see all of the macros listed for all open workbooks. They will show up in the format WorkbookName.xls!Macroname. Simply select it an run it. To use your formulas, simply go to the toolbar, click “Window” and then “Unhide”, select your hidden workbook and it will appear. Then, simply copy and paste the formula you would like to use into the workbook you are working on. When done, simply re-hide the book you had hidden.
This may seem like a long way to go save some simple formulas, but trust me, if you have any complicated formulas or macros that you find yourself re-creating very often, you will quickly come to love this little tip. So, give it a try and let me know how you like it.
Well, you’ve used your binder clips for binding stacks of paper, as a chip clip, and maybe even as a cable holder for you workstation, but here’s a use you probably haven’t thought of, courtesy of LifeHacker, use your small bider clips to keep your toothpaste tube rolled up.
We all know how annoying it is to try to squeeze that last bit of toothpaste out of an almost empty tube. Starting at the bottom and rolling it up as you go really helps to get every last bit out of the tube, but it never seems to stay rolled up. Not a problem anymore.
Once again it’s summer, which means swimming, hiking, mowing, and a mirad of other outdoor activities. All of which lead to sunburn, one of the nasties that we have to endure if we are to enjoy summer to the fullest. If your like me, you want to be able to treat the burn without having to flop down a bunch of dead presidents to do it. Well, look no more, Thrifty Mommy, has given us 10 great remedies that involve things that you probably already have in your house. So, view and enjoy.
Remember the sunscreen and have a great summer.
Powered by ScribeFire.
vs
When Netflix first came on the scene I jumped right on and loved it. I used the surface for about a year and thought it was great because I could get some lesser known movies that I couldn’t find at the local rental places. Plus, not having to go any farther than my mailbox really appealed to my lazy side. After about a year I need that money for other things more than I needed it for movies so I cancelled my service.
Fast forward several years and now I am married with a young child and my wife and I decided it might be time to try Netflix again. Once again I am pleased with the selection, the price, and the fact that I don’t have to go any further than my mailbox to get my movies. However, this time we were painfully aware that the promise of fast turnovers in movie titles was not to be fulfilled for us. We often would mail in a movie on a Friday or Saturday and not get the next movie until the following Thursday or Friday. Needless to say, this didn’t do it for us, so we decided that we weren’t going to get our money’s worth out of this arrangement and decided to cancel our service.
Luckily, about that time we saw the ads for the new Blockbuster service, so we decided to give it a try. Boy, are we ever glad we did. We decided to go for the 2 out at a time, unlimited rentals per month, just like we did with Netflix. The cost was about the same, so we don’t lose anything for trying. The greatest part of the deal is that once we have watched a movie, we can just take it to our local Blockbuster store and exchange it for a FREE in-store rental. Plus, as soon as they scan the movie in that we are returning, the online system is notified and our next movie is processed and mailed out to us the next day. Now, we get a movie (usually 2) on Wednesday, watch it, take it to the store on Friday or Saturday, get another movie, and then our next movie from the online service arrives the next Wednesday. No more waiting a week for our movies. We truly get to take advantage of the unlimited part of our service now.
Another great benefit is Blockbuster often sends free rental coupons for games and movies with the movies they mail. We also get some online that we can print out from time to time.
So, I guess the moral to the story is, Blockbuster, in addition to being a great new service, should soon become a Netflix buster.
Powered by ScribeFire.
