| Mobile | RSS

Delete Pics help from Excel-anauts

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 […]

[ More ] October 6th, 2009 | No Comments | Posted in software |

Excel: Read first sheet, even if you don’t know the name

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).

[ More ] February 19th, 2009 | No Comments | Posted in software |