Murray Brown
asked on
VB.Environ Can't find project or library
Hi. I am getting the following error in the Access VBA code below
"Can't find project or library"
MYDOC_DIR = VBA.Environ("userprofile") & "\my documents"
"Can't find project or library"
MYDOC_DIR = VBA.Environ("userprofile")
Try MYDOC_DIR = Environ("userprofile") & "\my documents"
ASKER
already tried that. Put the VBA on originally and the error went away
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks for the help