Excel Automation

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

Hi All,

Just looking for some advice. Is it quicker and more efficient to call an
Excel macro from Access or programme Excel from the Access module?

Also, is there a list anywhere of all the types of functions available as
below:

With XL
.Rows("1:2").Delete
.Selection.RowHeight = 19.25

etc. etc.

Many thanks in advance,

Martin
 
Also, is there a list anywhere of all the types of functions available as
below:

With XL
.Rows("1:2").Delete
.Selection.RowHeight = 19.25

etc. etc.
Click to expand...

The object browser should show everything... functions, methods, properties,
etc. I'm pretty sure that if it's not there, it doesn't natively exist in
your referenced libraries.
Just looking for some advice. Is it quicker and more efficient to call an
Excel macro from Access or programme Excel from the Access module?
Click to expand...

I think it depends on how intensive the task to be done in excel is. For a
quick 'get me this cell value', I would think that direct from access would
be more efficient, but if you have a whole plethera of tasks to perform in
excel via access, you're probably better off calling some excel code/macro
from access to let excel handle the situation natively.

hth
--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)
 
Thank you for the advice

Jack Leach said:
The object browser should show everything... functions, methods, properties,
etc. I'm pretty sure that if it's not there, it doesn't natively exist in
your referenced libraries.


I think it depends on how intensive the task to be done in excel is. For a
quick 'get me this cell value', I would think that direct from access would
be more efficient, but if you have a whole plethera of tasks to perform in
excel via access, you're probably better off calling some excel code/macro
from access to let excel handle the situation natively.

hth
--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)
Click to expand...
 
If you already have a macro in EXCEL that does what you want, you can open
the EXCEL file and run the EXCEL macro from ACCESS. No need to reprogram the
EXCEL macro into ACCESS VBA.

But, to give more specific suggestions/recommendations, we'd really need to
know a lot more details.
 
Back
Top