FileSystemObject.CopyFile

[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

 

[Dirk Goldgar]

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?

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.

 

[Larry Kahm]

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