ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Compile error - Can't find project library ???? (https://www.excelbanter.com/excel-programming/400292-compile-error-cant-find-project-library.html)

[email protected]

Compile error - Can't find project library ????
 
I have a macro that works beautifully except for one major issue. It
works perfectly when I run it but when anybody else tries to run it,
it fails with a Compile Error.

I think the relevant part of the code is below. Basically, Cell D3
contains a number 1-30 based on user input. When the macro runs, it
takes the data from cell D3 and uses it to select one of 30 pictures
to copy and paste into another workbook. I have been running it for
several weeks but up until now, I have been the only person to run it.

Now I need to release it for other people to run and wouldn't you
know, the first person has a failure.

When the macro runs the following error appears in a pop-up window.

Compile Error
Can't find project library
with an OK and a Help button (the help button isn't helping)

The terms picSource are then highlighted in yellow by the error.


With Workbooks("Report.xls").Sheets("Reference")
If .Range("D3").Value = "1" Then
Set picSource = .Pictures("Picture 1")
With Workbooks("NEW-TACS-PLAN-OT.xls")

What am I doind wrong or what do I need to do? I think this has to do
with building a project or object library. If that is the case, how
do I build such a libray. All 30 of the pictures or located in the
workbook already.



All times are GMT +1. The time now is 04:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com