I am a student of VB. I am trying to figure out how to open an Excel workbook by clicking on a button on my VB form. I keep getting a message that the method is unsupported and the starred line is highlighted when I debug. Can someone please tell me what I'm doing wrong?
Dim xlApp As Excel.Application
Dim xlWB1 As Excel.Workbook
Set xlApp = New Excel.Application
*Set xlWB1 = xlApp.OpenWorkbook("e:\paige\vb program\delinquent.xls")
Set xlWB1 = Nothing
Set xlApp = Nothing