Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Can't find Project or Libr." when using Form in Macro
I had the following macro working in Excel 2000, when I used an Excel XP machine to save the file now I get the following error when running on back Excel 2000. "Compile Error: Can't find Project or Library" The Macro Breaks at the following Code that uses a "Form" to graphically display progress. Sub UpdateProgress(pct) With Mercury_Reporting_Package.ProgressUpdate_Form .FrameProgress.Caption = Format(pct, "0%") .LabelProgress.Width = pct * (.FrameProgress.Width - 10) .Repaint End With End Sub Thank you in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Can't find Project or Libr." when using Form in Macro
In Tools | References, check if you have any items marked as "MISSING"
-- Regards Juan Pablo González "Cae" wrote in message ... I had the following macro working in Excel 2000, when I used an Excel XP machine to save the file now I get the following error when running on back Excel 2000. "Compile Error: Can't find Project or Library" The Macro Breaks at the following Code that uses a "Form" to graphically display progress. Sub UpdateProgress(pct) With Mercury_Reporting_Package.ProgressUpdate_Form .FrameProgress.Caption = Format(pct, "0%") .LabelProgress.Width = pct * (.FrameProgress.Width - 10) .Repaint End With End Sub Thank you in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
In Tools | References Missing
Thanks there is a Missing Reference:
I dont know how to deal with/correct it? The missing reference is "Microsoft ActiveX Data Objects (Multi-Demensional) 2.7 Library" In Tools | References Missing -----Original Message----- In Tools | References, check if you have any items marked as "MISSING" -- Regards Juan Pablo González "Cae" wrote in message ... I had the following macro working in Excel 2000, when I used an Excel XP machine to save the file now I get the following error when running on back Excel 2000. "Compile Error: Can't find Project or Library" The Macro Breaks at the following Code that uses a "Form" to graphically display progress. Sub UpdateProgress(pct) With Mercury_Reporting_Package.ProgressUpdate_Form .FrameProgress.Caption = Format(pct, "0%") .LabelProgress.Width = pct * (.FrameProgress.Width - 10) .Repaint End With End Sub Thank you in advance . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
In Tools | References Missing
Do you know if you're using ADO for anything ? Database connections ? sql
queries ? if not, then try unchecking that reference and run the macro(s) again to see if the run ok. -- Regards Juan Pablo González "CAE" wrote in message ... Thanks there is a Missing Reference: I dont know how to deal with/correct it? The missing reference is "Microsoft ActiveX Data Objects (Multi-Demensional) 2.7 Library" In Tools | References Missing -----Original Message----- In Tools | References, check if you have any items marked as "MISSING" -- Regards Juan Pablo González "Cae" wrote in message ... I had the following macro working in Excel 2000, when I used an Excel XP machine to save the file now I get the following error when running on back Excel 2000. "Compile Error: Can't find Project or Library" The Macro Breaks at the following Code that uses a "Form" to graphically display progress. Sub UpdateProgress(pct) With Mercury_Reporting_Package.ProgressUpdate_Form .FrameProgress.Caption = Format(pct, "0%") .LabelProgress.Width = pct * (.FrameProgress.Width - 10) .Repaint End With End Sub Thank you in advance . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Can't find Project or Libr." when using Form in Macro
Part of the problem is that when you run the file on the XP machine, VBA may
automatically update the library reference from 2000 (Excel 9.0) to XP (Excel 10.0). When the file is saved, it may be saved to the Excel 10.0 library, and that won't be found on your 2000 machine. If you're going to be going back and forth from 2000 to XP on a regular basis, you probably want to try late binding - it causes the code to look for the application object and set a reference, rather than having the object reference set at the beginning. (I think I explained that right.) Ed "Cae" wrote in message ... I had the following macro working in Excel 2000, when I used an Excel XP machine to save the file now I get the following error when running on back Excel 2000. "Compile Error: Can't find Project or Library" The Macro Breaks at the following Code that uses a "Form" to graphically display progress. Sub UpdateProgress(pct) With Mercury_Reporting_Package.ProgressUpdate_Form .FrameProgress.Caption = Format(pct, "0%") .LabelProgress.Width = pct * (.FrameProgress.Width - 10) .Repaint End With End Sub Thank you in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display "macro-free workbooks - VB project message" on closing Exc | Excel Discussion (Misc queries) | |||
"Can't find project or library" after emailing files. | Excel Discussion (Misc queries) | |||
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 | |||
macro error "can't find project or library" | Excel Programming |