Showing tag results for Excel.Application

Hey, Scripting Guy! In an Excel spreadsheet, how can I change the color of a row if there is a date stored a particular cell in that row?-- GL Hey, GL. Some of you might have noticed that there was no Hey, Scripting Guy! column yesterday. Is that because the Scripting Guys are slacking off and shirking their responsibilities? Of course; after a...

Hey, Scripting Guy! How can I delete all the worksheets in an Excel spreadsheet except for the first worksheet?-- NN Hey, NN. Please excuse any bloodstains that might appear on your screen; as it turns out, the Scripting Guy who writes this column was involved in an … incident … this past weekend. Ah, but dedicated Microsoft employee that he is,...

Hey, Scripting Guy! How can I configure Office Excel to autosave every 5 minutes?-- KK Hey, KK. You know, that’s a good question. As it turns out, the autosave capability in Microsoft Excel – hey, wait a minute: do you realize what day it is? Today is the first day of the 2007 Winter Scripting Games; why in the world are you reading ...

Hey, Scripting Guy! How can I save an Office Excel chart as a picture?-- JB Hey, JB. You know, yesterday was a good day for the Scripting Guy who writes this column. If the phone rings at the Scripting House and if it’s for the Scripting Guy who writes this column, well, it’s never really for the Scripting Guy who writes this column;...

Hey, Scripting Guy! In an Office Excel spreadsheet, how can I change the color of the text if the value in column B minus the value in column A is greater than or equal to 10?-- EP Hey, EP. You know, before the Scripting Guy who writes this column started writing this column, he vowed that Hey, Scripting Guy! would have a laser-like focus on hel...