[AccessD] Slightly OT - Re: Excel Automation Question

[Stuart McLachlan]

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
>