| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vbe - copy a cell's value by other workbook
hi all i ask again this question.. i had no answers last time and its very
important for me i have to copy a cell's value by other workbook.. like this formula : "='C:\WB\[Sample.Page.xlsm]Sheet1'!$T$13" but i dont need in formula but in vbe .. not this ... Range("A4") = "='C:\WB\[Sample.Page.xlsm]Sheet1'!$T$13" but a VBE direct input... its very important because i have a manual calculation called by the macro.. so i have to make that way to have full syncronization of some values... HELP ME please !!! call some big boss if you can !! ;) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vbe - copy a cell's value by other workbook
Actutally, i m not very understand your question,
but, let me guess, if you going to copy some value from other workbook, but not the forumla? you got 2 workbook 1) - current with the macro 2) sample.page.xlsm in sample.page.xlsm , Sheets1 , T13 , there is a value, you want to copy to 1) cells A4? if so, you can use the following statment, cells("a4").value = workbook("Sample.Page.xlsm").sheets("Sheets1").cel ls("T13").value hope it can help you to solve your problem. "pls123" 來函： hi all i ask again this question.. i had no answers last time and its very important for me i have to copy a cell's value by other workbook.. like this formula : "='C:\WB\[Sample.Page.xlsm]Sheet1'!$T$13" but i dont need in formula but in vbe .. not this ... Range("A4") = "='C:\WB\[Sample.Page.xlsm]Sheet1'!$T$13" but a VBE direct input... its very important because i have a manual calculation called by the macro.. so i have to make that way to have full syncronization of some values... HELP ME please !!! call some big boss if you can !! ;) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vbe - copy a cell's value by other workbook
yess Pal TY !!
it seems what i was looking for !!! i will work on it in the week end !! is it possible to indicate the directory ??? "Pal" wrote: Actutally, i m not very understand your question, but, let me guess, if you going to copy some value from other workbook, but not the forumla? you got 2 workbook 1) - current with the macro 2) sample.page.xlsm in sample.page.xlsm , Sheets1 , T13 , there is a value, you want to copy to 1) cells A4? if so, you can use the following statment, cells("a4").value = workbook("Sample.Page.xlsm").sheets("Sheets1").cel ls("T13").value hope it can help you to solve your problem. "pls123" 來函： hi all i ask again this question.. i had no answers last time and its very important for me i have to copy a cell's value by other workbook.. like this formula : "='C:\WB\[Sample.Page.xlsm]Sheet1'!$T$13" but i dont need in formula but in vbe .. not this ... Range("A4") = "='C:\WB\[Sample.Page.xlsm]Sheet1'!$T$13" but a VBE direct input... its very important because i have a manual calculation called by the macro.. so i have to make that way to have full syncronization of some values... HELP ME please !!! call some big boss if you can !! ;) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a cell's value to copy another cells info to another workshe | Excel Worksheet Functions | |||
| Formula to copy another cell's contents - Help! | Excel Discussion (Misc queries) | |||
| A cell's value renders a workbook read-only | Excel Discussion (Misc queries) | |||
| cell's reference value dependent on another cell's value | Excel Programming | |||
| How do you copy a cell's content verses it's formula? | Excel Discussion (Misc queries) | |||
Hybrid Mode
