none
using tlb file as reference on different machine RRS feed

  • Question

  • https://stackoverflow.com/questions/3217014/how-to-securely-store-connection-string-details-in-vba

    by using above link <g class="gr_ gr_21 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" data-gr-id="21" id="21">i</g> was able to do <g class="gr_ gr_73 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins replaceWithoutSep" data-gr-id="73" id="73">secure</g> connection between <g class="gr_ gr_80 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del" data-gr-id="80" id="80">oracle</g> and EXCEL VBA. It uses <g class="gr_ gr_143 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="143" id="143">tlb</g> file to do so.

    When <g class="gr_ gr_160 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" data-gr-id="160" id="160">i</g> am using same .tlb file at another machine it gives me an error i.e. "Error in Loading <g class="gr_ gr_284 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="284" id="284">dll</g>"

    • Edited by Shekhar1986 Thursday, August 17, 2017 12:12 PM
    Thursday, August 17, 2017 12:04 PM

All replies

  • Hi Shekahr1986,

    According to your description, you do the steps from the link of SO you provided, and that when you add reference of ActiveX to ClassLibrary you get an error "Error in Loading dll"?

    I create a class library to add the reference of ActiveX, there is no error. 

    Or you get the error when you add reference of dll to VBA, maybe you do not register the dll in another machine. 

    According to your question is more related to VBA, you could post a new thread in VBA forum for suitable support.

    The CLR Forum discuss and ask questions about .NET Framework Base Classes (BCL) such as Collections, I/O, Regigistry, Globalization, Reflection. Also discuss all the other Microsoft libraries that are built on or extend the .NET Framework, including Managed Extensibility Framework (MEF), Charting Controls, CardSpace, Windows Identity Foundation (WIF), Point of Sale (POS), Transactions. 

    Best Regards,

    Wendy


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, August 23, 2017 6:29 AM
    Moderator