fp4645
asked on
Open Excel File with VB
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:\pai ge\vb program\delinquent.xls")
xlWB1.Close
Set xlWB1 = Nothing
xlApp.Quit
Set xlApp = Nothing
Dim xlApp As Excel.Application
Dim xlWB1 As Excel.Workbook
Set xlApp = New Excel.Application
*Set xlWB1 = xlApp.OpenWorkbook("e:\pai
xlWB1.Close
Set xlWB1 = Nothing
xlApp.Quit
Set xlApp = Nothing
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Use "unload" command.
i can`t write english beter .
please help me .
thanks
aminvb