I want to link to excel, do some math, then write the cell to a label in my form.
Code:
    Dim XL As Excel.Workbook
    Set XL = GetObject("C:\cat1(current)\stocking.XLS", "Excel.Sheet")
    XL.Application.Visible = True
    XL.Application.Windows("Stocking.XLS").Visible = True
    Label1.Caption = XL.Range("C10")
Everything worked fine until the last line. How is that done?