In order for this formula to work you need to make sure the workbook has been saved; otherwise, the cell will result in an error.
FORMULA:
=MID(CELL("filename",A1),FIND("]",CELL("filename"))+1,255)
VIDEO TUTORIAL:
EXCEL: Set Cell Value as Tab Name
We are expecting our second child!!!
We are so excited!!! Possibly due in September or October. This is great news....
New whip...
I am debating on this. I do like it, but I also like the New Toyota Sequoia 4X4 and the Tundra Crew Max 4X4 for the off road action. When we went up to Flagstaff this year it would have been nice to have 4X4 to explore more areas. That is where the Sequoia and the Tundra come in. I know the Porsche is AWD, but the space in the Toyota’s is unquestionable.
Flight through Heaven...
I thought I would share this. This is a quick little video from my window seat as I journey to Chicago Midway Airport. Captured with my Nikon Coolpix S600. Mind your sound level, this might be loud on your speakers. It is short, but sweet!
Flight to Chicago (MDW) from Samson Loo on Vimeo.
Gift from my wife.
What a surprise gift. My wife presented me with Seiko watch from the Coutura collection. I especially enjoy this time piece due to the color of the face. Out of my other watches this does not have a gold or white face. Very simple. I love it. What a gift to receive!
It features a:
- Cabochon Crown
- Sapphire crystal
- 100 meter water resistance
As I read through the users manual I spot a section of the Calendar setting that states, "Do not attempt to set the Calendar between 9PM to 4 AM". I thought this was odd, but since the calendar is designed to change only once every 24hrs it can be thrown off if set between the stated threshold. Interesting to know.
My New Little Home Server...
I have been contemplating to pick up a pre-configured HP MediaSmart Server or to build my own. After some research I found that the MediaSmart Server is limited to configuration. Meaning I would have to purchase it with only 512MB and either 500GB or 1TB, then upgrade it after I received it. Which is a waste of my time. Not to mention that I want a beefier processor...I am talking Core 2 Quad power! Anyhow I felt a burning sensation and no it is not what you're thinking...in my pocket so I spec'd my own system and here it is:
Shuttle SG31G2 (Black)
Intel 2.4GHz C2Q Q6600 8MB 775 Quad Core Processor
4GB DDR2 800 PC-6400 Dual Channel 240-Pin Memory
2x - Western Digital WD10EACS 1TB SATA 3.0Gb/s 16 MB Cache
Samsung CD/DVD Burner (I know I wanted the Blueray burner too!)
2x - KINGWIN 15.74" SATA Data & Power combo cable
Arctic Silver 5 Thermal Compound
Microsoft Windows Home Server 32 Bit 1 Pack
Here are a few pics of the Shuttle, once it is pieced together I will add more pics.

SQL Server 2005...
With SQL Server 2005 you can install multiple instances of certain components to run concurrently on a system. These are known as the instance aware components.
- Database Engine
- Analysis Services
- Reporting Services