Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Help with broken Macro

Posted on 2012-03-20
11
Medium Priority
?
376 Views
Last Modified: 2012-08-13
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
0
Comment
Question by:nomios
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 35

Accepted Solution

by:
Norie earned 2000 total points
ID: 37743176
Goto the Developer Tab, click Macro Security, goto Privacy Warnings and uncheck 'Remove personal information....

You can also go via Files>Options>Trust Center Settings...
0
 

Author Comment

by:nomios
ID: 37743393
Hi,

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.
0
 
LVL 35

Expert Comment

by:Norie
ID: 37743478
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.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:nomios
ID: 37743681
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/
0
 
LVL 35

Expert Comment

by:Norie
ID: 37743857
I haven't saved the workbook, I just opened it.
0
 

Author Comment

by:nomios
ID: 37743923
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...
0
 
LVL 35

Expert Comment

by:Norie
ID: 37743960
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?
0
 

Author Comment

by:nomios
ID: 37743971
Maybe it's not with the Macro--I'm just not sure how to fix it.
0
 
LVL 35

Expert Comment

by:Norie
ID: 37744050
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?
0
 

Author Comment

by:nomios
ID: 37744086
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.
0
 
LVL 35

Expert Comment

by:Norie
ID: 37744163
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.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question