M
merlinbk
Hello,
I'm trying to figure out how to copy an embedded OLE object from a
table field in access 2000 into a word 2000 document using vba.
I tried using the MS Access reporting forms and they wouldn't correctly
format the embedded excel spreadsheet (this is why i'm resorting to a
final output in word).
I managed to take the data from the table and have it automatically
create a word document and paste the fields, but when it came to the
ole object I could only copy and paste it in manually.
I went into the table and clicked on the ole field... CTRL-C'd it into
the clipboard, and once it was there my code could pull it from the
clipboard and paste it into the word document.
Is there a way to do that CTRL-C portion via code, or is there a better
way of going through the recordset and pulling the fields into
something that will then make it feasible to output to word.
Thanks in advance.
I'm trying to figure out how to copy an embedded OLE object from a
table field in access 2000 into a word 2000 document using vba.
I tried using the MS Access reporting forms and they wouldn't correctly
format the embedded excel spreadsheet (this is why i'm resorting to a
final output in word).
I managed to take the data from the table and have it automatically
create a word document and paste the fields, but when it came to the
ole object I could only copy and paste it in manually.
I went into the table and clicked on the ole field... CTRL-C'd it into
the clipboard, and once it was there my code could pull it from the
clipboard and paste it into the word document.
Is there a way to do that CTRL-C portion via code, or is there a better
way of going through the recordset and pulling the fields into
something that will then make it feasible to output to word.
Thanks in advance.