Thanks Ranjan, thanks a lot.
On Tue, May 31, 2011 at 10:11 AM, Rajan_Verma <rajanverma1...@gmail.com>wrote:
> Hi,
>
> Paste this Code For Save Button.
>
>
>
>
>
> Private Sub CommandButton1_Click()
>
> On Error Resume Next
>
> Dim wb As Workbook
>
> Dim acwb As Workbook
>
> Set acwb = ActiveWorkbook
>
> Set wb = Workbooks("Book2")
>
> If wb Is Nothing Then
>
> Set wb = Workbooks.Open(Filename:="D:\Book2.xls")
>
> End If
>
> acwb.Sheets(1).Range("C1:D1").Copy
> wb.Sheets("Sheet1").Range("A30").End(xlUp).Offset(1, 0)
>
> wb.Activate
>
> Application.CutCopyMode = False
>
> acwb.Activate
>
> End Sub
>
>
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* Monday, May 30, 2011 3:12 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Requesting for a small help in vba coding....
>
>
>
> Hi All,
>
>
>
> I need a small help in vba coding, I have attached two files; in save.xls
> it has a command button named "save", when I press this button it will copy
> data from d1:d1 and paste in the file Book2.xls in the range a1:b1 then
> a2:b2 onward. But somehow this macro is not working properly. It is working
> when I am saving the data in the same excel file i.e. save.xls, but it is
> not saving the data in the different excel file i.e. Book2.xls. Please vba
> gurus I need your help to solve this problem.
>
>
>
> Thanks in advance.
>
>
> --
> Indrajit
>
> Disclaimer:
> This electronic message and any files transmitted with it are confidential
> and intended solely for the use of the individual or entity to whom they are
> addressed. If you are not the intended recipient you are hereby notified
> that any disclosure, copying, distribution or taking any action in reliance
> on the contents of this information is strictly prohibited and may be
> unlawful.
>
>
>
> --
>
> ----------------------------------------------------------------------------------
> 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 excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> ----------------------------------------------------------------------------------
> 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 excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
----------------------------------------------------------------------------------
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 excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
