Have you tried a simpler syntax. For example:
Sub TempCopy()
FileCopy "G:\Folder1\MyFile.mdb", "C:\Folder2\MyFile.mdb"
end sub
This works fine on my PC.
Jeff
----- Original Message -----
Trying to copy and overwrite a set of files from a server directory to a local folder.
My.Computer.FileSystem.CopyFile( "G:\ProdData\File1.mdb", "C:\CCW\File1.mdb", FileIO.UIOption.AllDialogs, FileIO.UICancelOption.DoNothing)
I get a compile error, "Expected: ="
What's missing?
Adam
--
Jeffrey Park Jones
Excel, Access, Word, Office Expert
Excel and Access, LLC®
Christopher@ExcelAndAccess.Com
http://ExcelAndAccess.Com
Toll Free 877-392-3539
Direct Line 714-262-6893
919-671-9870
5109 Deer Lake Trail
Wake Forest, NC 27587
jpjones23@centurylink.net
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar