in the past users had to print about 200 agency data on a report
each of them contains 1 word doc as cover sheet and 1 to many excel sheets
so they printed all word docs then all excels of one type and then all of another type and then had to collate all that by hand
awful!

i would like to create a word doc, insert a section break at the end and insert the first elsx, another section break and the next xlsx

what I can't find is how to insert a section break and then I could

oDocument.InlineShapes.AddOLEObject("Excel.Sheet.12","H:\vAPPBAI\vBAI\Excel\AAVF_2014630_AES48000.xlsx",.t.,.f.)

but the excel sheet is to wide. can I scale it to fit between the left and right margin??

thanks

in case someone thinks i should google it, I did!


Peter