FileSystemObject.CopyFile

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

I am trying to use FileSystemObject.CopyFile in my code but the I am getting
a 'Variable not found' error on FileSystemObject. What am I doing wrong?

Thanks

Regards
 
John said:
Hi

I am trying to use FileSystemObject.CopyFile in my code but the I am
getting a 'Variable not found' error on FileSystemObject. What am I
doing wrong?
Click to expand...

You have to create an object of type "FileSystemObject", and call the
method from that object. Did you do that? It would help if you posted
your code, but you should have something like:

Dim fso As Object

Set fso = CreateObject("Scripting.FileSystemObject")

fso.CopyFile ...

Note, though, that if all you do is copy a single file, there's a
built-in VBA FileCopy statement that will be more efficient for that
purpose. The syntax is:

FileCopy <source>, <destination>

You'll find more about it in the online help, if you look from the VB
Editor.
 
Check to see that you have a Reference for the Microsoft Scripting Runtime.

Open your module, click Tools, References and review the list. Add it to
the list if it is not checked.

Larry
 
Back
Top