vbe - copy a cell's value by other workbook

P

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

Pal

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").cells("T13").value

hope it can help you to solve your problem.

"pls123" 來函：
 
P

pls123

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 said:
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").cells("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 !! ;)
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
calling sub from other workbook 1
Modifying a Template from another Workbook 1
macro to copy data to master workbook. 2
Email a workbook/worksheet on schedule? 1
access data from a closed wb protected with password without openi 6
hiding a control depending on a cell's value 13
Copy value from changing cells without VBA 1

Top