missing library
Posted by Tony on August 20, 2001 5:18 PM
I have created a program which uses a button to save the file as a number. This number is in cell B2. The number the increases by 1. The program works well on my comuter at home but when I try to use it at work it produces a 'missing library or procedure? error. How do I fix this?
Posted by Tony on August 20, 2001 6:08 PM
the line concerned is
Public Sub SaveAsB1()
ThisFile = Range("B2").Value
ChDir "C:\My Documents\Quotes"
ActiveWorkbook.SaveAs FileName:=ThisFile
Posted by Eric on August 21, 2001 6:08 AM
Just a guess
If your office machine is NT/2000, then the \MyDocuments folder is not in C:
It's in your login account (/Files and Settings -check under your login ID- in Win2K and /Winnt/Profiles -check under your login ID- in NT). Maybe you could make a new directory in C: and reference that in the macro to see if it fixes your problem.
Posted by Ivan F Moala on August 21, 2001 8:48 PM
In the VBA Editor
ALT F11
Click on Tools | References
You will see a listing of the current files references.
Check to see that there are NO missing references here.
If there is you will see below a file dir.
Click on browse and rereference the missing file here.
Ivan
