[AccessD] Run Excel From Within Access

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