Can't see the spreadsheet just created in code

[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

 

[Guest]

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