Hi
I think using save as it can do, I crate a macro given below but its
not working well
Sub copyfile( )
Dim Filename As String
ActiveWorkbook.SaveAs Filename:=Filename = InputBox("File name, please?")end sub it save the file in the name of False.xls always.Pls let me know what is the trouble. Regards Rajesh Kainikkara On 12/18/10, [email protected] <[email protected]> wrote: > Yes, > > Send your data sheet with ur requirements. > > Sent on my BlackBerry® from Vodafone > > -----Original Message----- > From: Rajesh K R <[email protected]> > Sender: [email protected] > Date: Sat, 18 Dec 2010 17:24:19 > To: excel-macros<[email protected]> > Reply-To: [email protected] > Subject: $$Excel-Macros$$ Create a new work book and copy the data from the > excising work book > > Hi experts > > Is it possible to create a new work book and copy the required to it > from the excising file using a macro. > > Regards > Rajesh Kainikkara > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 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 [email protected] > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 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 [email protected] > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 [email protected] <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
