Excel: Find last row in a spreadsheet

Sub xlCellTypeLastCell_Example_Row()
Dim LastRow As Long
With ActiveSheet
LastRow = .Range("A1").SpecialCells(xlCellTypeLastCell).Row
End With
MsgBox LastRow
End Sub

The Pygmalion Effect

The Pygmalion Effect

aka:Self Fulfilling Prophecy , The Rosenthal Effect

Praise with vision goes a long way.

People tend to live up to what's expected of them and they tend to do better
when treated as if they are capable of success.

These are the lessons of The Pygmalion Effect.

Pygmalion first appeared in Greek mythology as a king of
Cyprus who carved and then fell in love with a statue of a woman, which
Aphrodite brought to life as Galatea.

Much later, George Barnard Shaw wrote a play, entitiled Pygmalion, about Henry Higgins (the gentleman) and Lisa Doolittle (the cockney flower girl whom Henry turns bets he can turn into a lady).

So the Pygmalion Effect has come to mean "you get what you expect." If you expect disaster, your expectations may well be met in a kind of "self-fulfilling prophecy," yet another catch phrase about the pressure of expectations.

from :
http://www.envisionsoftware.com/articles/Pygmalion_Effect.html

Big Oven Recipe software

The only user-data files that BigOven uses are the ones in the "My BigOven Recipes" folder. The application itself installs to c:Program FilesLakefront SoftwareBigOven.

---
Make a copy of the recipe and shopping list data. Locate your "My BigOven Recipes" folder, and check the "last modified" dates to make sure you've got the most recent ones. You can search for the files named "*.crb" to locate them easily. Usually, they are either under your "My Documents" folder or your "Shared Documents" folder. If you've updated multiple times, you may have a couple copies -- you can check the "last modified" date in Windows Explorer to make sure you have the most recent set.


Make a copy of the recipe and shopping list data. Locate your "My BigOven Recipes" folder, and check the "last modified" dates to make sure you've got the most recent ones. You can search for the files named "*.crb" to locate them easily. Usually, they are either under your "My Documents" folder or your "Shared Documents" folder. If you've updated multiple times, you may have a couple copies -- you can check the "last modified" date in Windows Explorer to make sure you have the most recent set.

for detailed instructions, you can go to http://www.bigoven.com/cs/forums/t/1665.aspx

confirm pop up in javascript

if (confirm('Are you sure?')==false) return false;

hit the easy button!!

SSRS: What Reports do you have out there?

list all the reports you have on your server:

use ReportServer


select ds.name as datasourcename ,
ct.name as itemname ,
ct.path
from dbo.catalog ct (with nolock)
inner join dbo.datasource ds
on ct.itemid = ds.itemid
where type = 2
order by datasourcename ,
itemname