[AccessD] Excel Automation Problem - spreadsheet is hidden

This looks like a possible solution...

http://www.vbforums.com/archive/index.php/t-411430.html

Lambert 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Tuesday, April 13, 2010 11:44 AM
To: 'Access Developers discussion and problem solving'
Subject: [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/>