Jump to content
xisto Community
sanilmathews

To Rename Files

Recommended Posts

Hi,I am trying to write a VBA code to rename word document by referring the values in the column of an excel sheet For examble aaa, bbb, ccc, ddd in cell A1, cell A2, cell A3, cell A4 etc..... The files to be renamed and the excel file will be in the same folder The information in the excel sheet varies as there are instances where I will have more names in column A.How much ever names are there in column A they should be referred to rename the files in the folderI would really appreciate if some one would give me a better solution to my problem ASAP!!

Share this post


Link to post
Share on other sites

On which operating system does this thing have to work ? Il it on a local windows PC ?And is the excel format a must? Or can it be comma-separated records in a "csv" file ?

Share this post


Link to post
Share on other sites

Does it have to be in VBA ?
I once worked with a tool called Pentaho Kettle/Spoon. It's an open source ETL tool which let you build a complete chain of actions using blocks (it's like programming, but with blocks).
Now, don't be mistaken, it sounds easy, but there are some tricks you have to know in order to get it working (eg, if you want to group data, you have to apply a sort on the columns you'll use for sorting).


I'm sure it can read excel files, I'm 65% sure you can rename files with it, so it sounds like a good solution to your problem. However, I don't realy see the use of renaming word files based on an Excel sheet rather than giving it a name based on the file its content.

//edit: btw, Pentaho is writen in Java so it'll run on most operating systems ;)

Edited by wutske (see edit history)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.