Thanks for the code, although I already know how to open a workbook, I some how worked it out myself and this is for any other fellow that come across this in the future. When items on the Listbox are clicked, it opens the associated workbook

Private sub ListBox1_Click()
Dim i As Integer
For i= 0 To ListBox1.ListCount -1
If ListBox1.Selected(i) Then
' Provided your ListBox1 has an item called Apple
' i.e I had ListBox1.AddItem("apple") previously.
If ListBox1.List(i) = "Apple" Then
Workbooks.Open("C:\apple.xls"), ReadOn:=False
End If
If ListBox1.List(i) = "Google" Then
Workbooks.Open("C:\google.xls"), ReadOn:=False
End If
End If
Next i
End Sub

Need some help with this Array. I am trying to get the sum of the even numbers and the sum of the odd numbers using a for each loop. I know the answers to what I am trying to achive are sum of even = 84 and the sum of ...

When I execute this progammatically, I get a table with row heights much larger than when I do this manually.

Note : Sel is the Word.Selection object and the Clipboard contains an Excel Table.

public void AddClipboard()
{
Sel.PasteExcelTable(false,false, false);
var t = Sel.Tables[Sel.Tables.Count];
t.AutoFitBehavior(Word.WdAutoFitBehavior.wdAutoFitContent);
}

I have a 2d matrix with dimension (3, n) called A, I want to calculate the normalization and cross product of two arrays (b,z) (see the code please) for each column (for the first column, then the second one and so on).
the function that I created to find the ...