G
Guest
We've just discovered a bug depending on whether Macro A or Macro has been
run on a workbook.
Macro A inserts an image from an original jpg on a network drive
Macro B inserts an image from an exisiting "template" in the workbook.
Whilst both images are the same (the image pasted in the template came from
the original jpg) the first Macro causes us problems when run a third macro
which reformats the workbook. If the source of the images on the workbook is
Macro A they get duplicated.
We want to rewrite the Macro to insert the images from a network copy of the
excel template - ideally without opening it.
Any suggestions?
run on a workbook.
Macro A inserts an image from an original jpg on a network drive
Macro B inserts an image from an exisiting "template" in the workbook.
Whilst both images are the same (the image pasted in the template came from
the original jpg) the first Macro causes us problems when run a third macro
which reformats the workbook. If the source of the images on the workbook is
Macro A they get duplicated.
We want to rewrite the Macro to insert the images from a network copy of the
excel template - ideally without opening it.
Any suggestions?