Yo man,
i dont know about the VB code, but its fairly simple to convert a access table to excel format. you just need to go to the macors and write a new one using the function
OutputTo
in the window near the foot note selecte these options
object type - Table
object name - <name of the table...
Ans to your first issue :to elminate the warning message, asking you to confrim if you want to replace the file
you need to create a from with a comand button on it this button will be joined with the macro with gives the output. if you click this button when the form is in form view the warning...