Heenan, Lambert
Lambert.Heenan at chartisinsurance.com
Fri Nov 13 15:22:43 CST 2009
Scratch the comment about needing to use xlApp.UserControl = False in the close routine. I just tested it and it does not seem to make any difference. -----Original Message----- From: Heenan, Lambert Sent: Friday, November 13, 2009 4:14 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Problem with Access VBA makes Excel Orphan Edward, I always open Excel files this way... Function Excel_OpenWorkBookHidden(Path As String, Optional UpdateLinks As Boolean = False, Optional Password As String = "") As Excel.Application Dim xlObj As Excel.Application <snip> Lambert