VBA / Word Picture Content Control Causing Unreadable Content?

Jan 15, 2013

I am using VBA to create a word document (.docx). This word document contains plain text content controls as well as picture content controls. I then use VBA to automatically select a picture based on the code below

Set oCC = Word.ActiveDocument.SelectContentControlsByTitle("TabPic").Item(1)
On Error GoTo TabErrorHandler
oCC.Range.InlineShapes.AddPicture Filename:="X:XFERANDREW-TDCD " & LblVL &


After the document has been closed down I try to open it again and I am told "The file cannot be opened because there are problems with the contents."

When I click details it says "Unspecified error" and "Location: Part: /word/document.xml, Line: 2, Column: 0"

If I click ok it says "Word found unreadable content in "". Do you want to recover the contents of this document? If you turst the source of this document, click Yes.

Clicking Yes opens the document with all the contents and it is now renamed to Document 1. If I click no it does not open.

View 9 Replies


Found Unreadable Content In .....

Jan 14, 2008

I have received and error message:

Excel found unreadable content in "……………". Do you want to recover contents of this workbook?

This workbook has been used for quite some time now.

There are 3 of us who use this workbook nearly every day.

It opens fine on my pc but not on the other 2 (we all run 2007)

Now when they open the workbook it comes up with the following error.

If they open an older version its ok, however if I open it, do nothing to it, save it and then close it, the error appears.

View 9 Replies View Related

Found Unreadable Content

Jul 5, 2009

I am using office excel 2007 with all the latest updates installed on a windows vista machine. 3 months ago i made an xlsx file containing contact information. Few days ago, it was consist of 4 sheets. 1st sheet had about 18000 rows and 1 column while the other 3 sheets have about 100 rows and 1 column each. The last 2 days i get an error when i try to open the file i get the error Excel found unreadable content in "name.xlsx" Do you want to recover the contents of this workbook? If you truth the source of this workbook, click Yes. If i click on Yes i get another error this file cannot be open by using microsoft excel and ask me to search online. If i click no, 4 times, as many as the sheets i get the file open. with the following message

Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
Replaced Part: /xl/worksheets/sheet1.xml part with XML error. The name in the end tag of the element must match the element type in the start tag. Line 2, column 1249206.

and the 1st sheet with the most records is empty while the other 3 sheets are ok. I tried the built in repait method no go. I unistalled and reinstall office without installing the updates, nothing. I also tried some recover programes where only the recovery toolbox for excel worked but i am searching for a solution that i will not have to pay more money beside the office product to recover the damaged office excel.

View 9 Replies View Related

Excel 2007 :: Found Unreadable Content In File Name

Sep 10, 2012

I have a problem with the Excel 2007 file which I use on Windows 7.

The file suddenly appear message:

Excel Found Unreadable Content in 'File Name'. Do you want to recove the contents of this workbook? if trust the source of this workbook, click Yes.

if I click "YES" than this message will appear:
Excel was able to open the file by repairing or removing the unreadable content........ and so on

And all the file is missing inside the sheet.

Any way out to recover this file?

View 1 Replies View Related

Excel 2007 :: Found Unreadable Content In Filename (XLSM)?

Feb 22, 2013

I have an excel 2007 file which contain a lot of macros. File size is 100MB. This file is not developed by myself, it's post in the webpage and let the members of the page to download on daily basis.. I've been downloading and using this file for over a year with no problem until this week.

Problem: During opening the file. There is a message box popped up, saying "Excel found unreadable content in filename.xlsm'. do you want to recover the contents of this workbook ? If you trust the source of this workbook, click Yes." When I click "yes", excel is trying to repair the file. Once it's done, I could see only the contents, however, all the macros are gone. When I copied this very same file and open in other notebooks, everything is working fine...

Assumption: Couple days ago, I was writing/testing macros in other workbooks and also opened this particular file. I might did something stupid which cause this problem...

During the same time, I used to have the same problem with another file. I solved it by copy and open with another PC then copy macros and paste it to the file on my notebook.

View 6 Replies View Related

Read Cell Content & ADD Content + Font Properties *SOLVE

Sep 12, 2007

I use this to read cell content, add some text/characters (ie. [ and ]) and change the properties of the complete cell

Worksheets("DVD Lijssie").Activate
If ActiveCell.Value 0 Then ' Change all in to ... ... ...
ActiveCell.FormulaR1C1 = ActiveCell.Value & " " & "]" & " " & "["
With ActiveCell.Font
.Name = "Arial Narrow"
.Size = 8
.ColorIndex = 16
End With
End If
End Sub
HOW can I change this vba-code so it leave's the content of the cell like it is and add some content with the use of let's say TexBox1 and ONLY use different font properties for the newely added content?

View 9 Replies View Related

Merge The Content Of 2 Cells Into 1 (with A Comma Separating The Content)

Jan 29, 2007

how to combine the content of 2 cells into one cell and have the information separated by a comma.

For example:

Software 1

Spreadsheet Software

The desired results is:

Software 1, Spreadsheet Software

View 3 Replies View Related

Change Content Of One Cell Based On Content Of Another

Apr 18, 2014

Formula/macro/etc that would enable me to have content of a cell changed based on the content of another cell in the same row.

Example: cell in column D says "PSA" - so I would need the cell in column H for that same row to read "Radio"

I would need an entire sheet scanned to review for these occurrences and make the appropriate changes. I also would need the formula to be inclusive enough to scan for variations in column D cell content (PSA 1, PSA 2, etc).

View 4 Replies View Related

Remove Cell Content Based Upon Not Starting With A Word

Jun 16, 2008

I am working on a macro and, as part of it, I would like to look at column A of my spreadsheet and remove all cell contents where the text in the cell does not start with the word "total." For instance, if the text of a cell in column H is "total money" I would like it to remain unchanged. However, if the text of a cell is "George Baker" I would like it removed. I ONLY want the text in column H to be considered ... no other column.

View 3 Replies View Related

Matrix - Identify Cell Content In Column For Row If Matrix Content True?

Mar 21, 2014

For a table like the one below produced for the sake of example (actual is much much bigger) I want to make it list rows that are true for a certain column for a certain variable in the matrix. So for say water terrain, which types of activity can I do i.e. swimming. Or for Offroad the activites which I can't do i.e. Run and Swim.

Jog nym
Run nyn
Walk nyy
Swim ynn

View 10 Replies View Related

If Specific Row Contains A Word Then Clear Specific Content In Corresponding Column

Jun 18, 2014

I have a row (will always be row 3) where each cell contains a day of the week, the days repeats for a year or so, making the row almost 400 cells.

Like this,
Mo - Tu - We - Th - Fr - Sa - Su - Mo - Tu - We - Th - Fr - Sa - Su - and so on...

Though, A3 doesn't have to be "Mo" because the days in this case can change (A3 can start with "Tu"), hence I think I need a macro.

So if this row contains a weekend, "Sa or "Su" I want all the cells in the column beneath that which contains a specific value to be cleared.

Example, if "Sa" or "Su" has 3 values in the columns under them, all the values that contain "X" or "Y" has to be cleared.

Like this:
Rows (1,2,3...,)
3 Mo - Tu - We - Th - Fr - Sa - Su - .. and so on..
4 A --- B --- X --- Y --- X --- B --- Y
5 A --- B --- X --- Y --- X --- X --- X
6 A --- B --- X --- Y - --X --- Y --- C

After the macro it should be:

3 Mo - Tu - We - Th - Fr - Sa - Su
4 A --- B --- X --- Y --- X --- B ---
5 A --- B --- X --- Y --- X --- ---
6 A --- B --- X --- Y - --X --- --- C

Notice the two examples in the excel file.


View 6 Replies View Related

Listbox Control Source Causing Error

Oct 26, 2008

why this is causing an error upon opening the file. This workbook has a userform with a listbox (single list, single selection), and when I have the ControlSource property set it causes an error upon opening the userform (which opens when the file is opened), whereas if I do not have the ControlSource property set to anything, it seems to work fine.

Interestingly, if I set the file up to not open the userform with the file, and instead have the userform open when a worksheet control such as a command button is clicked, it doesn't seem to matter if the ControlSource property is set or not. The workbook in question is attached.

View 14 Replies View Related

How To Get First Cell Content

Mar 4, 2014

How Can I Get First Cell Content ? here is my sheet

.... A
1 Color
2 Red
3 Blue
4 Yellow

note : Color has filter

I want to make the cell B1 = first cell of column A - I try type in B1 =A2 ، but when i make filter (example i select blue) the cell B2 show nothing (i want B1 to show the filtered data on first column )

View 6 Replies View Related

Odd Cell Content

Nov 19, 2008

When I type in a cell it will repeat what I have typed multiple times within the same cell. For example, if I type x, as soon as I move out of the cell it will become xxxxxxxxx. I have checked all of the formatting of a cell that works fine against these ones and they are identical, there aren't any formulas.

View 5 Replies View Related

Put Cells With Content On Top

May 2, 2014

I've got two columns with data in only some of the cells in them. I need the cells with data in them to be put after each other at the top of a new column. Is there a formula for this?

Korsningshjälpen Excelforum.xlsx

View 8 Replies View Related

Copying Just The Non-zero Content

Feb 12, 2009

I have a worksheet of about 500 columns (or more)... I need to collect from a certain row, only a few dozens that are non zero. How can I create a formula that will take only the non-zero values from the columns, and list them in a new array or row?

The primitive solution I use now is copying the entire line to a different sheet (pasted with transpose) and the sorting A-Z... It's annoying because I need to afterwards delete hundreds of zero lines that seperate the positive from the negative, and it makes me lose track of the order in which these numbers appeared...

View 9 Replies View Related

IF Content Has A Value Show

Feb 10, 2010

I have a table in Excel 2007, I need to show the content of a column if it has data and if not leave empty, I think I need an if statement.

Column A may have content in a row but could have empty cells
Column B would be the same, but different rows, Column C to have the answer.

Like this

ColumnA ColumnB ColumnC ("Result")
Awe4 Awe4
Bye Bye
Empty Row
b78 b78
b65 b65

View 15 Replies View Related

Find Different Content And Insert Row Before It

Nov 14, 2013

I`m trying to create a macros that find new cell content in a column and add a row before it.

In the attached file is an example : insert_row.xlsx

In column A is the name of the row. And in some rows the name is changed.

I want to add a row before this change.

View 9 Replies View Related

Sum One Column Based On Another Content

Jun 9, 2014

Sum A1:A100 only for corresponding B1:B100 containing "paid". translate that to a formula? I don't know conceptually how to approach it.

View 1 Replies View Related

Change Cell Content

Aug 24, 2007

I have been supplied a list of names. The format is Smith J Mr, I would like this to read Mr J Smith.

Is there a command in excel I could use?

View 11 Replies View Related

Merging Content From Two Spreadsheets

Oct 24, 2008

What I am trying to do is take the data (all columns) in Spreadsheet 2 and put that data in Spreadsheet 1 with all the companies matching up, how do I do this, is this possible?

I tried using VLOOKUP but I don't know if I was doing it right and I don't even know if it's the right function to use.

In sheet 1, column A I have a list of about 30,000 companies
In sheet 2, column A I have a list of about 10,000 (pulled from sheet 1), I have other info associated with these companies in columns B and C.

Basically I want to take column A, B and C from sheet 2 and match them up with the same companies in sheet 1. So there will be 10,000 matches and 20,000 N/A's. This is how I set up the VLOOKUP but nothing happened.

View 8 Replies View Related

How To Use Spreadsheet For The Content Of Webpage

Jan 22, 2014

I was reading Box Office Mojo and wanted to know which actor would have the highest box office total if worldwide sales were accounted for and inflation was considered (for some reason they offer the data in 3 different formats but that is not one of them). I had previously only used Excel for simple records so I had to search your site for ways to write a few macros but I got everything working. I want to present the data.

It looks like embedding a spreadsheet in a webpage can be done but is there anyway I can add a feature so that if the person browsing the site clicks on a cell that cell's data will removed from consideration? I don't want the cell to actually display a "0" but if the background color could change to signify it was no longer being counted that would awesome. A lot of people argue about what movie should be counted toward an actors total box office record (starring roles only, supporting roles, voice work, cameos) so I would really like to be able to allow people to easily remove roles they personally don't think should count towards the total.

View 1 Replies View Related

Offset Cell Content VBA

May 29, 2014

I am looking for a vba to offset the cells.

The code I have currently is:

[Code] ........

This is only moving the selected cells across one, however - the content of the cells is what I wish to move so cell C25 has data pointing to another sheet cell A1 i.e. =Sheet1!$A$1 - can I edit this code so it alters the cell to reference B1, C1 etc....

View 14 Replies View Related

Msg Box Which Shows Content In A Cell

Feb 27, 2014

I want a macro to show a message with a content in the cell B3.

For EG: "Rec as of 'B3' is created"

This has to be the message and 'B3' has to be the content in the cell B3.

I tried doing it but i am unable to show the content in B3 in the message.

View 3 Replies View Related

Select Only Cells With Content

Jan 6, 2009

select only cells with content. Is it possible to use the next

View 5 Replies View Related

Show Content Of Particular Cell

Feb 9, 2009

I have 10000 data in my column A. i can genterate random number from 1 to 10000 through function "randbetween".

Now i want to display the particular data which column a and row as per that random number. in short i want to display data of "column A row (generated random number) for lucky draw selection.

View 2 Replies View Related

Using Content Of Cell Within A Macro

Feb 25, 2009

I am attempting to use a cell reference generated using the "address" function and text function (so the cell displays text only, not formula) as a means of defining the top left cell into which I want to paste a column of formulas. The reference cell is static, but the contents is dynamic.

View 3 Replies View Related

Add Value Based On Cell Content

Mar 18, 2009

I have a named range (D:16 F:800) called “NameRange” which contains names.
I’d like to create a macro which offsets a letter “x”, 10 columns to the right everywhere that name appears within the range. As an example: If I’m trying to find the name Tom, A dropdown menu shows the name “Tom” ( which I’ve created) whereby it calls upon a script to search within the named range from this:

Bob Kim Tom
Tom Sue
Mary Bill Ted
Tom Sue Bob
Fred Bill Sue
Bob Tom Kim

and offset “x” to look like this:.......

View 4 Replies View Related

Replacing Content From Dropdownlist

Jul 21, 2009

Hi i had created a drop downlist (Data Validation list) which consist of the city names and a masterlist of the respective City id to the city names on a different work sheet (same file).
But i would need to configure in such a way that when i select the city from the drop downlist it would appear as number ( City ID) on the excel file.

View 7 Replies View Related

Disabling Frames By Content

Jan 25, 2010

I have a UserForm with lots of controls divided by multiple frames. (163 controls over 19 frames). The same UserForm will be collecting multiple sets of data but the first set is a "master" set. Anything entered in the master set will auto fill in subsequent sets.

What I need is a way of preventing the user from changing any options that were input in the master set in subsequent sets. ie, If I entered info into Frame1 of the master set it would show up the next time I opened the UserForm (I have this part), but I would not be able to interact with it (this is what I need).

Since I'm already pre-populating subsequent sets with the master info, my first thought is to loop through each frame testing for input and if so setting Enabled = False, but I'm not sure how to do the loop/test. Is there a way to set up a "For Each Frame in UserForm" statement? Also, the controls in each Frame could be TextBox, OptionButton, and/or CheckBox. (sometimes more than one type in the same Frame)

View 2 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved