mohanvijay
10-13-2010, 11:33 PM
Hai ,
I write VBA to get password of other excel files
it takes 1.25 minutes for get password "zzz" (selection criteria: only small letters, minimum length=3, maximum length = 3)
and takes 25 minutes for get password "zzzz" (selection criteria: only small letters, minimum length=4, maximum length = 4)
so i think it will run faster to make his as COM ADD IN
i get example from http://www.cpearson.com/excel/CreatingCOMAddIn.aspx and make DLL and regiter
but the COM ADD IN takes 2.15 minutes where VBA takes 1.25 minutes and still run upto 45 minutes where VBA takes 25 minutes how do i get
faster the code and why the COM ADD IN run slowly
i attached sample of vba
please help
I write VBA to get password of other excel files
it takes 1.25 minutes for get password "zzz" (selection criteria: only small letters, minimum length=3, maximum length = 3)
and takes 25 minutes for get password "zzzz" (selection criteria: only small letters, minimum length=4, maximum length = 4)
so i think it will run faster to make his as COM ADD IN
i get example from http://www.cpearson.com/excel/CreatingCOMAddIn.aspx and make DLL and regiter
but the COM ADD IN takes 2.15 minutes where VBA takes 1.25 minutes and still run upto 45 minutes where VBA takes 25 minutes how do i get
faster the code and why the COM ADD IN run slowly
i attached sample of vba
please help