PDA

View Full Version : VBA VS COM ADD IN



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

macropod
10-14-2010, 12:24 AM
Hi mohanvijay,

We don't help with password retrieval/breaking here ...