Excel Automation

[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

 

[Jack Leach]

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.

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?

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)

 

[Martin]

Thank you for the advice

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)

 

[Ken Snell [MVP]]

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.