 Pivot Table to Word (via vba copy/paste)
I want to copy an Access pivot table into word with vba.
I'm guessing I'd need to Select All, copy to the clipboard, and paste
special into word at a bookmark.
I know how to address the bookmark, I just don't know how to select,
copy and paste (actually, I will probably be able to find the paste
special command for word) via vba.
Right now I have:
--------------
DoCmd.OpenForm "frm_pvt_Amend_Area_Union2", acFormPivotTable
SendKeys ("^a")
SendKeys ("^c")
DoCmd.Close acForm, "frm_pvt_Amend_Area_Union2"
---------------
I'm going to need to cause the routine to 'wait' or 'sleep' before I
close the pivot table form because right now it closes before the keys
reach it. Other than that it pastes fine.
These commands didn't work for me (caused an error - only available in
design mode?):
'DoCmd.RunCommand acCmdSelectAll
'DoCmd.RunCommand acCmdCopy
Thanks,
Christian
| 
