[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