What am I doing wrong??? Error -2147467259
Okay, I thought I resolved this problem from another post. It was really just a work-around, but it's come back!
Basically, I'm reading an EXCEL sheet. Say, 1000 lines, reading columns B, D, E, & G.
Every time there is something to read in cell of column B, I do a
"set oHeader1 = objDoc.Content.Paragraph.Add"
and fill-in data.
Likewise, everytime there is something to read in column D & E, I do a
"set oPara2 = objDoc.Content.Paragraph.Add"
"set oPara3 = objDoc.Content.Paragraph.Add"
and fill-in data.
Everytime there is something to read in column G, I read it as a path and filename and insert an image.
I don't know what the problem is, but I get:
The formatting in this document is too complex. Please full save the document now.
I keep saying OK several times, then I get the error:
Run-time error "-2147467259(80004005)':
Method 'SpaceAfter' of object '_ParagraphFormat' failed
Am I "set"-ting way too many times?
Don't know what it could be. *grrrrrrrr*
Melissa