Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compile error: Can't find project or library | New Users to Excel | |||
Compile error: Can't find project or library | Excel Programming | |||
Compile error: Can't find project or library | Excel Programming | |||
Compile error: Can't find project or library | Excel Programming | |||
Compile error: Can't find project or library | Excel Programming |