export table to xl file

[vish]

I can export tables to xl using DoCmd.TransferSpread function but I wanted to implement this as...
when user pressess the command button on a form, ExportFileDialogBox has to be brought up so that user can choose the xl file name and location of his choice. How can I implement the ExportFileDialogBox ? I learnt that I can get the Active X control from VB and incorporate in Access toolbox..but i have no idea as how to do.. can anyone please help me. try to explain steps as i am new to access programming.
Any help is appreciated.

 

[Ice Rhino]

Sorry, this is not a solution to your problem, but when you find out by this forum or other, I would very much like to know also

Many Thanks and sorry if you thought I was gonna give you the answer to your problems


Toni