nomios
asked on
Help with broken Macro
Hi,
I created a knowledge base that uses a drop-down list to copy/paste data from another location. It's a simple macro. I have embedded images into comments to make it simple to pull images and paste them with a proper format.
The problem is, the sheet will only work on my computer and breaks as soon as I save it. When I save, I get a Privacy Warning.
Once I save and re-open the file, I get these errors:
"Excel found unreadable content...do you want to recover? Y/N
"Excel was able to open the file by repairing or removing the unreadable content."
Removed Part: /xl/drawings/vmldrawings1. vml part. (Drawing Shape).
Then, when the file reopens, the macro doesn't work, and, none of the embedded images from the comments appear.
VoltronEE.xlsm
I created a knowledge base that uses a drop-down list to copy/paste data from another location. It's a simple macro. I have embedded images into comments to make it simple to pull images and paste them with a proper format.
The problem is, the sheet will only work on my computer and breaks as soon as I save it. When I save, I get a Privacy Warning.
Once I save and re-open the file, I get these errors:
"Excel found unreadable content...do you want to recover? Y/N
"Excel was able to open the file by repairing or removing the unreadable content."
Removed Part: /xl/drawings/vmldrawings1.
Then, when the file reopens, the macro doesn't work, and, none of the embedded images from the comments appear.
VoltronEE.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Well I don't get any errors, but I'm not sure what you mean by 'comments with pictures.
The only pictures in the attached workbook are the phone and laptop which are on both Main and Product1.
That's before I change anything in the workbook or save it.
The only pictures in the attached workbook are the phone and laptop which are on both Main and Product1.
That's before I change anything in the workbook or save it.
ASKER
You can't see them because when I save and re-open it--that information is gone. I'm guessing that's why I get errors when opening the file.
Here's the process I'm using to embed pictures into comments:
http://blog.mclaughlinsoftware.com/microsoft-excel/add-image-to-a-comment/
Here's the process I'm using to embed pictures into comments:
http://blog.mclaughlinsoftware.com/microsoft-excel/add-image-to-a-comment/
I haven't saved the workbook, I just opened it.
ASKER
I'm having the same problem listed here:
http://www.excelforum.com/excel-general/788603-excel-2007-error-xl-drawings-vmldrawing1-vml-part.html
I can't find a solution...
http://www.excelforum.com/excel-general/788603-excel-2007-error-xl-drawings-vmldrawing1-vml-part.html
I can't find a solution...
That doesn't look like it's a macro problem, in fact I don't think the problem with the workbook is the macro.
Do you get any errors with it?
Do you get any errors with it?
ASKER
Maybe it's not with the Macro--I'm just not sure how to fix it.
I don't know either, perhaps if it was a macro problem I could help.
By the way, why are you using Excel for this?
Have you considered using some other application?
By the way, why are you using Excel for this?
Have you considered using some other application?
ASKER
I'm using Excel because I don't know of any other free applications that I'm familiar with that can do this sort of thing.
Excel isn't free.
I was thinking of something like Access or Word, or you could even create a small HTML 'site' - now that would be free.
I was thinking of something like Access or Word, or you could even create a small HTML 'site' - now that would be free.
ASKER
This got rid of the privacy error that I saw when I saved. However, I still get the same errors when I open the file--and none of the comments with pictures are there.