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

Hallo,

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

Regards
Norbert


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


Ivan

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


Hallo Ivan,

thank you very much, think this will help.

Norbert