Storing Values in Module?

[Mr Denove]

Afternoon, I have a simple problem but one which I am not yet experienced / understanding on how to create it.

I do alot of calculations in a source workbook, this data then feeds into the Main workbook (where the code is contained).

How do I retain each calculated value in the Source workbook and update the Main workbook after all calculations are completed?

Thanks in advance.

Stuart

 

[mikerickson]

The simplest way would be to write the values that you want preserved into cells of the workbook.
Formulas are the ususual way to get the results of a calculation into a cell.

Then in the master workbook formulas like =[SourceWorkbook.xlsx]Sheet1!$A$1 will pull the data from SourceWorkbook, once the cell address has been adjusted to your actual names and layout.

 

[Mr Denove]

Hi Mike, many thanks for your reply.
I had gone down this route, as you have also suggested this it does seem the best way forward.
Was just hoping I could store the values in the code (and thus improve my VBA knowledge) when moving a value,string etc between

 

[Joe4]

You can use Global VBA variables to store dynamic values, but they are only stored for the duration that a VBA procedure is run.
Once you close the workbook, or run some other procedures, those values are gone/reset.
So VBA is not a good place to store values. Saving them to the workbook is the way to go. People often use hidden sheets or ranges to store them, if you do not wants users to see that.