[AccessD] Slightly OT - Re: Excel Automation Question

[Susan Harkins]

:) 

It IS funny... ;) 

It's real though. It's a genetic flaw, and like many genetic flaws isn't
always triggered. Why mine was and when I don't know. 

The skinny is... I'll get Vit B 12 shots for the rest of my life. It's an
easy fix for me for a condition that can lead to all kinds of mayhem... but
we know about it and I'm hopeful. 

Susan H.

Since it's Friday already here, I'll keep going.

That made me chuckle.

Does that mean you are a bad MTHFR or that you aren't a real MTHFR?

--
Stuart

On 25 Aug 2016 at 19:01, Susan Harkins wrote:

> 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_ce
> nt_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
> 
> --
> 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