Event for Exporting.

D

David

I would like to export a query to Excel by clicking on a
command button.
Can anyone please help write an event for a command
button?

Thanks for your help.
 
R

Randy

I would create a macro using the 'OutputTo' action. Then
ad a button to your form and follow the wizard to connect
it to the macro.
 
D

David

Thanks for the response.
However I it does not give me the option to save it
as .CSV file
Can you help me?

Thanks
 
D

David

Thanks for the response.
However I it does not give me the option to save it
as .CSV file
Can you help me?

Thanks
 

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

How do I set focus (and select text) on a text box on a modeless userform? 0
Setting a default zoom in Infopath 0
Images are pixelated when saving to PDF 0
Adding Cost Field to Appointment 0
How do I create a set of words that are flagged? 0
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
No option to create a list in SharePoint Site 0
Using Office Forms and dynamically updating the excel backend 0

Top