how to copy workbook (book1) to workbook (boook2) with the help of command button

[shivam432]

how to copy workbook (book1) to workbook (boook2) with the help of command button ,BOTH THE FILE ARE LOCATED ON DIFFERENT LOCATION attached a file ie book1 there is one more book2 which is on different location once u hit the command button in book1 the data get automatically copied to book2 , please help new to macro

[alansidman]

Look at this link

http://stackoverflow.com/questions/6...book-using-vba

[Excelnoub]

Please Login or Register  to view this content.

Add this to your Sheets Command Button

Hope this helps

Excel Noub

[shivam432]

i have already tried that , didn't work for me i am using excel 2007, please help other wise my manager gonna kill me..please please

[shivam432]

its giving me an error, on 8th line from starting runtime error-9 subscript out of range, please help

[Excelnoub]

Works perfect with my Excel 2007 I am currently using this code myself.

Could you please provide the location of your book2 and also the sheets tab name?

You also need to change this Set rngSrc = wsSrc.Range("A2:AC" & lastrow) to your needs.

Your workbook (Book1) sais that it should be Set rngSrc = wsSrc.Range("A2:D" & lastrow)

I would need more information.

[shivam432]

now it works i dont know how..but it works..u rock buddy..u r genius..if u dont mind can u please tell me like i want to design it in such a way whenever anyone opens it it will give a welcome screen with the user name thanks in advance

[Excelnoub]

Do you need this in a UserForm?

[Excelnoub]

Just add this to your "ThisWorkbook"

Please Login or Register  to view this content.

[Excelnoub]

If you need it in a UserForm then do the following:

Create a new Userform: Rename it to frmsplash (or whatever)

Create within this userform: Label1, and 1 command button

Here is the code to insert:

Please Login or Register  to view this content.

Have fun,

Excel Noub

[shivam432]

can i directly chat with u like on gmail or some any other messenger, i have lots of other problem too, and onemore thing , i dont want the book to get open once user hits command button book 1 is for user and book 2 is for admin thank u so much u r code guru man

[Excelnoub]

shivam just look at your messages in your inbox...

[alansidman]

Shivam, please read rule #4 http://www.excelforum.com/forum-rule...rum-rules.html

[shivam432]

hello , i added one 2 more column one is project type and other is time stamp i need some thing like whenever user enter data in project type automatically time get capture in new cell which is time stamp, thanks in advance

[Excelnoub]

What is your new titles:
A1=
B1=
........F1=

Because of this your transfer code will also need to change from A2:D to A2:F.

If you want to add a Time/Date stamp set the following code in your sheet1:

Please Login or Register  to view this content.

Everytime you will add information to Column E...Column F (Activecell) will add the date stamp or change Date to Now and you will have the time stamp.

Excelnoub