Hey, i would seriously consider putting the calculations on the same workbook
You can run a vba code to make it xlveryhidden as in no one can open it
unless they got in to the code.

And whats the calculation, is it for one cell or multiple cells or do you
have any more information?

"TucAO" wrote:

Hi, I tried to do a data exchange between worksheets, should I use "Macro" or
"VB"?
To explain it in a a little detail, I got some experimental data ouput and
saved on one worksheet (named as "Cent1" under "workbook1"). I want to export
these data to another worksheet (named as "sheet1" under "workbook2") to do
some calculation. After the calculation and I want the result from "sheet1"
exporting to and showing in "Cent1". Ideally I want the calculation in
"sheet1" runing behind, which means I don't want Excel load and show
"Sheet1". I just want the "Cent1" sheet shows in screen.
To trigger the data exhange, I plan to put a button as "Calculate" in
"Cent1", so when I hit "Calculate", the data go to "Sheet1" and result shows
in "Cent1" while "Sheet1" runs behind the scene.

Any help is highly appreciated!!