Showing tag results for Office

Hey, Scripting Guy! I need to put the page number (centered) in the footer of a Word document. Do you have any suggestions on how I can do that?-- AW Hey, AW. To tell you the truth, the Scripting Guy who writes this column no longer makes suggestions. That’s because of an incident that occurred a few years ago, when someone he works with sent ou...

Hey, Scripting Guy! How can I select a column of data in Excel and then paste that data into a text file?-- GT Hey, RR. You know, if you’re like most people, any time you hear the words “Scripting Guys” you undoubtedly think of two things: elegance and sophistication. Despite our well-deserved reputation, however, the Scripting Guys are - at hea...

Hey, Scripting Guy! How can I create a table and automatically fill the first column in that table with a range of dates?-- DG Hey, DG. You know, back in the old days we would have been a bit nervous about answering this question. Why? Well, it seems like Word should have a built-in command for doing something like this; however, we couldn’t fin...

Hey, Scripting Guy! How can I convert a number in Excel to a date; for example, how can I convert 40806 to 4/8/2006?-- JM Hey, JM. You probably didn’t know this, but one of the Scripting Guys has a brother who’s an actor. As every actor knows, nepotism is pretty prevalent in the acting world. Well, it’s a good thing the Scripting Guys aren’t act...

Hey, Scripting Guy! In an Excel spreadsheet, how can I locate and replace information for a specific computer?-- BB Hey, BB. You know, there’s an old saying that goes, “If all you have is a hammer then everything looks like a nail.” Well, all we Scripting Guys have at the moment is some code for modifying a record in a database. So guess what: t...