Posts by Gizzmo

    Re: Activating Certain Workbook


    Could you try something like


    Code
    Sub Macro1()
     Windows("your string here").Activate
    'you probably do not need this bit of code but just in case
     Sheets("Sheet1").Select
    End Sub

    Re: Vba Type Mismatch When Subtracting Dates/times


    Hi Brad,


    try this it seems to work.


    Gizzmo


    Code
    Sub WorkedHours()
        Dim vStart As Date, vEnd As Date
        Dim vHours As Integer
         
        vStart = "11/09/06 22:00"
        vEnd = "11/09/06 23:30"
         
        vHours = (vEnd - vStart) * 24
    End Sub

    Re: Userform Database


    Sorry Roy,



    Here is my code for any one who might find it of use.


    Sorry if I have inadvertantley broken any rules.


    Gizzmo