[AccessD] Slightly OT - Re: Excel Automation Question

Rocky Smolin rockysmolin at bchacc.com
Thu Aug 25 23:40:36 CDT 2016


Well, to be fair, Excel files containing gene lists.  

r

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Stuart McLachlan
Sent: Thursday, August 25, 2016 3:44 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Slightly OT - Re: Excel Automation Question

I know we've discussed Excel and data problems before, and I've mentioned
running into exactly the problem highlighted in this article.

But 20% of published articles with messed up data?

http://www.theregister.co.uk/2016/08/25/excel_hell_messes_up_20_per_cent_of_
genetic_sci
ence_papers/


--
Stuart

On 25 Aug 2016 at 12:55, Rocky Smolin wrote:

> Dear List:
> 
> 
> 
> I want to open a spreadsheet from Access and am using:
> 
> 
> 
>     Set objXLApp = New Excel.Application
> 
>     objXLApp.Workbooks.Open gstrBackEndPath & "\PO_" &
> Me.cboPOList.Column(1) & ".xlsx"
> 
>     objXLApp.Visible = True
> 
> 
> 
> which works just fine.  However, when the spreadsheet is closed by the 
> user the instance of Excel remains - I can see it in the Task Manager.
> 
> 
> 
> If I close the spreadsheet from Access:
> 
> 
> 
>     objXLApp.ActiveWorkbook.Save
> 
>     objXLApp.ActiveWorkbook.Close True
> 
>     objXLApp.Quit
> 
>     Set objXLApp = Nothing
> 
> 
> 
> Of course, Excel goes away.
> 
> 
> 
> Is there a technique for closing that instance of access when the user 
> closes a spreadsheet opened by an access program?
> 
> 
> 
> MTIA
> 
> 
> 
> 
> 
> Rocky Smolin
> 
> Beach Access Software
> 
> 760-683-5777
> 
>  <http://www.bchacc.com> www.bchacc.com
> 
>  <http://www.e-z-mrp.com> www.e-z-mrp.com
> 
> Skype: rocky.smolin
> 
> 
> 
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list