I saw there was a new SyncToy out that is Vista compatible ... very cool only ONE PROBLEM, it is not 64 bit compatible so-long SyncToy 1.4 you won't work on my PC.... rather sad seems like the 64 bit computing is taking off slowly with lots of native 32 bit programs running in X64 architecture.
At least Windows Desktop Search is running true 64 bit mode , WOW however the user interface is no way near google desktop , pitty that is not available in 64 bit mode ....
Monday, 29 January 2007
Wednesday, 24 January 2007
Excel Formula Activecell.FormulaR1C1
What a mission, I was trying to insert a formula into a cell via a Macro with variables in it but got stuck with TExt values or #NUM values the whole time. I tried about anything
- (variable,
- ("variable",
- (" & variable & ",
- (''' & variable & "",
- (""" & variable & """,
but with no luck,
I then even created a string = "formula with variables" and used ActiveCell.FormulaR1C1 = string but it did not work either just to realize :
Use ActiveCell.Formula =
and not
ActiveCell.FormulaR1C1
and that solved my variable within a formula in Excel VBA Script ;-)
Monday, 8 January 2007
Our Daugter's Room
Well I got bored again and decided to add a star roof in the corner of our daughter's room, so I took hardboard, drilled some holes and painted it blue with silver clouds [First attemt at painting clouds] added LED's in there and hooked it to the ceiling and boy oh boy she loves it !
Swimming Pool Light
Well, Eventually the light decided to blow :-( after I repaired the cable the previous time, So the next challenge started ....How do you replace that light ?
Well here is a pic of the unit as it fits into the pool , so remove the unit extract the sealed beam light from the back, replace it but make sure the seal at the back seals tight and whala !
Subscribe to:
Posts (Atom)