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 !! ;)

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 !! ;)

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 !! ;)