Is there a macro that moves files?

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?
 
S

Steve Schapel

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"
 

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

Making a macro only work on certain files 2
Setting column width in a table with a macro is not working 0
Macro to copy table of contents to a new doc 0
Problem with SET & REF function 0
Embedded Excel into Word with Tables 0
Open my default template when right click, select New MS Word doc within a folder 0
Template location changes from user to user 0
VBA concatenate ranges into a new document 0

Top