Excel operations in one workbook

Posted on 2009-02-23
Last Modified: 2012-05-06
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?
Question by:Student_101
    1 Comment
    LVL 13

    Accepted Solution


    You can define a global variable and use it as shown in the workbook attached

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Suggested Solutions

    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now