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

E

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
 
J

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
 
E

EagleOne

Thanks!

Jeanette Cunningham said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting XL and Access to communicate in VBA 7
Excel not "letting go" after DoCmd.Transferspreadsheet (Automation) 3
? Save XL TransferSpreadSheet file; For Next not working in Automa 10
VBA Code to add "Microsoft Excel 12.0 Object Library" to Access .mdb VBA module 6
Remvoving Null Items from an ADO Recordset prior to sending to Exc 3
Syntax to address ThisWorkbook.BuiltinDocumentProperties via Access Automation? 2
Convert xls to xl? 1
Create Access front end for Excel file? Or keep all in XL? 7

Top