VB for EXCEL

[akar33]

I am trying to open
1. create a macro that will open EXCEL workbook
2. count the number of columns, if it is less than 5 it will fails, gives error message
3. Counts to see, if it has more than 12 lines (records), if less it fails, gives error message.

Thanks
Annie

 

[SqueakinSweep]

Opening an excel workbook is a subject covered countless times here. Reading and picking out the relevant bits from thread796-1195737 should give you what you need.

Sweep
...if it works, you know the rest..
Always remember that Google is your friend

 

[djj55]

If you still need help you might try the MS knowledge base article 306022 or see

http://msdn.microsoft.com/library/en-us/odc_vsto2005_ta/html/OfficeVSTOExcelObj.asp?frame=true

djj