copy file from "The path chosen by the user" to Specified folder by programmer

[asipoolika]

copy file from "The path chosen by the user" to Specified folder by programmer

Hi Guys

Is there a way of copy and pasting a file such as a Word document, pdf, image, or Database, from "The path chosen by the user" to "Specified folder by programmer" on your hard drive using Microsoft Access.

Thanks for any help that you may offer

 

[MarkK]

What are these?

"The path chosen by the user" to "Specified folder by programmer"

Is there a way to copy a file in VBA? Yes. Or are you asking for a way to select a file? The is a VBA command called FileCopy.

 

[asipoolika]

Re: copy file from "The path chosen by the user" to Specified folder by programmer

i am asking for a way to select a file by user.. and then automatic paste file to Specified folder by programmer.. Please put a sample code to help me .. thanks

 

[vbaInet]

Re: copy file from "The path chosen by the user" to Specified folder by programmer

To select a path you can use FileDialog:
https://msdn.microsoft.com/en-us/library/office/ff196794.aspx

To copy the folder across you can use what MikeK mentioned FileCopy() or FileSystemObject:
http://www.rondebruin.nl/win/s3/win026.htm

Have a look into those.