+ Reply to Thread
Results 1 to 3 of 3

Excel VBA to include Libraries in Workbook

  1. #1
    Registered User
    Join Date
    04-17-2019
    Location
    Vilnius, Lithuania
    MS-Off Ver
    2016
    Posts
    3

    Excel VBA to include Libraries in Workbook

    Hello,

    Need to find solution for my problem,

    In order to automate some of work, I have written Excel VBA code, which uses Selenium Library files, therefore on my PC everything works just fine, however, I am not the only one who will use it.
    This Workbook will have to be used on hundreds of other computers, however, I am not able to install Selenium Library in all of those PC's. Is it possible to run Macros, which are using some libraries without actually installing them on PC?
    Maybe it is possible to include exact library in the Worksheet itself, so it would be opened automatically together with Workbook itself?

    Thank you!

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,938

    Re: Excel VBA to include Libraries in Workbook

    If you have the files, you could use macro code to copy them to every machine that uses your Excel file by checking for their existence - whether that will work will depend on the installation method and machine permission levels - you could prompt the user to install the files by following instructions. Otherwise, your IT department may need to push out an update to those machines.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    04-17-2019
    Location
    Vilnius, Lithuania
    MS-Off Ver
    2016
    Posts
    3

    Re: Excel VBA to include Libraries in Workbook

    IT department remains only solution in this case then, as due to our internal security policies, we are not allowed to install any tools or access required locations in computer...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to restore default VBA libraries in Excel 2013?
    By billyandted2 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-22-2014, 12:21 PM
  2. [SOLVED] Access win7 file libraries using Excel VBA?
    By Cyclops in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2014, 04:47 PM
  3. Macro's in an excel 2007 workbook need to include drop down formating
    By JPayne@nbri in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2013, 04:23 PM
  4. Excel References and Object libraries
    By pdauction in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-26-2013, 07:05 AM
  5. Excel not picking libraries from where it is instructed to pick from
    By sameershr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-28-2012, 08:31 AM
  6. Cannot open Excel, message given is about VBA libraries?
    By Kolbie Stuck in forum Excel General
    Replies: 1
    Last Post: 10-27-2005, 02:05 PM
  7. How to identify missing libraries in Excel (Office-XP) using VBA
    By Helge V. Larsen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2005, 10:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1