| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error on "Right", missing Library
Hi There,
I am running a piece of code but I bug on: "Right" ExportFormat = UCase(Right(FileSaveName, 3)) Compile Error: Cant find Project or Library Which reference should I need to set??? Sige PS I am working in XL97 ... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compile error on "Right", missing Library
Hi Sige,
In the VBE, with the problematic workbook's project selected, go to: Tools | References and look for any entries marked 'Missing'. Uncheck these if they are not needed or use the browse button to locate the reference. --- Regards, Norman "Sige" wrote in message ups.com... Hi There, I am running a piece of code but I bug on: "Right" ExportFormat = UCase(Right(FileSaveName, 3)) Compile Error: Cant find Project or Library Which reference should I need to set??? Sige PS I am working in XL97 ... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compile error on "Right", missing Library
Hi Norman,
Wished I could ... but I cannot uncheck it as it is in use .... I can browse yes ...but to which reference? Sige |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compile error on "Right", missing Library
Hi Sige,
Windows | Start | Search. What is the missing reference? --- Regards, Norman "Sige" wrote in message oups.com... Hi Norman, Wished I could ... but I cannot uncheck it as it is in use .... I can browse yes ...but to which reference? Sige |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compile error on "Right", missing Library
Missing Location:
C:\Sige\Excel\Test Language: Standard I did not set any reference ... ?! Is "Right" not a standdard VBA-function? (or part of ATPVBAEN.xla? which is checked!) Sige |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compile error on "Right", missing Library
Hi Sige,
it seems, if a reference is missing or something else is wrong with a library, the compiler simply stops at the first keyword it comes across. Is has nothing to do with right. Helmut Weber |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compile error on "Right", missing Library
Hi Sige,
Has the missing reference file been moved or renamed? If so, browse to the new location / name and reset the reference. --- Regards, Norman "Sige" wrote in message oups.com... Missing Location: C:\Sige\Excel\Test Language: Standard I did not set any reference ... ?! Is "Right" not a standdard VBA-function? (or part of ATPVBAEN.xla? which is checked!) Sige |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| indirect.ext - "can't find project or library" error | Excel Worksheet Functions | |||
| "Compile Error Can't find project or library." | Excel Programming | |||
| Trapping the "Can't find project or library error" | Excel Programming | |||
| Trim: Excel 97 gives error "Can't find project or library" | Excel Programming | |||
| Getting "compile error" "method or data member not found" on reinstall | Excel Programming | |||
Hybrid Mode
