Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Missing Project or Library
My codes used to work on old pc, but crashing on new PC
Win 2k excel 2002 sp3 Code errors on these functions Date Year Format I have references to Funcres.xla, and atpvbaen.xla But my error does not indicate which library I need to point to. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Missing Project or Library
after the problem, in the vbe go to Tools=References and see if any
references are marked as MISSING. If so, unselect those shown as MISSING. If you are using them, then use the browse button to fine them and fix the reference. -- Regards, Tom Ogilvy "Dave" wrote in message ... My codes used to work on old pc, but crashing on new PC Win 2k excel 2002 sp3 Code errors on these functions Date Year Format I have references to Funcres.xla, and atpvbaen.xla But my error does not indicate which library I need to point to. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Missing Project or Library
Thnaks Tom, but it is a goofy problem, there are no
references that show as missing. the sequence of problem as as follows code example dim iyear as year iyear=year(date) First time I run the code I get compile error missing project or library on the word "date" I then debug and compile and it gets past this. I save (compiled file), close it and then re-open and get the compile error again. The file is my personal workbook sitting in my xlstart folder but I can't think of any reason why that would be an issue. Another example is below, same crash on 1st run, but fine after a forced compile Sub fixme() Dim x As String x = Format(Now, "ddd-mmm-yyyy") MsgBox "example time " & x End Sub Dave -----Original Message----- after the problem, in the vbe go to Tools=References and see if any references are marked as MISSING. If so, unselect those shown as MISSING. If you are using them, then use the browse button to fine them and fix the reference. -- Regards, Tom Ogilvy "Dave" wrote in message ... My codes used to work on old pc, but crashing on new PC Win 2k excel 2002 sp3 Code errors on these functions Date Year Format I have references to Funcres.xla, and atpvbaen.xla But my error does not indicate which library I need to point to. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Missing Project or Library
You have to make sure the workbook with the problem is the active project
(not active workbook) when you go to tools = references. you do this by selecting it in the project explorer. -- Regards, Tom Ogilvy "Dave" wrote in message ... Thnaks Tom, but it is a goofy problem, there are no references that show as missing. the sequence of problem as as follows code example dim iyear as year iyear=year(date) First time I run the code I get compile error missing project or library on the word "date" I then debug and compile and it gets past this. I save (compiled file), close it and then re-open and get the compile error again. The file is my personal workbook sitting in my xlstart folder but I can't think of any reason why that would be an issue. Another example is below, same crash on 1st run, but fine after a forced compile Sub fixme() Dim x As String x = Format(Now, "ddd-mmm-yyyy") MsgBox "example time " & x End Sub Dave -----Original Message----- after the problem, in the vbe go to Tools=References and see if any references are marked as MISSING. If so, unselect those shown as MISSING. If you are using them, then use the browse button to fine them and fix the reference. -- Regards, Tom Ogilvy "Dave" wrote in message ... My codes used to work on old pc, but crashing on new PC Win 2k excel 2002 sp3 Code errors on these functions Date Year Format I have references to Funcres.xla, and atpvbaen.xla But my error does not indicate which library I need to point to. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell error "Can't find Project or Library" Project VBAProject | Excel Worksheet Functions | |||
cant find project or library | New Users to Excel | |||
Project or library | New Users to Excel | |||
Missing library when running 98 project on 2003 | Excel Discussion (Misc queries) | |||
Can't find project or library | Excel Discussion (Misc queries) |