hi all,
I wanted to create a macro , to copy the entire work book and rename it and keep it into a folder
The present name of the work book is "weekly solutions", and i wanted to keep this work book in D: folder name is "ALL WEEKLY" and the new workbook name should be as in the cell C3 of work sheet "Indian banks". hope somebody will help in this regard.
thanks in advance
by
nowfal
Do you just need to re-save the workbook with a different name? Or any other actions to be performed?
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]
yes sir,i wanted to save the book as well as to remove all the links, which the original file is having. And also to save with a different name, i.e. place in the cell C3 of the one of the work sheet. I will assign this macro inside the original workbook.
thanks and regards
nowfal
Try this code
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks