-
I am trying to automatically export from my Outlook98 form: Access97 to excel97. I have a command button to do the process. I keep getting the following error.
Object required 'DoCmd'
This is the line I am using:
Sub excel1
DoCmd.outputTo acOutputQuery,"termexcel",acFormatXLS, & _ "C:\temp\term2001.xls",false
end sub
Can someone see what I am doing wrong.
-
What is DoCmd? Did you set or dim it as an Object?
-
I don't think 'DoCmd' is a visual basic command. I think it can only be used in Access and Word.
Paul Bousa