I'm trying to write a bit of code that will collect information from an Excel workbook and then determine all of the calculations into a separate workbook. This includes creation of columns, generating the values, and creating a graph once the user clicks a button that I've already created. I can already perform these operations if the information is in the same workbook (and sheet) as the calculations. I am also able to select a specific sheet in another workbook. The question is, how do I combine these two bits of code to work?

Here's the code to open up a second workbook:

```
Dim file_path As String
Dim excel_title As String
Dim second_excel_title As String
file_path = "C:\Work\EXCEL_TEST\"
excel_title = "test_info"
second_excel_title = "test_calculation"
Set wbs = Workbooks
wbs.Open (file_path & excel_title)
Set wb = wbs.Item(excel_title)
wb.Sheets.Add after:=wb.Sheets(wb.Sheets.Count)
wb.Sheets("Sheet1").Select
```

As a test I was going to make a 3 by 3 block of numbers (1 - 9) in the test_info workbook and then perform random calculations on them (such as subtraction and multiplication) and output the answers in the test_calculation.

Thank you,

Jesse