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.
Thanks and regards,
This post has been edited by mark25: 11 May 2008 - 10:13 PM