Can't see the spreadsheet just created in code

  • Thread starter Thread starter Bill Reed via AccessMonster.com
  • Start date Start date
B

Bill Reed via AccessMonster.com

After I successfully create a workbook, populate a spreadsheet
(sCopyToExcel in this forum), and close the workbook, when I reopen the
workbook, I get a see-through window! I can see the desktop through the
Excel window. Any suggestions?

Bill
 
You did not successfully destroy the instance of Excel you created when you
created the workbook. Try this. After you have created the workbook, but
before you open the spreadsheet, open Task Manager, select the Proccess Tab,
and look to see if there is an instance of Excel.exe listed. If this is the
case, then the problem is what I said above. In your code, you should have:

xlBook.Close 'This is the workbook object
xlApp.Quit 'This is the Excel Application object
Set xlSheet = Nothing
Set xlBook = Nothing
Set xlApp = Nothing
 
Back
Top