Posts by Ivan F Moala

    Re: "Can't find project or library" Error


    David
    You need to remove the reference to the Calendar control from the computer that doesn't give you this reference error.
    That's what I meant by inadvertently referenceing a control from that computer. The other computers obviously don't have that control / registered.
    The other 2 references are the Analysis Addin. You can leave these alone as they have obviously loaded these addins.



    Re: de activating the Ctr- break


    You will need code similar to this
    Key:=Application.EnableCancelKey = xlDisabled
    Which disables Ctrl + brk..... BUT you also may need the other codes


    eg unload commandbutton and query close routine


    Re: Referencing Different Workbook



    Check your syntax via the Help File

    Code
    1. Workbooks.Open "C:\Documents and_ settings\mdfrailey\Desktop\test\book1.xls"

    Re: Delete a macro button


    Not sure how you are creating your button BUT
    You should name it to something distiquishable eg MyButton
    Then delete the button by this name eg


    Re: password character validation


    Quote from Smooth

    what do you mean. sorry like i said im not the most compotent person in this field. The code you game me works the same as the one i was previously using. I posted a workbook containing the password i was trying to create.


    Sorry again guys (im definately going to take a course in VBA ha)


    Thanx


    What I mean is Exactly what I said What is your current code that you are using ........ here is what you had amended see if this works .....

    Files

    Re: password character validation


    Try this




    Note where the icount is defined ...... @ Module level to keep a static count or to maintain it's variable count.
    Also, good idea to set Focu back to the Textbox after entry .....

    Re: Exclusivity of an XLS


    You could use a VBS eg create in Notepad and save with file extenstion .vbs




    Then just use Windows scheduled task and set it up to run after midnight

    Re: Computer Name, ID



    Hi GB
    Your Excel applications product ID is under
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\[VERSION]\Registration\{90110409-6000-11D3-8CFE-0150048383C9}


    Look for ProductID
    Note: [VERSION] = your version number
    eg 11.0 for Excel 2003, 10.0 2002 9.0 2000 etc.


    Search the Web or this site for REGISTRY Code..... I have some somewhere BUT no time :)

    Re: Application.InputBox command fails to work


    Looks like your Queries are not cleaning up and holding the App.


    Try changing the update options eg.


    Tools > Options > Calculation Tab


    REMOVE (uncheck) Update remote references
    and possibly (uncheck) Save external link values.

    Re: Executing a file


    you need to Shell out using the executable that runs that file


    eg


    Shell "C:\pathto exercutable\Executable.exe c:\test.autoavs",vbMaximizedFocus