Email:      Pass:    Pass?
Advertisements


Free Excel Forum

Word File Embedded In Excel

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Hi there,

I have a big Word file which is embedded in an Excel file. The Excel file consists of tables that are linked to the Word file. The Word file is about 100 pages and consists of text as well as linked tables.
The problem I have is that every time I update text or figures in my Word file and save the changes, the entire (Excel) file seems to double in size. What started as a file of 3 MB has grown to be a file of 20 MB now and is getting too slow to work in.
What I do after updating my Word file is saving the Word document by replacing the old one. After that I save the entire Excel file (with the newly saved Word file embedded) under a new name, so that a new 'version' is created.
As far as I can see track changes is not active.

Does anybody know what could be the problem?
Thanks!
Carola


Similar Excel Video Tutorials

Helpful Excel Macros

Open a Word Document from Excel
- This Microsoft Excel macro will open a Microsoft Word document from excel. With this macro, you can open any word docume
Prevent Saving a Workbook under a Different File Name
- This Excel macro prevents the user from saving an excel file or workbook under a different file name. The file can only
Open any Program from Excel
- This free excel macro allows you to open any program on your computer from excel. You can open a media player, file vie
Open Microsoft Word from Excel
- This free macro will open the Microsoft Word program on your computer. You do need to have this program first. This wi
Output the File Path to and Name of a Workbook in Excel - UDF
- Free Excel UDF (user defined function) that displays the full file path and name of an Excel workbook. This function is

Similar Topics







I am not sure this is the right forum but I fiqured "What the heck". Does code exist to convert a linked Excel file within a Word document to an embedded Excel file within the same Word document. This would help me with version control of my Word document. Multiple people would be working on this document in a chain. There is some back and forth between my client and various personnel in my firm. If there is code that could identify a linked Excel file(s) within the Word document and convert it to an embedded Excel file(s) that would be great.

Thanks....


Hi,

I'm having problems with editing a Word document that I embedded in the excel file using the insert object tool.
Basically, what I have already done now using VBA is to automatically open a separate existing word document that has an image and a title in the header and to copy from excel to that word document, some text, a range as a picture and some charts as pictures then save it automatically as a new file.
Everything works fine.
But the problem is I have to send this file to other people so they can use it, and for now I have been able to make it work on other computers by sending both excel and word files and telling them to put it in the same folder.
What I would like to do now, is be able to only send the excel file with the word document embedded inside. I have tried googling this but couldn't find a way to open that embedded file and edit it. I thought it would be just be opening the embedded file instead of opening the seperate word file and it would work but it doesn't seem that way or I just don't know how to.
I found these lines which are supposed to open the embedded file but couldn't get it to work.

Worksheets("Sheet1").OLEObjects("Template")

WDApp.Visible = True

I'm pretty new at VBA so I'm not sure what to do. Any help would be greatly appreciated!

Thanks!


Below is the current VBA code that is working when I use a separate word and excel file.

Code:

Sub OpenCopyToWord()

Dim WDApp As Word.Application
Dim WDDoc As Word.Document
Dim nIndex As Integer

Worksheets("sheet1").Range("S18").Select
    file_path = ActiveCell.Value

Hi,

I have a problem with an annual report Word file that I have used paste links from an Excel file. After a while the Word file gives a message saying that Word has insufficient memory and you have to save the file immediately or it starts looping or sometimes just freezes.

Seems to happen in Word 2003 and Word 2007. The excel file is an excel 2007 file saved as 2003 compatible.

Would love to solve this message problem, someone mentioned it could be to do with Bookmarks but I haven't deliberately used them unless they are hidden within the file. Would welcome any suggestions or solutions as it is very frustrating and slow to work in the Word file.


A few times I would use Excel and something annoying
would happen; I would embed an Excel object into a
Word file (creating the Excel file in Word directly),
then occasionally I would get an error message saying
it had turned into a picture, which I obviously could
no longer edit. While for other reasons (concerns
about formatting and margins) I had started taking the
precaution of inputing data into a separate Excel file
and then copying and pasting into Word from Excel, one
co-worker did not show such prescience, and had a
large embedded Excel object in a Word file turn into a
picture. What can we do regarding this?


Here is the situation.
I have an excel sheet with data. THe user unters the data via userform. Once the userform is complete, the user clicks Email. Once that is clicked, the embedded word document on the active sheet opens and updates with the information provided in the given cell. The content of the word document placed in the body of an email and then sent.

Here is the problem.
There are 8 different sheets that contain different data with a different embedded word document. This file is placed on a share drive that is available to all users.

I have tested the file and there are no problems. Then out of nowhere, the last 5 sheets in the book lose their links. The word document opens and does not update any of the links. The links do not display the Update Link, or Links options. The only option available is Object. When clicked an error pops up. I have gone through and reset each link by copying the cell, pasting special (link, unformatted text) and tested the file. After closing it down and trying again, it work for a bit but then closes out again.
If the name of the file is changed, or moved it fails again. But only the last few sheets. The first 2 work like a charm every time.

How do i assure that the links in the word document will not change, and will always refer to the excel file that contains the embedded doc?

It is really messing up my program always having to reset the links.
The first few sheets always work no matter what the file name or location. All the links are being created the same exact way.


A few times I would use Excel and something annoying
would happen; I would embed an Excel object into a
Word file (creating the Excel file in Word directly),
then occasionally I would get an error message saying
it had turned into a picture, which I obviously could
no longer edit. While for other reasons (concerns
about formatting and margins) I had started taking the
precaution of inputing data into a separate Excel file
and then copying and pasting into Word from Excel, one
co-worker did not show such prescience, and had a
large embedded Excel object in a Word file turn into a
picture. What can we do regarding this?


Trying to merge text data (Names, Addresses, etc.) from Excel worksheets to tables in Word document. I have 3 excel files with distinct information. (One is the original file, the other two were created by opening the first, modifying the information and doing a Save As -- this may be part of the problem.) When I preview/merge, the Word document always retrieves the information from the first excel file (although I have instructed it to link to a different file.) I have tried creating entirely fresh Word documents with fresh fields linked to the correct .xls file, and have also tried deleting the .xls file with the wrong information -- yet that is still the information that shows up in the merged document! What's going on and how can I correct it?? If I need to create a new data source document, maybe there's a way to transfer the text so I don't have to re-enter all of the data?


The title pretty much summed it up. I have some charts copied into a word file. The charts are linked to the original charts in an excel file. Ideally I would love these charts to auto update whenever there is new data in the excel sheet. I will have a few of these charts in the word file and then a whole bunch of summaries below them explaining the weekly data. So far the closest I have gotten to this is having to just copy and paste the charts in the same Word file. Since there would be a couple of these charts in the Word file it doesn't seem like the easiest way to go. I would like to not have to use VB code but if it's the only way then I would give it a try. Thanks!


Hi, I hope someone can help

I have created a very complex spreadsheet for designing some equipment and there are numerous outputs. I have then basically embedded a word document into the spreadsheet which is in effect a quote for the equipment that has been designed using the spreadsheet. I have then "linked" data from the spreadsheet into the embedded Word Document. As the spreadsheet design changes, so then does the quote. This seems to work quite well, however, there are possibly 150+ links into the word document, and having now completed half the links, I am getting insufficient memory errors and I suspect my "approach" is not the best way. Guidance on a more efficient approach would be most welcome.

My goal is to only have one document if I can help it, as I remain concerned that a seperate word and excel file, may lead to one getting lost [or the links broken]. The intention is that this excel file would be sent to thrid parties to design our equipment, and the idea was that they would never see the word file, but just have the option of "printing a quote" using a simple macro in Excel.

Many thanks in advance

Pete


I copied some Excel tables then pasted them as special -> linked Excel tables. Everything was fine, double clicking on a table opened the Excel file. I saved the Word and Excel file and now... I get this message about linked tables when I open the Word document, but double clicking on the table does nothing and I can't open the Excel file -- it just opens really quickly then closes itself.


I can copy and paste a Excel 2007 bar chart into a graphic software such as Photoshop, Paint and GIMP and save the file as a .PNG, .BMP or .JPEG and the file saves perfectly fine. However, when transferring the file into Word 2007 and Word 2000 the file looks like it degrades slightly and text appears to be quite poor. Is this an Excel problem, Word problem or something else.

Thanks.


Hi Again

If i want to search any word e.g. "gambaler" in the active sheet i just use Ctl + F button,

But now i want to find out this word from the other file (from C drive)

one way is to open each file and find it by Ctrl + F , but its too time consumibg as i have more than 100 files

Is there any VBA code which can show me the file name & file path in which this word is availble.


Good Morning,

I'm trying to stick an Excel table/spreadsheet into a Word 2007 file. Everything is perfect, however I cannot get the right border of the right-most column to display. No matter how skinny or wide I make that column, or how skinny or wide the entire table is, I cannot make the right border (skinny black line) visible in the Word file. When I got the Word file, the Excel object was already embedded, and I just needed to work within it, so I, myself, did not bring the original Excel object into the Word document.

Any ideas of how to resolve this??

Thanks in advace,
Chris


I am trying to export data from Excel to MS Word. What I have set up right now is a link from MS Word to Excel. This works well in that when I change the information the word files automatically update. The problem is this;

I need to save the information for each of the raw data. When I perform a "save as" word can no longer find that information and links to the master file. That is, I want Excel to push the information out of excel and into a file called {master word.doc} (for example). This will allow me to change the data after saving and still be able to print the documents without having to copy and paste all of the date back into my master document. Right now word imports the info from {master excel.xls} when I "save as"...my info is blank when I print my Word document.

My print macros work correctly...I save my excel file under a different name click the print button and the expected word document prints. Unfortunatly it contains the data from the ORIGINAL Excel file.

I am sorry if this is a bit confusing but can't think of another way to explain it.

Thanks in advance for any help.


I have a need to be able to create a Word document using an Excel VBA Macro. I need a pointer in the right direction on how to make this happen.

I want to create the word file.

Take the contents of cell A1 and write to the Word file, then take the contents of cell B2 and write it to the next line of the file.

From that point I can loop through my spreadsheet.

Then save and close the word file.

I'm good with writing the code to select the data, but how do I create a word document, then write the selection to the file.

I am using both Excel2003, and Excel2007 machines with this spreadsheet.

Thank you


First let me say thanks! I have recently begun to explore the wonders of Excel with great success (at least I think so) mostly due to advice found on this board.

That said I have run into a problem, which I'm sure has been addressed in other posts, but I have yet to develop enough savy to abstract an answer to my issue form other posts.....so......

I have linked tables created in Excel into a Word document. Everytime I update the Excel file the tables update beautifully in the Word document. However, I have been attempting to use bookmarks in the Word tables, to disperse the info to appropriate refs throughout the text of the document. Unfortunately, each time I update the Word document (tables) the bookmarks disappear.

Is there a way to correct this or another method for reachingthe same end?

Thanks in advance...


Hello everyone-
This may be more of a Word question than an Excel question, but I have created a document in Word that is comprised of several, rather large, tables. I have an excel file that includes over 600 records that includes fields I need to merge into the word file and basically do a data/mail merge to get 600+ individuals sheets for printing and distribution. I completely understand the entire idea of the mail merge, however, what I'm finding is that when I insert each mail merge field in my word document, my tables become completely distorted. I've even tried changing the headings in the excel file, but that doesn't seem to work as the tables are still distorted. It's making it really difficult to insert the fields. Does anyone know how to maintain the formatting of the tables in a word document when trying to merge with an excel file? Any help you could offer would be GREATLY appreciated. Thank you!!!

Meggan


I have a VBA procedure in an Excel file that briefly does some manipulation in Word. The idea is to create a memo using some of the key outputs of a spreadsheet model and permanently retain a copy of that memo.

I'm trying to do this by having the procedure open a Word doc with linked fields. On opening, Word should update its links. Then if I break the links and save the Word file as something else, the original word file is untouched. Then I should also be able to save the .xls as something else and not worry about Word changing the source files for its links.

That's the theory anyway, but I'm not sure that I can break the links in Word from Excel. Here's the code:

Code:

Set WordApp = CreateObject("Word.Application")
Set WordDoc = WordApp.Documents.Open(MemoFile)

 *** I would like to break the links in the Word file here *** 

On Error GoTo SaveErrorFix
WordDoc.SaveAs DocFullPath & ProposalDocName

WordApp.Quit
Set WordApp = Nothing





I HAVE FOLDER NAMED "TODAY". IN THAT I HAVE AN EXCEL FILE WHICH CONTAINS MACROS FOR CREATING PIVOT TABLE AND COPYING IT IN WORD FILE BY OPENING WORD APPLICATION. I WANT TO SAVE THIS WORD FILE AFTER COPYING IN THE CURRENT FOLDER.

FURTHER, WHENEVER THIS EXCEL FILE IS COPIED IN ANY OTHER FOLDER OR ANY OTHER COMPUTER THE MACROS SHOULD SAVE THE CREATED WORD FILE IN THAT FOLDER.

THE FOLLOWING MACROS WRITTEN IN EXCEL FOR SAVING NEWLY CREATED EXCEL FILE IN THE CURRENT FOLDER WORKS.
Code:

    ChDrive ThisWorkbook.Path
    ChDir ThisWorkbook.Path
        ActiveWorkbook.SaveAs Filename:= _
        ".\*.xls" _



LIKEWISE THE FOLLOWING MACROS WRITTEN IN WORD FILE FOR SAVING NEWLY CREATED WORD FILE WORKS.
Code:

    ChDrive ActiveDocument.Path
    ChangeFileOpenDirectory _
        ".\"
    ActiveDocument.SaveAs FileName:=".\*.doc", FileFormat:= _
        wdFormatDocument, LockComments:=False, Password:="", AddToRecentFiles:= _
        True, WritePassword:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:= _
        False, SaveNativePictureFormat:=False, SaveFormsData:=False, _
        SaveAsAOCELetter:=False



BUT THE MACROS CREATED IN EXCEL FOR CREATING WORD FILE AND SAVING THE WORD FILE DOES NOT WORK AND IT SAVES THE WORD FILE IN "MYDOCUMENTS".

WILL ANYBODY GIVE SOLUTION? THANKS


Hey my office is having a really big problem with Word and Excel. We issue reports (done in MS Word) that are accompanied by schedules (done in MS Excel).

For years, we've had a template file that was automatically linked so that anything we typed in Excel would automatically flow into Word. One of the people in our office opened up this template on their home computer that has Vista. Now it appears it became corrupted in someway.

When we open excel then word, we still get the message "this document contains links that may refer to other files. Do you want to update this document with the data from the linked files?"

When we click yes, it acts like its updating the links; however nothing changes. We can manually change the links by highlighting the entire word file and then right click update links. Does anyone know what we can do to fix this problem so that it goes back to auto update links?


I have a Windows 2003 domain with all win 2003 servers. My workstations are
windows 2000 with office xp installed. I have in the last week or so 3
different calls from users with the same problem. They created a spreadsheet
in excel with formulas and saved the file. When the went to open the file
again later on, the file was a word document, with a .doc extension. Word
opened the file fine of course without the formulas but if I try to open the
file in excel, excel tells me the file format is invalid. I then tried to
rename the extension to .xls, same error. Also tried opening the file in
word and saving as "filename.xls" and that didn't work.
Anyone have any clue as to what is going on? And more importantly is there
anyway of recovering the excel sheet?



I have created a rather extensive Excel program and I have also written a
"Users' Manual" in Word to help people using the program. I have been
working on trying to put a link in the Excel document to open up the Users'
Manual when it is clicked. This works well, except the link must be
re-created every time I put the program on a new computer. Is there any way
to attached the word file to the Excel file in a way that this link will not
break down when I put it on a new computer. One final note, the Word
document is 50 some pages long so it is not possible to simply put the text
in a worksheet, it needs to remain a Word file (or a PDF, I could do that
too) and have the two files linked.



Hello all. I'm hoping someone knows the answer to this.

I have an Excel file that links to a Word document. I want to create an Excel macro that will automatically execute when I open the Excel file. This macro will launch Word and open a specific Word file (so that both the Excel file and its related Word file are opened, ie. user doesn't have to manually open Word, then manually open the Word file).

Does anyone know how to do this?

Thanks in advance for any help.


Hello,

I have several users that access an excel file on the share drive. The admin needs to pull this .xls file into a .doc file and is successful by right clicking on the .xls file and going to open with Microsoft Word for Windows. She then saves the file in word on her desktop. When she right clicks on the newly saved .doc file and right clicks and goes to open with Microsoft Word for Windows, she gets the error that "file format is not valid". Is there a way to do this or is excel not able to read the .doc file even tho initially it was a .xls file? The .xls file has 1350 rows.

Thanks!


Is there an easy way to change all of the links in a Word document?

Let's say, I have a linked word document and an excel workbook that I set up as templates to use. I'll be entering data into tables in excel, and those tables are linked to the word document. Each time I start a new project, I'll be using a new word doc and excel book and need to change the name of each to correspond to the new project. The table format/structure in excel will be the same, but the data and file names/locations will change.

Is there an easy way to change the links in word to reflect the new name of the excel file, without having to manually change each link? I'm a relatively advanced (so I think) excel user, but have very limited VB knowledge.

If anyone knows of a way to make this work without resorting to creating macros, I'd appreciate it!