0

I have tried following code to open an existing excel file. the code gets executed but the excel file does not appear on the monitor please help.
Dim xlTmp As Excel.Application
Set xlTmp = New Excel.Application
xlTmp.Workbooks.Open "L:\FormsNRegisters\Accounts\Bill_Forms.xls"
Dim xlSht As Excel.Worksheet
Set xlSht = xlTmp.Sheets(1)

2
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by R_K_Sarma
0

try this

Dim xlApp As Excel.Application
Dim xlWB1 As Excel.Workbook

Set xlApp = New Excel.Application
xlApp.Visible = True
Set xlWB1 = xlApp.Workbooks.Open("L:\FormsNRegisters\Accounts\Bill_Forms.xls")
0

try this

Dim xlApp As Excel.Application
Dim xlWB1 As Excel.Workbook

Set xlApp = New Excel.Application
xlApp.Visible = True
Set xlWB1 = xlApp.Workbooks.Open("L:\FormsNRegisters\Accounts\Bill_Forms.xls")

Thank u abu Taher. it works

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.