Copy File without opening
Excel Experts,
Without opening the file, I want to copy a text file in one directory to another directory and save it with a different name. Specifically, I have a file C:\ACDocs\First\pa.txt" and without opening, I want to save it as C:\ACDocs\Second\portfolio.txt" I tried the below code but I an "Object Required" errror on the SaveCopyAs line. Sub Macro1() FN1 = "C:\ACDocs\First\pa.txt" FN1.SaveCopyAs "C:\ACDocs\Second\portfolio.txt" End Sub What code would work? Thanks in advance, Alan -- achidsey |
Copy File without opening
Sub Macro1()
FN1 = "C:\ACDocs\First\pa.txt" FileCopy FN1, "C:\ACDocs\Second\portfolio.txt" End Sub -- Regards, Tom Ogilvy "achidsey" (notmorespam) wrote in message ... Excel Experts, Without opening the file, I want to copy a text file in one directory to another directory and save it with a different name. Specifically, I have a file C:\ACDocs\First\pa.txt" and without opening, I want to save it as C:\ACDocs\Second\portfolio.txt" I tried the below code but I an "Object Required" errror on the SaveCopyAs line. Sub Macro1() FN1 = "C:\ACDocs\First\pa.txt" FN1.SaveCopyAs "C:\ACDocs\Second\portfolio.txt" End Sub What code would work? Thanks in advance, Alan -- achidsey |
Copy File without opening
Tom,
Thanks as always. Alan -- achidsey "Tom Ogilvy" wrote: Sub Macro1() FN1 = "C:\ACDocs\First\pa.txt" FileCopy FN1, "C:\ACDocs\Second\portfolio.txt" End Sub -- Regards, Tom Ogilvy "achidsey" (notmorespam) wrote in message ... Excel Experts, Without opening the file, I want to copy a text file in one directory to another directory and save it with a different name. Specifically, I have a file C:\ACDocs\First\pa.txt" and without opening, I want to save it as C:\ACDocs\Second\portfolio.txt" I tried the below code but I an "Object Required" errror on the SaveCopyAs line. Sub Macro1() FN1 = "C:\ACDocs\First\pa.txt" FN1.SaveCopyAs "C:\ACDocs\Second\portfolio.txt" End Sub What code would work? Thanks in advance, Alan -- achidsey |
All times are GMT +1. The time now is 09:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com