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

[EagleOne]

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

 

[Jeanette Cunningham]

EagleOne,
you write the code in Access VBA which will open the XL file and then format
it.
There are a great many code samples in these access newsgroups that show how
to do this.
Search for posts on automate excel. There is also code for this on The
Access Web.


Jeanette Cunningham -- Melbourne Victoria Australia

 

[EagleOne]

Thanks!

EagleOne,
you write the code in Access VBA which will open the XL file and then format
it.
There are a great many code samples in these access newsgroups that show how
to do this.
Search for posts on automate excel. There is also code for this on The
Access Web.


Jeanette Cunningham -- Melbourne Victoria Australia