Results 1 to 4 of 4

Thread: Sharing Excel DLL Issue

  1. Dec 1st, 2022, 05:22 AM #1
    DarrylF
    DarrylF is offline

    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
    Reply With Quote Reply With Quote
  2. Dec 1st, 2022, 07:55 AM #2
    jmcilhinney
    jmcilhinney is offline
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    109,998

    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.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB (Sorting AlphaNumeric Strings Logically NEW, Binding a Data Reader in Windows Forms NEW) | C# (Sorting AlphaNumeric Strings Logically NEW, Binding a Data Reader in Windows Forms NEW)
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL
    Reply With Quote Reply With Quote
  3. Dec 1st, 2022, 09:54 AM #3
    Shaggy Hiker
    Shaggy Hiker is offline
    Super Moderator Shaggy Hiker's Avatar
    Join Date
    Aug 2002
    Location
    Idaho
    Posts
    38,626

    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
    Reply With Quote Reply With Quote
  4. Dec 1st, 2022, 10:08 AM #4
    jmcilhinney
    jmcilhinney is offline
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    109,998

    Re: Sharing Excel DLL Issue

    I'm assuming that you're talking about a DLL written in VB.NET. Is that correct?
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB (Sorting AlphaNumeric Strings Logically NEW, Binding a Data Reader in Windows Forms NEW) | C# (Sorting AlphaNumeric Strings Logically NEW, Binding a Data Reader in Windows Forms NEW)
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width