Please help! Clipboard

  • Thread starter auujxa2 via AccessMonster.com
  • Start date
A

auujxa2 via AccessMonster.com

I'm reposting this, because no one has responded to my previous thread. This
is the code I have to copy a table to a clipboard, so the user can paste the
data wherever they want in excel. But I need to not paste the headers. Can
this be done?

DoCmd.OpenQuery "CopyExportQry", acViewNormal, acReadOnly
DoCmd.RunCommand acCmdSelectAllRecords
DoCmd.RunCommand acCmdCopy
DoCmd.RunCommand acCmdClose

MsgBox "Stores are now copied to your clipboard, and ready to paste.",
vbOKOnly, "Booyah"

Thank you in advance
 
Top