save folder to another directory

[focosi]

I would like the VBA code to save a list of files from a folder to another directory on removable drive using the Save As file dialog. I have found this http://access.mvps.org/access/api/api0001.htm but i cannot manage where and how to list the files I want to copy.


Also, is there any chance to select the default directory where the save as file dialog starts at ?

[RuralGuy]

Did you notice this line:
Optional ByVal InitialDir As Variant, _

[focosi]

Thanks for the hint. But where should I write the list of files to be copied ? Or am I forced to copy files one by one ???

[RuralGuy]

Once you have the Destination you can just use a Loop to copy all of the files you want.

[focosi]

ok, but... what is a Loop and how should I use it ??
Could you please post a VBA example ?
Sorry for my ignorance....

[rpeare]

look at using the filesystemobject procedures.

With filesystemobject you can look at all files in a folder copy all or some of the files using wildcards etc to a new destination. If you have a lot of files do you really want to open a 'save as' dialog box for every file or do you just want to do a mass copy?

[focosi]

I would like to do a mass copy.
Any VBA example, please?

[rpeare]

Look at filesystemobject code, it's very easy to deal with and there are TONS of resources available. I don't know your situation so I can't really give you code but here are some resources:

copying an entire folder
http://msdn.microsoft.com/en-us/libr...=vs.85%29.aspx

copying a single file
http://msdn.microsoft.com/en-us/libr...=vs.85%29.aspx

cycling through files in a folder
http://www.4guysfromrolla.com/webtec...ect/faq5.shtml