• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 149
  • Last Modified:

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?
0
Student_101
Asked:
Student_101
1 Solution
 
hiteshgoldeneyeCommented:
Hi,

You can define a global variable and use it as shown in the workbook attached
Book1.xls
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now