Dear All,
I need a macro that rename excel file *.xls (any name not specific) to abc.xls in the folder then move to other folder and override the existing abc.xls
Your help would be appreciated
Thanks
Farrukh
Dear All,
I need a macro that rename excel file *.xls (any name not specific) to abc.xls in the folder then move to other folder and override the existing abc.xls
Your help would be appreciated
Thanks
Farrukh
Why not just re-save it in the other folder?
Use the macro recorder to get the save code.
Start the macro recorder, press F12 to saveas.
Actually the scenario is that a excel file has a link with other excel file .This main excel file is come from field to head office with different names some times xyz.xls some times 123.xls .We have a automated process that the linked file always get the data from named MASTER.XLS (FROM FIELD ) so that person in the head office always change the name xyz.xls or 123.xls to MASTER.xls . Some times a person forget to change the name in the specific folder then we have a great loss in live data.....
help plz
thanks
farrukh
New thread started
http://www.excelforum.com/excel-prog...-template.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks