FileCopy

[thescottsman92]

Hi

I have a problem in the copyfile function. It says "CompileError - Expected =" and I am not sure if im even setting this correctly. This is my cde:

Dim fso As Object
Set fso = VBA.CreateObject(filesystemobject)
fso.copyfile(me.txtPath,me.txtarchivepath & me.txtnewfile)

I think the problem is the "filesystemobject bit in the code

can anyone please help me

thanks very much

[June7]

Don't need FileSystemObject to copy a file. VBA has an intrinsic function for that.

Try:
FileCopy me.txtPath, me.txtarchivepath & me.txtnewfile