Is there a macro that moves files?

  • Thread starter Thread starter Anthony
  • Start date Start date
A

Anthony

I am building an Access database that has a table of documents with the
critical field being a hyperlink to that document.

I would like to be able to update a record (specifically a Word document) by
moving that Word document on the other end of the hyperlink from one folder,
called "Active", to another folder called "Obsolete".

Can I create a macro that does this?
 
Anthony,

No, this is not possible with a macro.

However, you can do this using a VBA procedure. The syntax is:

Name "C:\YourFolder1\YourFile1.doc" As "C:\YourFolder2\YourFile2.doc"
 
Back
Top