Q: Can you please help me on how to tell ms access, my database, using visual basic's command button to produce or export a table and in an excel format.
Manual: I can do that in ms access manually just by highlighting the table i've made. Then right click it and choose Export and after that, choose a destination on where to put that file. (Let's say to the desktop, "Save in Desktop"). And then in the "Save as Type: field choose microsoft excel 3 and then click export. That i can do...Manually.

Now i want to convert that steps using vb so that when i click the command button, it will do that task i did above automatically and save it to desktop.
Private Sub Command1_Click()
<-------------Please show what to put here so that it will do the task above.
End Sub
Thanks and regards,
This post has been edited by mark25: 11 May, 2008 - 09:13 PM