Exporting to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

As well as specifying the file name is it possible to specify the sheet as
well?
 
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
 
Last edited:
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Query to Excel 1
Access export to excel produces "unreadable data" 0
Transfer Spreadsheet method: Sheet Name 2
Excel I have a large (62pages) excel file that needs to be sent as a pdf but it is only exporting half !? 2
Using DAO to export access query results to excel 5
TransferSpreadsheet 1
Filtering a Query then Exporting to Excel using VB 1
Differences exporting to Word from Access 2007 1

Back
Top