MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Copy file from source C:\a.txt to D:\

  Asked By: Lloyd    Date: Aug 23    Category: MS Office    Views: 2393

I need to copy few file from one place to another in VBA, can anybody
hel me on this.



1 Answer Found

Answer #1    Answered By: Eileen Carr     Answered On: Aug 23

In VBA, you can use the FileCopy function.

You can also use the FileSystemObject of the Windows Scripting Runtime
library (scrrun.dll). This object is extremely useful and flexible but
requires a teeny bit more work than just using FileCopy. Google has lots of
info on the FileSystemObject.

Didn't find what you were looking for? Find more on Copy file from source C:\a.txt to D:\ Or get search suggestion and latest updates.