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?