[AccessD] Excel Automation Problem - spreadsheet is hidden

Dear List:

>From an Access module I open a workbook, locate a specific worksheet, delete
all the cells and re-create it from data in tables.  I close the book:

' close spreadsheet
    Set xlSheetProductionPlan = Nothing
    Set xlSheetBOMs = Nothing
    
    xlBook.Save
    xlBook.Close

    Set xlApp = Nothing
    Set xlBook = Nothing

MsgBox "Export Complete.", vbExclamation
 
End Sub


but when I open the spreadsheet it is hidden (it doesn't start out that way)
and I have to unhide it Window-->Unhide...

Would anyone know know why it's doing this or what the command would be to
unhide this spreadsheet from the Access module?

 

MTIA

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/>