.vba

[vb_student]

i came across a utility called password.vba for excel and word files and downloaded it.

when i tried to open the password.vba, it did not open instead it seemed to execute itself i hope i dont have a trojan.

isn't a .vba file "openable" in VB6 or MS Excel?

[JustinLabenne]

I don't recall ever seeing a file with a .vba extension. Could be wrong though, I just have no idea what that could be,

I have seen a Password.xla which is an add-in for unlocking Excle sheets and workbooks...

[vb_student]

maybe the password.xla got renamed as password.vba, it does seem to have the excel icon. hope i have not downloaded something nasty

[dannymking]

If the file executed by itself then it probably had password.vba.exe and could possibly be a virus.. run a scanner on your machine.

password.xla would of opened a session of Excel when opened.. If no Excel was opened then it was an exe and not an add-in

[vb_student]

oops, it is password.xla
i did a right click properties on the password.xla and on the general tab it says

type of file: microsoft Excel add-in
opens with : microsoft excel

when i try to open it with excel, it does open up a microsoft excel session but it comes up with a msgbox saying that

"password remover now loaded ....."
with an OK button at the bottom

i did an alt + f11 to view the contents and it says password.xla and then tried to view it, it says that the project is locked, is this a legit .xla or is it a nasty .exe file?

[dannymking]

No it is a legit XLA and cannot be an EXE, it could however have hidden code that could do something.. check your Addin's in the worksheet tools menu and it should be in there..

Why do you need this file? there may be other ways.

[vb_student]

i did a

tools->add ins
but can see only the following add ins

1. analysis toolpak
2. analysis toolpak - VBA
3. conditional sum wizard
4. euro currency tools
5. internet assistena VBA
6. lookup wizard
7. solver add-in

all check marked

[dannymking]

Use the browse button to find the password.xla from where you saved it. this will import it into Excel.

[RobDog888]

If its not from a reputable source/company then I wouldnt trust it. If you purchased it then its probably ok, but if DL'd from a crack site then we cant support you on that one.

[vb_student]

i downloaded it after doing a google for it.
i dont think it is a crack site

i will use the browse button to find it to import it into excel. i thoguht the message i got

when i try to open it with excel, it does open up a microsoft excel session but it comes up with a msgbox saying that

"password remover now loaded ....."

meant that it was part of excel

once it is loaded, does it become part of the excel toolbar?

[RobDog888]

There could be a new toolbar with new button(s) or just new button(s) added to an existing toolbar.

[vb_student]

i did a
tools --> add-in --> browse and added the password.xla, and it now appears part of the add-ins

i guess the worksheet would be unprotected now.

hey at any point if i were to remove the add-in, how do i do that?

[RobDog888]

Tools > Addins > uncheck your addin and click ok. It wont uninstall it but it will unload it.

[vb_student]

is there a way i can uninstall an add-in?

[RobDog888]

Look in the Add/Remove Programs applette in the Control Panel. If its listed in their then it can be uninstalled. Else look in its directory for na uninstall exe.

[dannymking]

An addin could also be moved to the library in office when installing it through the Addin's Browse and not as a installation package, uninstall it by deleting it from this library, it could also be placed in "XLSTART"

[vb_student]

is there a time limit on the program?

i tried to locate it on the control panel --> add/remove but it was not there

i checked out the following directory, but it was empty

C:\Program Files\Microsoft Office\Office10\XLStart


is there a limit to using the password.xla program,

is there a foolproof way of protecting your word and excel files

[RobDog888]

There is no Foolproof way. There are legitimate VBA password cracking programs out there and the internal methods like Protect are useless. Maybe making a dll out of it and referencing the dll in the vba code?

[dannymking]

Did you also check the library folder in office 10..

C:\Program Files\Microsoft Office\Office10\Library

Run the following peice of code in a normal spread sheet to determine the name of the addin and it's location on your computer

Sub GetAddins()
  Dim i As Integer
  For i = 1 to Addins.Count
    Debug.Print "Name: " & Addins(i).Name & " Location: " & Addins(i).FullName
  Next i
End Sub

Once ran open the immediate window (CTRL+G) and look down the list to see if it is actually in the addins list, and you will see it's location

[vb_student]

thanks for the reply dannymking

i have done a bit of VB coding before but not any VBA coding, can you tell me how and where to stick the
getaddins code

i got the forms toolbar and selected a command button which says button1, but i cant rename it

i was trying to rename it to getaddins and then i would double click on it to get to the code section and could paste the code but i cant get to the code windcow that way


i did an alt + f11 to get to the code section and could not see any reference to button1 either

[dannymking]

Press ALT+F11 to open the VBE.. Then press CTRL+G to open the immediate pane, click Insert > Module in the menu bar and copy the code from my last post and paste it into this new module.. click somewhere in the code and then press F5 and the immediate window will display all of the add-ins and their relevant locations..

i did an alt + f11 to get to the code section and could not see any reference to button1 either

[vb_student]

cool does thie mean i can have a VB project without forms, just with modules?

can i not have some sort of command button on the excel sheet which when pressed would print out the locations

[zaza]

Of course. Make sure you have the VB toolbar visible in Excel, select "Design mode" and you can put a button on the form. Double-click the button and it will take you to the event handling code. Put whatever you like in there.

zaza

[vb_student]

hey zaza how do i go into design mode

i managed to put a command button but it takes me to a dialog box with a bunch of options where i can record a macro

[zaza]

Right-click on a toolbar on the main Excel page and from the dropdown, choose Visual Basic. The Design Mode is the button with the set square, ruler and pencil on it. Alternatively choose the Control Toolbox menu - that has Design Mode on it as well as all the VB controls.
If you double-click the button you'll go to the VBA editor. When you record a Macro, it writes it in VBA as well.

zaza

[JustinLabenne]

Just for adding notes to this,

This is the add-in in question:
http://www.straxx.com/excel/password.html

If you want to remove ths add-in, just find where ever you downloaded the add-in too, and delete it. When you open up Excel, you may get a prompt notifying of it's removal, or you can open the add-in's dialog (Tools > Add-ins) and it will say you can remove it by selecting it.

[vb_student]

hey that means there are three toolbars i can work with
forms, Visual Basic & control toolbox, should not forms and control toolbox be a part of Visual Basic menu?

i guess if i click on design mode once i am in design mode and if i click it a second time i exit the design mode.

i double clicked the button, and it says assign macro? and it comes with the record button. is there a way i can end up getting the code writing section instead of recroding a macro?

also is there a section which shows how to record macros?

hey justin, you mean locate the add-in and deleted it if it is say on the c:/mydrive/ and then when i open uip excel it will say it has been removed?

[JustinLabenne]

hey justin, you mean locate the add-in and deleted it if it is say on the c:/mydrive/ and then when i open uip excel it will say it has been removed?

Yep.

If the add-in is loaded, it will say it can't find it. If it's not loaded, then (and do this anyways) with Excel open, Go to TOOLS > ADD-INS >

When the dialog box listing all the add-ins appears, select "Password Remover" in the list (it should be there if you have used it) and it will prompt you saying it has been deleted or if can't find it, something along those lines.