[AccessD] Slightly OT - Re: Excel Automation Question

[Stuart McLachlan]

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
>