Possible to create XL file then run XL VBA (to format & filter XL file) from Access VBA?
 

2003

Is it possible to create XL file then run XL VBA (to format & filter XL file) from Access VBA?

If so, what is a high-level approach?

What I mean, does the XL VBA need to be in an Access VBA module?
Can I insert an XL VBA module from an Access VBA module then run it from the Access VBA?

TIA EagleOne

Possible to create XL file then run XL VBA (to format & filter XL
 

Hi,

You can run Excel VBA code from inside of Access. What you will need to do
is reference the Excel VBA library in the Access VBE. This is done under
Tools, References in the Access VBE. I have to say that this technique is
not common but the is at least one book on the market which covered this
topic - Office VBA, but its been 8 years since I've seen it. You might try
searching Amazon for Office VBA. I believe it was a Microsoft Press
publication.

--
Cheers,
Shane Devenshire
Microsoft Excel MVP
Join http://setiathome.berkeley.edu/ and download a free screen saver to
help search for life beyond earth.

" wrote:

2003

Is it possible to create XL file then run XL VBA (to format & filter XL file) from Access VBA?

If so, what is a high-level approach?

What I mean, does the XL VBA need to be in an Access VBA module?
Can I insert an XL VBA module from an Access VBA module then run it from the Access VBA?

TIA EagleOne