I posted this on modules & VBA but got no replies.
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.
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.
