Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheets not visible in Excel XP
I wrote the following code in Access to create an Excel spreadsheet
output. In Excel 2000 it works fine. When I put it on Excel XP, the spreadsheet is not visible and I can't seem to find a way to make it visible. What am I missing? ' Setup Excel Spreadsheet Dim xlApp As Excel.Application Dim wkb As Excel.Workbook Dim wks As Excel.Worksheet Const XL_NOTRUNNING As Long = 429 Set xlApp = GetObject(, "excel.application") Excel.Application.SheetsInNewWorkbook = 1 Set wkb = Workbooks.Add Set wks = Worksheets(1) ... bunch of cell writes ... ' Save the spreadsheet sFileName = Me!tFileName wkb.SaveAs sFileName Exit_WriteToExcel: wkb.Close xlApp.Quit Set wks = Nothing Set wkb = Nothing Set xlApp = Nothing Set rs = Nothing Set db = Nothing Exit Sub Thanks, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Status bar not visible in my .xlsx worksheets. | Excel Discussion (Misc queries) | |||
Excel file opens but no worksheets visible | Excel Discussion (Misc queries) | |||
Visible WorkSheets | Excel Programming | |||
Help: Macro to to sum across selected visible worksheets | Excel Programming | |||
Visible property on Worksheets | Excel Programming |