ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   The picture is too large and will be truncated (https://www.excelbanter.com/new-users-excel/100145-picture-too-large-will-truncated.html)

Dhruba Bandopadhyay

The picture is too large and will be truncated
 
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?



NickHK

The picture is too large and will be truncated
 
I have got this error when Copy/Paste as Picture, never when working with
ranges/rows etc.

NickHK

"Dhruba Bandopadhyay" wrote in message
...
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?





Dhruba Bandopadhyay

The picture is too large and will be truncated
 
Does anyone know how to contact Microsoft Office development team, the ones
who made Excel 97?

Am not requesting a bug fix to their 1997 program, but at least tell us why
or what makes this error message come up.


"Dhruba Bandopadhyay" wrote in message
...
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?




Dhruba Bandopadhyay

The picture is too large and will be truncated
 
Quote:

Originally Posted by lucas
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?

"Dhruba Bandopadhyay" wrote in message
...
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?





All times are GMT +1. The time now is 04:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com