Hi i have attached an excel workbook by name Threshold_Report.xlsx,I need to rename this with value which is present in worksheet2 of E column of 2row.the renamed workbook should look like :52462_Threshold_Report.xlsx.
Please look into the workbook which is attached for better understanding.This should work automatically by a vb script or macro.
path:D:/test/folder/threshold.report
You want the file to be renamed or saved with a different name in a different location?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
File to be renamed will be better or the second option also no problem
The value in worksheet2 of E column will change for each run,the one which is coloured in yellow.
So each time you want the existing file to be saved with a new name?
for first run it genrerates one report with name Threshold_report,this we are renaming to 52462_Threshold_report and next run it generates another report with same name as Threshold_report,here also we are renaming according to the value which is ther in the 2nd worksheet of E2 column.....This process repeats.
Ok, so where will the macro be located? In an independent file?
yes in an independent file ,where we can choose input file path and output
Try this code
Copy the Excel VBA code
Please Login or Register to view this content.
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button
Thanks Arul,actually with above code there is again a manula intervention for selecting the file,so i have altered the above code little:
Moderator's Note: Don't forget to add code tags on your codes.Please Login or Register to view this content.
I am new to VBA programming,I need your help here again...the file is getting saved correctly but there is old file existing Threshold_Report in the folder,can we delete this in the same macro?
Last edited by vlady; 10-18-2012 at 01:54 AM.
I was able to delete the existing excel file also.Thanks arlu.Please mark it has solved:
Please Login or Register to view this content.
Last edited by arlu1201; 10-18-2012 at 04:28 AM.
Vlady pointed this to you in your previous post and i am doing it again -
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks