Using a macro to copy files to local hard drive

[chippyles]

How can I set up a macro to copy files from a network drive to a local folder on their hard drive? I would like to do this without seeing the DOS window (cmd).

 

[PWise]

function fcopy (s,d)
FileCopy s, d
end function

macro runcode fcopy source, destination

 

[chippyles]

I am getting an erro that says, "expression you entered has a function name that 'Data Collection' can't find."

 

[chippyles]

where would i place this function because I can not use it properly.

 

[PWise]

make a module with this function
public Function fcopy()
FileCopy InputBox("enter name of source file"), InputBox("enter destionation of source file")
End Function

create a macro on the action line enter run code
in the function name line enter fcopy

when you run the function it will prompt you for the source file name and the destentinon name