Showing results for February 2008 - Page 2 of 5 - Scripting Blog [archived]

Hey, Scripting Guy! have a folder that has a whole bunch of files in it. Many of those files have a file name that includes an incorrect date; for example, the file might be named FGA Site Visit 2-14-07 204.jpg when it should really be named FGA Site Visit 2-14-08 204.jpg. (That is, it suggests the visit occurred in 2007 rather than 2008.) How can...

Hey, Scripting Guy! My manager does not like appointment reminders; therefore every meeting request she sends is without reminders.  I like reminders and I try to remember to turn them on, but sometimes I forget; that means that if I'm not on top of my schedule, I can miss a meeting. How can I write a script that will go through all my m...

Hey, Scripting Guy! I’m trying to determine – and mark – the first occurrence of a number in an Office Excel worksheet. However, I can’t figure out how to go about doing this. Can you help?-- BH Hey, BH. Before we launch into today’s column we have an announcement to make: the Scripting Guys surrender. You have beate...

Hey, Scripting Guy! Here’s what I would like to do. I would like to put a script in the SendTo folder that would enable a user to easily change the file extension for a file. (Typically our users hide the file extensions, which makes it difficult for them to change those extensions when they need to.) However, I haven’t been able to fi...

Hey, Scripting Guy! I’m trying to use regular expressions to extract three-digit numbers that are enclosed by pipe characters; they embedded in string values like this: |159|468|572|843|. However, I can’t figure out the syntax that will get this to work. Can you help me?-- RS Hey, RS. Before we answer this question we should note that...