Results 1 to 4 of 4

Thread: Sharing Excel DLL Issue

  1. #1

    Thread Starter
    New Member
    Join Date
    Dec 2022
    Posts
    1

    Sharing Excel DLL Issue

    Built Excel VBA solution and setup the ADODB Database Connection String to point to a DLL (Created in Visual Studio 2019). All working fine.

    However, wanting to share this Excel Workbook with other users (each have their own copy) it results in an error with the DLL (Class Library not registered) on their computers

    I realized that i can't just copy the DLL over to the other computers and that it needs to be re-complied on each machine. Is there another way that i can do this without having to put it on a server or buy induvial Visual studio licenses

  2. #2
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,274

    Re: Getting connection string from Class Library

    It doesn't need to be recompiled. If it works at all from VBA code then you must have made it COM-visible so you need to register it on each machine, pretty much as you would an actual COM object. The .NET regasm utility will do that.

  3. #3
    Super Moderator Shaggy Hiker's Avatar
    Join Date
    Aug 2002
    Location
    Idaho
    Posts
    38,943

    Re: Sharing Excel DLL Issue

    I'm not sure where this should be. It doesn't sound like ASP, but it came from that. It also sounds a bit like VBA, though the actual issue doesn't sound like it's VBA. If there is a better place for it, let us know.
    My usual boring signature: Nothing

  4. #4
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,274

    Re: Sharing Excel DLL Issue

    I'm assuming that you're talking about a DLL written in VB.NET. Is that correct?

Posting Permissions

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



Click Here to Expand Forum to Full Width