Ever copy a table from an ASP page? And the table had some pictures of your friends mean cat in it that you didn’t want? Here’s some help with that, from Google Groups: Open the workbook select that worksheet hit alt-f11 to get to the vbe hit ctrl-g to see the immediate window Type Activesheet.pictures.delete […]
Excel! Here’s how to read data from the first sheet, regardless of the sheet name. It was really annoying to think that I needed to add some excel specific library to just read the first sheet (regardless of name).