G
Guest
As well as specifying the file name is it possible to specify the sheet as
well?
well?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Here is the code how to mention the sheet name while transfering data to Excel.
Dim objXL As Excel.Application
Dim objWkb As Excel.Workbook
Dim objSht As Excel.Worksheet
Dim rst As Recordset
Dim iRow As Integer
'--- open the workbook
Set objXL = New Excel.Application
objXL.Visible = True
Set objWkb = objXL.Workbooks.Open("D:\MyProjects\MaterialList.xls")
'Here to mention the sheet name
Set objSht = objWkb.Worksheets("Sheet1")
' Further code lines..
Hope this helps
Ashfaque
Dim objXL As Excel.Application
Dim objWkb As Excel.Workbook
Dim objSht As Excel.Worksheet
Dim rst As Recordset
Dim iRow As Integer
'--- open the workbook
Set objXL = New Excel.Application
objXL.Visible = True
Set objWkb = objXL.Workbooks.Open("D:\MyProjects\MaterialList.xls")
'Here to mention the sheet name
Set objSht = objWkb.Worksheets("Sheet1")
' Further code lines..
Hope this helps
Ashfaque
Last edited:
K
Ken Snell \(MVP\)
See the info at this website:
http://alexdyb.blogspot.com/2006/07/export-to-excel-range.html
http://alexdyb.blogspot.com/2006/07/export-to-excel-range.html
G
Guest
Cheers
Ken Snell (MVP) said:See the info at this website:
http://alexdyb.blogspot.com/2006/07/export-to-excel-range.html