Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Lexington Park, Maryland, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linking to DLL's through Excel (Excel 2000)

    We have a DLL written in C++ being called from a VBA macro in Excel in Windows 2000. It works fine on computers that have Microsoft Developer Studio and Visual C++ 5 installed. On computers without this software we get the error message "Can not find the DLL". We checked the imports list and it is only importing from kernel 32. We have verified that the DLL is in the correct path. We have also tried specifying the path explicitly. We have tried putting the DLL in the windows directory.

    Mike

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linking to DLL's through Excel (Excel 2000)

    Have you registered the DLL on all target PCs? An installation package for the DLL will do so, or you can do it manually:
    - Select Start | Run...
    - Type regsvr32 "path_and_filename.dll" (substitute the correct path and file name)
    - Click OK.

  3. #3
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Lexington Park, Maryland, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking to DLL's through Excel (Excel 2000)

    This solution did not work. It gave an error.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linking to DLL's through Excel (Excel 2000)

    "It gave an error" is not very informative. I don't know anything about C++, so I can't provide further help, but it might be useful for others if you posted the error message.

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking to DLL's through Excel (Excel 2000)

    AFAIK the only error message you can get off a regsvr32 command is that it did not succeed. Just to reconfirm the Run command should have read something like:

    <code>regsvr32 "C:WindowsSystem32excelspecial32.dll"</code>

    Generally, quotation marks are only necessary if there are any spaces in the path and/or name. Otherwise, they can be safely omitted.

    Is that the format that produced the error message?

    HTH
    Gre

Posting Permissions

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