[AccessD] Slightly OT - Re: Excel Automation Question

[Susan Harkins]

Okay... a bit of hijacking, but I have  defective MTHFR gene. :) When I
showed the handout from the doc to the folks at work, they thought I was
joking -- um... no. ;) But it is kind of funny. 

Did I tell you guys about this already? 

Susan H. 

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