[AccessD] Problem with Access VBA makes Excel Orphan

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




More information about the AccessD mailing list