MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copy non-excel-file with vba

Posted by N. Davidheimann on January 07, 2000 12:58 PM


how can I copy a lotus-approach-apr-file from folder a to folder b using VBA.


Posted by Ivan Moala on January 08, 2000 3:19 AM

Hi Norbert
Look up online help re:FileCopy
example in your caes;

Sub Testcopy()

Dim SourceFile
Dim DestinationFile

SourceFile = "D:\ATest.Apr" ' Define source file name.
DestinationFile = "D:\Aa\Atest.Apr" ' Define target file name.
FileCopy SourceFile, DestinationFile ' Copy source to target.

End Sub


Posted by N. Davidheimann on January 08, 2000 9:31 AM

Hallo Ivan,

thank you very much, think this will help.