9tanstaafl9
Well-known Member
- Joined
- Mar 23, 2008
- Messages
- 535
Is this possible? I would like to use a macro to convert an image exported from another program into a Microsoft Drawing Object, so that when users save the file they won't get a bunch of error messages. If I right click the image, choose edit, and then say OK on the message asking if I want to convert, this solves the problem -- but I need it to happen with the macro, since I won't be there when this happens in the future.
I tried using the macro recorder, but it doesn't record anything other than that I selected the picture.
And I would just have the macro do a save without showing the error message, but this won't help when users reopen or edit the file later and they aren't using my macro (which basically just reformats the sheet for them so the exported file is pretty and has formulas instead of just values).
Any ideas?
It is a Crystal Report exported into Excel 98-2003, opened with Excel 2010 if that matters.
I tried using the macro recorder, but it doesn't record anything other than that I selected the picture.
And I would just have the macro do a save without showing the error message, but this won't help when users reopen or edit the file later and they aren't using my macro (which basically just reformats the sheet for them so the exported file is pretty and has formulas instead of just values).
Any ideas?
It is a Crystal Report exported into Excel 98-2003, opened with Excel 2010 if that matters.