Can I move files From Drive to drive using VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to move and rename files automatically whenever someone finishes
with the spreadsheet. The idea is that they can only run it once and the data
files are moved until the next month, and ready for the next department to
use them.
 
Sure you can but be careful because inevitably someone will mess things up
and indicate that they are finised when they are not. You will want to
validate completeness before you move the files. Even then files are going to
be moved prematurely (you can always trust end users to foul up the
infallible). That having been said look up "file system objects" as that is
probably what you are looking for based on your question. The microsoft site
is a pretty good reference on this topic.

HTH
 
Take a look at Name in VBA's help.

Also FileCopy and Kill may be useful one day.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to migrate OneDrive to Google Drive 2
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Can you write VBA to export objects 1
Windows 7 Task Scheduler to Move(Cut) files from one drive to another within Same PC 1
Best Gmail Backup Tool to use in 2025? 3
How can I migrate MBOX to PST? 2
Using VBA to move system files 2
Remove File import using VBA 1

Back
Top