Code for remanimg files from a field in a table

[GoKats78]

We are changing Document Control system software. Our current system saves the documents with a unique file number; it also strips the file properties. There is a table on the SQL server that lists the unique number, and file type (e.g. Word Doc, Excel). What I need to do is have some code grab the file, rename it based on the doc number and document title found in the table and reassign the file properties.
How difficult of code of this type, and what, in general, would it look like?

As I get more details I will add them so I can get the help I really need!



Well, at least the help with the code...

 

[Macropod]

Hi GoKats78,

The code to rename a series of files isn't all that difficult - you could even do that much with a DOS batch file. But what do you mean by "reassign the file properties"?

 

[GoKats78]

The software removes the file extension and any other files properties (all those items that are present when you right click and choose "properties")

 

[Macropod]

Hi GoKats78,

OK, what happens if you make a copy of the file and load it onto another system:
Do you have to manually add the extension back on? And once you've done that (assuming that's what's required, don't the other properties re-appear? If not, where are they held so they can be re-assigned?