Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
All the documentation I have read shows the following code.
FileCopy OriginalFile, CopiedFile Why then is the following code return "Wrong number of arguments or invalid property assignment" ? Sub Test_Copy() FileCopy "I:\out\BMSEP.pdf", "C:\FC_0706\BMSEP.pdf" End Sub Thanks for your help. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Are you sure it is failing with the code you are showing. I got the code
below to work. I copied the code straight from the website just modifying the file names. Try running thecode from files on your c: drive. then changingg to the I: drive. therre may be diffferent permissions on the I: drive or the C: subdirectory that is causing the error. Try two directories that you have full permission to read and writte such as mydocuments. Sub Test_Copy() FileCopy "c:\temp\1391.pdf", "c:\temp\newpdf.pdf" End Sub "Bythsx-Addagio" wrote: All the documentation I have read shows the following code. FileCopy OriginalFile, CopiedFile Why then is the following code return "Wrong number of arguments or invalid property assignment" ? Sub Test_Copy() FileCopy "I:\out\BMSEP.pdf", "C:\FC_0706\BMSEP.pdf" End Sub Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
filecopy Question | Excel Discussion (Misc queries) | |||
filecopy | Excel Programming | |||
FileCopy | Excel Programming | |||
FileCopy | Excel Programming | |||
FileCopy | Excel Programming |