Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Apr 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Any changes necessary for a DLL in Win2K vs. Win9x (VBA Excel Win9x/Win2K)

    I have been accessing my own DLL from within Excel in Win9x for years, and now I need to do it in Win2K. I will test it today, but I was wondering if there were any known issues that would make it necessary to recompile my DLL before it could be usable in Win2K? It is a simple and very small DLL implementing functions that calculate numeric values and return them.

    What I was wondering is if there are new calling conventions that would need me to recompile the DLL before it would work in Win2K.

    I understand that could be code dependent, but I was just wondering if I was opening a Pandora's box.

    Thanks in advance,

    Michael Phillips

    p.s. Is Robin Trew still active in here? If so, your help with accessing DLLs within Excel was extremely helpful in the past. Thanks again.

  2. #2
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Any changes necessary for a DLL in Win2K vs. Win9x (VBA Excel Win9x/Wi

    AFAIK, Robin moved on a few years ago to some position in higher academia, as I recall. Haven't seen a post since.

    As long as you compiled your dll for Win32, you should not have any problem using it on W2k PCs -- assuming, of course, that you register it first. I'm not sure what complications can arise with 16-bit code on Wk2, but if yours is 16-bit, recompile.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  3. #3
    New Lounger
    Join Date
    Apr 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Any changes necessary for a DLL in Win2K vs. Win9x (VBA Excel Win9x/Wi

    Well, on the Win2k box, I receive an "Error in loading DLL (Error 48)" message when trying to add the dll as a reference to VBA in Excel.

    I had compiled the dll with VB 6.0 sp3 a while ago. I just upgraded to sp5. I believe the dll was compiled as 32-bit .

    Any other suggestions?

  4. #4
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Any changes necessary for a DLL in Win2K vs. Win9x (VBA Excel Win9x/Wi

    Register it first with the OS:

    regsvr32 c:thefullpathname/yourdll.dll
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  5. #5
    New Lounger
    Join Date
    Apr 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Any changes necessary for a DLL in Win2K vs. Win9x (VBA Excel Win9x/Wi

    Thanks, that was silly. I hit that problem before and forgot the solution. Arrgh.

Posting Permissions

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