Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Detect and delete "empty" pictures.
Hi all, Would anyone know how to detect "empty" pictures merged from Excel's empty fields and inserted into Word by IncludePicture and Convert(ed)ToShape?
Last edited by qqla : January 4th 06 at 03:27 AM |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Detect and delete "empty" pictures.
Hi Qqla,
Would anyone know how to detect "empty" pictures merged from Excel's empty fields and inserted into Word by IncludePicture and Convert(ed)ToShape? The only way I could distinguish between "real" pictures and "empty" ones was Convert(ing back)ToInlineShape which generates "4120 Bad patameter" error for "empty" ones, but unfortunately breaking document formating at the same time. Can you describe how this solution is working? I take it you're using a macro to do the shape conversion? Why not perform the check BEFORE converting to a shape? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#3
|
|||
|
|||
Thank you Cindy for replying to my post. I'm using VBA and the reason I'm not checking for empty fields in the MergeField(s), i.e. {IncludePicture {IF {MergeField FieldName} "" "path\\picture.gif" ""}}, is that IF construct causes to repeat the same picture after merge operation in word 2000.
Finally I got around this problem by searching for a path with no picture after merge, having field codes turned on, and replacing it with "". But it is not a "clean" solution. Thanks, Qqla Quote:
|
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot use the delete key for deleting a block of text | Microsoft Word Help |