2k-XP HELP - "Format"(Now) - can't find project

E

Ed

IT just changed me from Office / Windows 2000 to Office / Windows XP. I got
my NOrmal.dot moved over okay. I'm trying to run a macro that has worked
well, but now errors on "Format" in the line:
strFldr = "C:\Documents and Settings\USER\Folder " & Format(Now, "dd mmm
yyyy")
I get a message box saying "Compiler error: can't find project or library."
I checked my references - none say MISSING (except the Google search
add-in).

Also, when I open a new document and hit Alt+F11, it tells me "Can't open
macro storage". I click okay - and it opens the VBE! Can anyone help?

Ed
 
E

Ed

*sigh* Never mind - I just found it. WIth a new version of Office, I needed
to set a reference to a newer version of VBA. Check the magic box, and
everything works. whoopie

Ed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding Date in an overseas format 21
[need help] table with substitutions find & change 3
O2K vbe error message "Can't find project or library"? 3
"can't find project or library" error has started appearing in VBArunning on Word 2003 5
Can't use the userforms and Macros within a Project 1
Compile error hidden module 4
Can't find normal.dot in Word 2003 5
unlocked VBA project on XP becomes locked on Macintosh 0

Top