Everyday I get an email with a spreadsheet. Instead of pasting in my vb code into the macro editor, I want run a vb script from windows on the spreadsheet. Since the spreadsheet's name changes with the date, I thought it would be easiest to look for an active excel window. Any other suggestions are welcome.