hi goto
http://www.dailydoseofexcel.com/archives/2006/10/29/saveas-in-excel-2007/ hope this will help you Regards Yngve On 11 Jan, 07:00, grlinks-karthik <grli...@gmail.com> wrote: > I need to copy the sheets from one work book to another work book, can any > one help is urgent > > I have to work book name called “destination.xls” and “source.xls”, > destination.xls work book contain two sheets name called “sheet1” and > “sheet2” ( source.xls workbook contain only one sheet name called “IT” , > these two sheets copied and move to Source.xls workbook next to “IT” > sheet, I need the Macro for it > > But some conditions are there. > > 1. Macro should be Run while source.xls work book open ( destination > should not be open) > > 2. Both work books will be in different Locations > > 3. Moved sheets should be hidden (only programmer can see the sheets) > > 4. Moved sheets name should be always “sheet1” and “sheet2” > > 5. Suppose “sheet1” and “sheet2” already exists in source.xls work > book then exists sheets should be deleted and moved sheets > (destination.xls work book sheets) should be replaced > Friends your people can able to understand the above, please help me it very > urgent > regards > Grlinks-karthik > > Source.xls > 58KVisLast ned > > destination.xls > 21KVisLast ned
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
