exporting access table to excel problem

[nescartel]

hi all...

i made a database that keeps records in access table. however, on that form there is a button which have this code:

Private Sub Command50_Click()
DoCmd.OpenTable "TxPerlis"
SendKeys "%(TLA)", False
SendKeys "Yes", False
End Sub

the result is, when a user clicks this button, the access table will be automatically exported to excel table, and thus a new xls file is created, which i'm happy to say is what i want. however, when i go to "startup" settings and untick all field, hiding toolbar and all, this button somehow don't export the table to excel anymore. instead, it just opens access table, which i'm not happy with. why is this happening?

 

[ghudson]

Ditch the SendKeys junk and use the TransferSpreadsheet method. Check the Access help files on how to use TransferSpreadsheet and the Help will give your more details and examples.

 

[Connor]

do u think perhaps you could help out with the program functionality of it?

 

[Pat Hartman]

"It" being the TransferSpreadsheet Action/Method? Is your help not working? This is one thing that help actually explains very well. Be sure to read both the Action (macro) and Method (cod) entries.