Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA6.dll (Excel 2000)

    I run a userform from a table in Excel. Suddenly out of the blue the following error occurs as soon as I try to run the form: File not Find VBA6.dll. Where did this file disappear to and where will I be able to get another copy.

    Thanks

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA6.dll (Excel 2000)

    I suspect there is a problem with the userform in the project.

    See if you can open the userform

    Xl 2000 has a bug regarding using the SaveCopyAs method whilst a workbook has a userform loaded (not necessarily the same as showing!!). See this knowledgebase article .

    Sometimes exporting the form is still possible. Deleting and reimporting (after that, save, close and reopen the workbok to be sure) then solves the issue.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA6.dll (Excel 2000)

    Mario,

    Are you sure it's VBA6.dll and not VBE6.dll?

    If it is VBE6.dll, then from the Help Menu in Excel, not the VBE, Select Detect and Repair...

    THis will repair your Excel/Office installation. It sounds like something may have gotten <img src=/S/hosed.gif border=0 alt=hosed width=73 height=24> with your Office installation.

    It should be in C:Program FilesCommon FilesMicrosoft SharedVBAVBA6
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •