Forum Discussion
YMinaev
Staff
16 years agoHi,
I recommend that you perform your validations via COM. All MS Office applications provide very convenient and deep access to their documents this way, so you should be able to check anything you want. To obtain a COM object, use the Sys.OleObject property (for example, to obtain Excel, use excel = Sys.OleObject("Excel.Application")).
To find out which objects, properties and methods you should use to work with the target Office application, see its built-in VBA reference.
I recommend that you perform your validations via COM. All MS Office applications provide very convenient and deep access to their documents this way, so you should be able to check anything you want. To obtain a COM object, use the Sys.OleObject property (for example, to obtain Excel, use excel = Sys.OleObject("Excel.Application")).
To find out which objects, properties and methods you should use to work with the target Office application, see its built-in VBA reference.