Category "excel-2007"

Count wildcard date in Text String

I am looking for a formula to Count Specific date in Text String. My answers work with words, but if I use wildcards it doesn't work. W33 is the sample text bel

Getting STA error when try to open OpenFileDialog box in Excel addin project

I have created Excel addin project using Visual Studio to insert a data into database. The problem is I'm unable to open a File upload box in this. I am getting

Need to populate master list from many different sheets in excel

So lets say I have 3 different sheets each with information on them like this: Sheet 1 Sheet2 Sheet 3 item1|2 item2|7 item1|4 item3|5 item3|6

How can I extract rows of information from multiple sheets by typing in a date

I need to extract data from multiple sheets in excel. I have made one excel workbook with different repair schedules for different properties. On the first shee