View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Edmund Edmund is offline
external usenet poster
 
Posts: 62
Default VBA unable to recognize code after reinstallation of MS Office

After reformatting my harddisk & full re-installation of Microsoft Office
2003,my VBA can no longer execute the below codes. I get error message
"Compile error: Can't find project or library".

Now, VBA doesn't seem to recognize "Trim" & "Format" as in below codes.
What's missing from my installation?

Trim(MyString)
Msg = "Job done in : " & Format(endtimer - starttimer, "0.0") & " secs"

Thanks in advance.

--
Edmund
(Using Excel 2003)