Excel operations in one workbook

Hi experts,

I am using excel with vb6 to output some results, and do do some calculations.

I have 2 commands, one that does the calculation and displays the answer calucated from excel in VB6, another command that outputs the result of those calculations, such as the range I performed the calculation on, the slopes, RSQ, etc.

In my first command when I do the calculations, I don't show the excel worksheet, I get the results, and quit the application.

In my 2nd command, I do show the excel worksheet, as that is the output.

What I want to do is to have all the data in one Work Book.

So sheet one can have all the calculations if the user needs, and the 2nd worksheet can have the results.

How do I get all the operations in one workbook?
Who is Participating?
Hitesh ManglaniConnect With a Mentor Commented:

You can define a global variable and use it as shown in the workbook attached
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.