Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
I wrote a VBA script which is working fine on my computer (the one that it was written on) running XP and Office 2000. Transferring the workbook to any other machine it stops with "Can't find project or library" error message in a module called from the Workbook_Open module. I can't see any difference between the computers. What is wrong on or what is missing from the other computers? Thanks, Stefi |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Stefi,
Check all libraries that are being referenced from Tools, References in the first computer and ensure they are all checked on the second computer. -- http://HelpExcel.com 1-888-INGENIO 1-888-464-3646 x0197758 "Stefi" wrote: Hi All, I wrote a VBA script which is working fine on my computer (the one that it was written on) running XP and Office 2000. Transferring the workbook to any other machine it stops with "Can't find project or library" error message in a module called from the Workbook_Open module. I can't see any difference between the computers. What is wrong on or what is missing from the other computers? Thanks, Stefi |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
in the IDE, look in Tools/References an dsee if any DDLs that you use are
marked 'MISSING' "Stefi" wrote: Hi All, I wrote a VBA script which is working fine on my computer (the one that it was written on) running XP and Office 2000. Transferring the workbook to any other machine it stops with "Can't find project or library" error message in a module called from the Workbook_Open module. I can't see any difference between the computers. What is wrong on or what is missing from the other computers? Thanks, Stefi |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
That was the problem, many thanks to both of you!
Regards, Stefi €˛Patrick Molloy€¯ ezt Ć*rta: in the IDE, look in Tools/References an dsee if any DDLs that you use are marked 'MISSING' "Stefi" wrote: Hi All, I wrote a VBA script which is working fine on my computer (the one that it was written on) running XP and Office 2000. Transferring the workbook to any other machine it stops with "Can't find project or library" error message in a module called from the Workbook_Open module. I can't see any difference between the computers. What is wrong on or what is missing from the other computers? Thanks, Stefi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excell error "Can't find Project or Library" Project VBAProject | Excel Worksheet Functions | |||
indirect.ext - "can't find project or library" error | Excel Worksheet Functions | |||
Trapping the "Can't find project or library error" | Excel Programming | |||
Trim: Excel 97 gives error "Can't find project or library" | Excel Programming | |||
macro error "can't find project or library" | Excel Programming |