Rename excel files in a folder

[ikantimahanti]

I started a new job in Cognos reporting. We scheduled to run reports n save(in Excel format) in a particular folder. But the reports are saving with a unique system generated numbers. I need to save the Excel file names with a filename derived from cell A1.

Please help with a solutions, any help would be greatly appreciated.

Thanks,
Isaac

 

[ikantimahanti]

Please send me the script that renames all the excel files with A1 Cell on Sheet1 in a folder ....

Note:Sheet1 may have different names

 

[VoG]

Almost certainly but that is not my area of expertise.

It is strictly against the forum rules to repost the same question but as your request is now somewhat different I suggest that you start a new thread.

Sorry for wasting your time.

 

[ikantimahanti]

not a problem buddy, thanks for your time. i will post a new thread now