Recent content by Xanadu

  1. X

    Unzipping files using WinZIP in VBA

    Well, I'm first scanning the registry to see what program is associated with a ZIP archive, and then I'm trying to open a file with that program. All I need to do is replicate what happens when the user double-clicks a ZIP archive in Windows Explorer, it can't be THAT difficult. I can do it...
  2. X

    Unzipping files using WinZIP in VBA

    Yes, and I found 2 posts with detailed code on how to ZIP, but none on how to UNZIP. It's probably the same code but with a different WinZIP command, the posts I found used "-d" and "-a", but neither of them is working for me.
  3. X

    Complicated Date Calculation

    Why not use the DateAdd function to determine how many days the driver is away from their 18th birthday? If the DateAdd number is positive, add it to the AccidentDateField. If the number is negative, the driver is over 18 and you just add 2 years (or 728 days).
  4. X

    Unzipping files using WinZIP in VBA

    I can't seem to find any code to UNzip a file in VBA. Anyone know how to do this? I also can't find anything on WinZIP commands, not even on their website. Any info would be appreciated.
  5. X

    How to open password protected mdb in VB

    Here's the syntax, I'm not sure if the method you use makes a difference: OFile = your database's name (with full path) Pass1 = your database's password Set db = OpenDatabase(OFile, False, False, ";pwd=" & Pass1) If Err.Number = 3031 Then MsgBox "The password you entered is not valid. Please...
  6. X

    Adding Links to Word Documents

    Yes, I've done it before but I don't have an example in front of me. I know it required using the common dialog control. Perhaps a search on Google will help, I'm 99% positive the code I used was found on the Internet.
Back
Top Bottom