The picture is too large and will be truncated

[dhruba.bando]

The picture is too large and will be truncated

This is what I get in Excel 97. I searched on the internet and only could
find a MS KB article referring to Office 2000. It also appears that this is
some kind of bug... that has been in the Office suite since 97 and still is
in Office 2003, etc.

I have VBA code copying and pasting text rows. There are no image picture
involved. But when I get this message, I do not get any reference of where
it was in VBA code.

How can one find out more about this bug?

[lucas]

I have VBA code copying and pasting text rows. There are no image picture
involved.

By copy and paste text rows do you mean entire rows of a spreadsheet with text in the cells? Please post the code you are using for this operation.

[dhruba.bando]

By copy and paste text rows do you mean entire rows of a spreadsheet with text in the cells? Please post the code you are using for this operation.

This is the only piece of code that does copy/paste:

Set MoldRow = oSheet.Rows(CurRow + TableRow - 2)
MoldRow.Copy
oSheet.Rows(CurRow + TableRow - 1).PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False

So as you can see it's copying a whole entire row from 2 rows above, to 1 row above.


Any ideas on how to suppress the error bug message?

[lucas]

I don't see why this should be giving you an error yet. Could you possibly post the workbook or the relevant part with the code your using. Remove any proprietary info including from doc properties. If its too big, zip it up.

[lucas]

I just noticed you mentioned Office 97...that could be the problem

[dhruba.bando]

I just noticed you mentioned Office 97...that could be the problem

Problem for you, or that lines of code is problematic for Office 97?