[AccessD] Run Excel From Within Access

Benson, William (GE Global Research, consultant) Benson at ge.com
Tue May 29 21:50:19 CDT 2012


You know, Guilty as Charred and "Char Foust" would have been even funnier if your last name were spelled *slightly* differently. Referring to you Charlotte was never my intention. I just meant that Stuart had me dead to rights.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Monday, May 28, 2012 11:29 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Run Excel From Within Access

ROFL

Char

On Mon, May 28, 2012 at 6:57 AM, Benson, William (GE Global Research,
consultant) <Benson at ge.com> wrote:

> Guilty as Charred.
>
> (Not misspelled)
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:
> accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
> Sent: Sunday, May 27, 2012 5:08 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Run Excel From Within Access
>
> Which is precisely why I called William on his unequivocal statement 
> about ShellExecute.  :-)
>
> --
> Stuart
>
> On 27 May 2012 at 13:52, Charlotte Foust wrote:
>
> > I know that Stuart.  But unequivocal statements  about a method's 
> > usefulness can be misleading to someone who doesn't make the distinction.
> >
> > Charlotte Foust
> >
> > On Sun, May 27, 2012 at 1:46 PM, Stuart McLachlan <
> stuart at lexacorp.com.pg>wrote:
> >
> > > This thread was NOT about automating/manipulating an Excel file.   It
> was
> > > about how to open
> > > a file.
> > >
> > > It was started by Arthur because he was  having difficulty with 
> > > Application.Run after creating the file.
> > >
> > > --
> > > Stuart
> > >
> > > On 27 May 2012 at 13:15, Charlotte Foust wrote:
> > >
> > > > CreateObject isn't intended to just open a file. There are much 
> > > > easier ways. It's there for when you need to manipulate the file.
> > > > I use it to
> > > open
> > > > an excel template, trigger the macro that imports an xml file 
> > > > into
> > > multiple
> > > > ranges, and then save the workbook as macro-free without getting 
> > > > into the Excel app itself.
> > > >
> > > > Charlotte Foust
> > > >
> > > > On Sun, May 27, 2012 at 12:40 PM, Stuart McLachlan
> > > > <stuart at lexacorp.com.pg>wrote:
> > > >
> > > > > And how many additional lines of code are required in addition 
> > > > > to that line which sets the variable - each time you want to 
> > > > > open a file?
> > > > >
> > > > > The  one line ShellExecute() (plus the  once per application
> > > > > Declare) isn't meant to, and does not "automate" Excel..  It 
> > > > > just *opens* any type of file which has an associated 
> > > > > application.
> > > > >
> > > > > IMNSHO,  CreateObject() is absolutely the hardest way to 
> > > > > display a
> > > file I
> > > > > have ever seen
> > > > > implemented.
> > > > >
> > > > > --
> > > > > Stuart
> > > > >
> > > > > On 27 May 2012 at 13:54, William Benson wrote:
> > > > >
> > > > > > Absolutely the hardest way to automate excel I have ever 
> > > > > > seen
> > > > > implemented!
> > > > > >
> > > > > > Just set a variable = Createobject("Excel.Application") and 
> > > > > > control
> > > Excel
> > > > > > through that.
> > > --
> > > Stuart McLachlan
> > >
> > > Ph:    +675 340 4392
> > > Mob: +675 7100 2028
> > > Web: http://www.lexacorp.com.pg
>
>
> > >
> > >
> > >
> > > --
> > > 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
>
>
> >
>
> --
> Stuart McLachlan
>
> Ph:    +675 340 4392
> Mob: +675 7100 2028
> Web: http://www.lexacorp.com.pg
>
>
>
> --
> 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



More information about the AccessD mailing list