to delete a png after inserting it

[chubbychub]

i have a macro that is currently inserting a watermark, and then it prints out a sheet. I want to add another step to it, which is to delete the watermark after it prints, here is the code

Please Login or Register  to view this content.

please help, thank you.

[karedog]

Maybe :

Please Login or Register  to view this content.

[chubbychub]

that works, thank you, so you dim it as a picture, and then just delete it , what if i have 2 pictures on there would it matter?

[LJMetzger]

Hi chubbychub,

For two pictures, use pic1 and pic2.

Lewis

[chubbychub]

so I will add this line:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[LJMetzger]

Please Login or Register  to view this content.

[karedog]

@chubbychub,
Thanks for the rep.points.

As LJMetzger described, you can use 2 "pic datatype" variables for the purpose.

In VBA language, you must assign every single variable name with its target datatype.
If you don't assign anything to the variable name, that variable name is automatically become "variant" datatype.

So, if you want pic1 and pic2 to have a "pic datatype", you should define it like this :

Please Login or Register  to view this content.

If you define them like this :

Please Login or Register  to view this content.

VBA will assume pic1 as "variant" datatype, because you don't assign any datatype to it.

[chubbychub]

ok, thank you for the teachings.

[karedog]

You are welcome, glad to help.


Regards