Category "excel-2007"

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