FrustratedTonya
Last Activity: Aug 21 '18, 08:53 PM
Joined: Aug 21 '18
Location:
-
Ahhh... so I'm not going to be able to use the Filecopy command here and will have to open and save as instead. Thank you! -
FileCopy command - run time error 52 in Excel VBA
I'm trying to copy a file from a SharePoint location to a network folder. I can get the file to Open and save as but all I really need to do is copy it.
Code looks like this:
...Code:strPathSrc = "SharepointLoc/My%20Reports/" strPathTgt = "P:\MyReports\" strFileSrc = "This%20File.xlsx" strFileTgt = "This File.xlsx" Filecopy strPathSrc & strFileSrc,
No activity results to display
Leave a comment: