[AccessD] Export to Excel

Gustav Brock gustav at cactus.dk
Mon Feb 10 10:42:18 CST 2003


Hi Mark

> Does anyone have sample code that will format the data in Excel (thru a
> macro, I guess)?
> I've never used a macro in Excel, but this sounds promising.

The easy route - as a start - is to record a macro and then study what
it has carried out.

Then adjust and refine as needed.

The final part will be to exchange all the clumsy and slow "selecting"
code with code that defines ranges you then manipulate.

There is a learning curve, but it can be quite fun as you can do so
many things in Excel.

/gustav




More information about the AccessD mailing list