K
Kindergarten Teacher
I am receiving "vba filecopy 75 path/file access error" when I try to use any
kind of a copy command inside of vba for Access 2002. The Visual Basic
version is 6.3
Here is a simplified version of the code.
MkDir "C:\To"
filepicked = "C:\From\test.txt"
directorypicked = "C:\To"
VBA.FileCopy filepicked, directorypicked
I have no problem creating the new directory using this code.
The file exists and the path is correct.
After each attempt the "To" directory was removed so it could be successfully
recreated.
There doesn't seem to be permission problems. I can run a copy command at a
DOS prompt and successfully copy the file to the new directory.
I have the path variables declared as strings - I've also tried as variants
When run in my application the code does create the "To" directory but gives
the error 75 message when it tries to copy the file to the new directory.
kind of a copy command inside of vba for Access 2002. The Visual Basic
version is 6.3
Here is a simplified version of the code.
MkDir "C:\To"
filepicked = "C:\From\test.txt"
directorypicked = "C:\To"
VBA.FileCopy filepicked, directorypicked
I have no problem creating the new directory using this code.
The file exists and the path is correct.
After each attempt the "To" directory was removed so it could be successfully
recreated.
There doesn't seem to be permission problems. I can run a copy command at a
DOS prompt and successfully copy the file to the new directory.
I have the path variables declared as strings - I've also tried as variants
When run in my application the code does create the "To" directory but gives
the error 75 message when it tries to copy the file to the new directory.