topic Re: Copy file with VBA in VBA Forum

Copy file with VBA

Anonymous — Mon, 23 Jun 2008 05:28:48 GMT

hi,
How can i copy File from one directory to another with VBA.
If someone knows to let me write the code.

Thanks.

Re: Copy file with VBA

Anonymous — Mon, 23 Jun 2008 05:51:25 GMT

Hi Milko,

FileCopy SourceFileSpec TargetFileSpec

Regards

Laurie

MilkoNunev wrote:
> hi,
> How can i copy File from one directory to another with VBA.
> If someone knows to let me write the code.
>
> Thanks.

Re: Copy file with VBA

Anonymous — Mon, 23 Jun 2008 06:11:43 GMT

have in mind something

Dim fSys As New FileSystemObject
Private Sub Form_Load()
With fSys
.CopyFile "E:\picture.jpg", "D:\", True
End With
End Sub

but i have a problem with this code

Re: Copy file with VBA

Anonymous — Mon, 23 Jun 2008 06:30:43 GMT

Hi Laurie,
Can you write me some sample code. I write my programms to Visual Basic for AutoCad.

Thanks.

Re: Copy file with VBA

Anonymous — Mon, 23 Jun 2008 11:59:00 GMT

FileCopy SourceFileSpec TargetFileSpecMilkoNunev

e.g.

FileCopy "C:\Temp\I could have read the help file.txt" _

"C:\Temp\But I couldn't be bothered.txt"

Regards

Laurie

wrote:
> Hi Laurie,
> Can you write me some sample code. I write my programms to Visual Basic for AutoCad.
>
> Thanks.

Re: Copy file with VBA

Anonymous — Mon, 23 Jun 2008 17:56:53 GMT

I guess you don't set reference to
Microsoft Scripting Runtime, do you?

~'J'~

Re: Copy file with VBA

Anonymous — Mon, 23 Jun 2008 21:49:22 GMT

that's ignorant