How to take a cell value one excel file to another excel file

[kdilip]

1. I have a master template of excel sheet, now I want to take the value and formula from the master sheet and put inot another excel sheet. I have developed an UI in Visual Basic and the above operation I want to do using Visual Basic.

[Guido Geurs]

dear,

Open the 2 files in the ZIP.
Go to Book1 and click on de commandbutton.
It will copy in the same book on sheet 2 and 3 and in sheet 1 of book2.

br,

[kdilip]

Not able to click on command1 button, not clickable

[Guido Geurs]

Not able to click on command1 button, not clickable

dear,

I'm using Office 2003.
You can also start the macro "Copycell_Click ".

br,