T
Todd Huttenstine
Below is my code. It works on my computer but when I
tried it on another computer I get the error "Runtime
error 70. Permission Denied." and it highlights the last
code (FileCopy FileFrom, FileTo). The code is below.
Dim FileFrom As String
Dim FileTo As String
FileFrom = Worksheets(1).Range("G4").Value
FileTo = Worksheets(1).Range("G5").Value
FileCopy FileFrom, FileTo
The file paths are correct but it wont bperform the copy
to instruction. I tried to mannualy copy and paste and it
works, so why can it not programmatically do it?
Thank you
Todd Huttenstine
tried it on another computer I get the error "Runtime
error 70. Permission Denied." and it highlights the last
code (FileCopy FileFrom, FileTo). The code is below.
Dim FileFrom As String
Dim FileTo As String
FileFrom = Worksheets(1).Range("G4").Value
FileTo = Worksheets(1).Range("G5").Value
FileCopy FileFrom, FileTo
The file paths are correct but it wont bperform the copy
to instruction. I tried to mannualy copy and paste and it
works, so why can it not programmatically do it?
Thank you
Todd Huttenstine