[AccessD] Run Excel From Within Access

Stuart McLachlan stuart at lexacorp.com.pg
Sun May 27 15:46:19 CDT 2012


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



More information about the AccessD mailing list