lundi 20 avril 2015

Automatic add reference to VBA Excel macro via c#

I add a macro by c# code to excel for running stored procedure and execute it but becuase it has not refrence of ActiveX Data Objects 2.5 library gets an error "complie error : user-defined type not defiend " when i add that refrence manualy it will be ok but i want to add it via code because user cant refrence it.

then I need to programaticly check the users PC to see if a reference to

Microsoft ActiveX Data Objects 2.5 Library or later

Exists and if it does not, create it by C# code or VBA code in my macro

Aucun commentaire:

Enregistrer un commentaire