Rename and save file

[danvzla]

Hi

Is there a way of taking an excel file, change the name and save on an specific folder with VBA. Would be great if I can drag and drop the file to a window in the form and then do all the rename and save process.

Thanks

Daniel

 

[JeremyNYC]

check the help files for "name" and "filecopy". Those will get the job done for you in the code.

The drag and drop bit will be a lot more work to set up, but it can be done (I think). I haven't done this kind of thing, but you should be able to do it with a couple of tree controls. But, I do think it will be a bunch of work. On the other hand, you might be able to download a sample database from somewhere with this all set up for you.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[danvlas]

Jeremy, I see what you meant

Daniel, I have responded to the duplicate of this question without noticing you posted it twice.

That's why you shouldn't post more than once...




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html