Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Excel spreadsheet linked into a word doc a compound document?

I am working with compound documents and I am not sure if an external excel
spreadsheet linked into a word document can be a compound document. Why or
why not? Please explain because I am so lost.


Post your answer or comment

comments powered by Disqus
I'm trying to turn the info I have on a exel spreadsheet into a word doc, any
help?

Please email me at

I'm trying to turn the info I have on a exel spreadsheet into a word doc, any
help?

Please email me at cwinfree@lpbenergy.com

I have a excel spreadsheet linked to a word document. I can go to the last
record one at a time but cannot use the 'last record' feature as it returns
me to the first record.

The 'first record' feature works. Also the record I was on in a previous use
is still there when I return.

TIA

Hi all!

Someone here is using Excel 2003 and would like to create a hyperlink from a cell to a .doc file. When we try to create the hyperlink, we navigate to the directory that stores the .doc file, but Excel isn't letting us "see" the .doc files that are in the directory.

Is it possible to link a cell to a Word .doc? My co-worker could swear that she's done it before.

Thanks much!

[edit]
I see how to hyperlink to a file

=HYPERLINK("path to sample .doc on the desktop here")

but the hyperlink opens the directory instead of opening the file in Word. We'd like the file to open in Word, as she's seen before.

[end edit]

Hi,

I have an excel spreadsheet linked to a word document. The spreadsheet gets filled with appropriate numbers by running a macro, and then the word document is updated by the links. However, I want to save the word document as a unique file and break the links at the end of the macro (so it can't be updated with new numbers that go into the spreadsheet). I know how to save the word doc in the excel macro, but I can't figure out how to break the links. How can I do this?

There is something called Linkformat.breaklinks in Word, but I cannot figure out how to use it properly. I need to break all the links in the word doc, so it needs to loop through it somehow, check for links, and delete if it finds one.

Thanks for your time and help.

I am trying to get my VBA in a userform to copy the range a1:g5 from sheet 1 into a word document then copy range a1:d20 from sheet 2 and paste it as a new item in the word document after the first and i'm getting knoware fast, please please please could one of you kind people show me the method or failing that kick me hard.

I have the VBA open a word doc from a template and have sorted all the saving parts so its just the moving of the 2 bits of info i'm at a loss with.

thx in advance

I want to merge fields from an ascii file into a word document.
The ascii file has a word or phrase on each line. Each line will be a merged
field. There will be approx 20 lines to be merged into various places in the
document.
How do you set up the word doc to receive these fields?

Has anyone gone through or have been given the task to convert an excel
spreadsheet application into a Java or .Net version of it. Making it a
client/server application using a thin client approach. Any tools or any
words of wisdom to share would be greatly appreciated.

hi
i have posted in the word forum to import data from excel but i may be better off exporting to word so can anyone help to populate a word textbox from excel.

I will have a word doc as a template which will have various control tools that will be populated from excel cells on command

this is the post in the word forum
http://www.ozgrid.com/forum/showthread.php?t=49761

cheers
toe

I set up a hyperlink in Excel that points to a Word Doc, the only problem is
that is doesn't open up it up the same way as just double clicking on the
file itself or opening it up in Word.

How you ask?

Well, I have a large contact list and each file goes to a certain
pre-selected contact which is saved that way. When I open up the file from
within Word or double click the file itself, the recipient's name shows (the
email toolbar button is selected automatically), but when I click on the
Hyperlink in Excel, the Word doc opens up without the email button selected
by default and without the recipients name there. This forces me to then
click on the email button to bring this information up.

Anyone know of a way to have the email information automatically selected
when opening up a hyperlink in Excel to a Word doc?

Does Excel have a way of using shortcuts instead? Maybe a shorcut to a Word
Doc will open it in up the same way as Word will.

Thanks in advance.

I set up a hyperlink in Excel that points to a Word Doc, the only problem is that is doesn't open up it up the same way as just double clicking on the file itself or opening it up in Word.

How you ask?

Well, I have a large contact list and each file goes to a certain pre-selected contact which is saved that way. When I open up the file from within Word or double click the file itself, the recipient's name shows (the email toolbar button is selected automatically), but when I click on the Hyperlink in Excel, the Word doc opens up without the email button selected by default and without the recipients name there. This forces me to then click on the email button to bring this information up.

Anyone know of a way to have the email information automatically selected when opening up a hyperlink in Excel to a Word doc?

Does Excel have a way of using shortcuts instead? Maybe a shorcut to a Word Doc will open it in up the same way as Word will.

Thanks in advance.

I need to attach a word doc into a excel spreadsheet. I thought that I have
seen this done in the past, maybe not? Does anyone know who to do it?

Thanks

I have a worksheet with cells that contain about 200-3000 characters.
These cells are linked into a Word 2003 document using the

{LINK Excel.Sheet8 C:filename.xls SheetName!namedcell a r f 4}

syntax.

Problem is that my cells are getting truncated at nine
hundred-something characters or so. This does not seem exactly
consistent (I cut pasted text into new Word docs and one was 990
characters including blanks, another 992, another 933).

Does anyone know what the nature of this limit is (I read of a 256 char
limit in 2000 and ealier editions), and whether it can be
modified/worked around without massive redesign? (I've spent literally
about 5 months building this spreadsheet, I'd really rather not have to
start over again.)

Many thanks for any help/thoughts/suggestions.

I have a need to convert a Word doc with properly applied formatting styles
into a multi-column Excel spreadsheet.

I think that this processing would predetermine a format style, like Heading
1, as the row determinator, such that every time the conversion process
encountered content tagged with a Heading 1 format style, the converted
spreadsheet would begin a new row.

This process would then identify the various format styles utilized between
each Heading 1, and convert the content for those styles into the columns
associated with the row of the Heading 1 which they followed.

In other words, treating Excel as a database, the content tagged with a
Heading 1 format style would become the record key (in column A), and the
content associated with each format style following the first Heading 1 and
before the next Heading 1 would convert to become fields associated with the
first Heading 1 (in columns B, C, D, etc.).

I understand that this process would require a rigid application of format
styles, but that is the case for my situation.

I would appreciate any feedback on the topic. Does a vbscript exist for
such a task, or could one be written?

Thank you.

Apologies in advance folks- I've been searching all morning and have come close to what I think I'm looking for, but not exactly. Issue is, I'm not entirely certain I even have the terminology down, so please bear with me.

In simplest terms as I can put it:

I need to create a proposal template in Word 2007. Portions of the template will never change. The portions that DO change, either by their content or inclusion/exclusion in the document, I'd like to be "fed" by an Excel spreadsheet.

IE: I need to create the relationships between paragraph 'X' in the Word doc and cell 'X' in the spreadsheet, such that if it changes in Excel, you can generate the document based on those changes.

I know this may be a VB thing, an Access thing, an Excel and/or Word Merge thing, etc. and I've even hoped to stumble across software that would generate the appropriate linked docs, but no luck yet.

Any wisdom, even on the correct terms I should be looking for, would be so very much appreciated. Thanks much,

David

I have an organizational chart that I just did in Excel. I know there is a
way to convert the spreadsheet into a Word document, but I just can't
remember how. I did this a couple years ago and when the conversion happened
I only had a word doc, the excel doc was gone. Course I didn't save the
Excel doc to another file before I did this, so had to create a new one
(won't make that mistake again!).

So I have a large word document with about 100 links to one excel spread sheet and I want to change the source of all the links to a different excel spread sheet. As far as I know the only way I can do this is by going into each link in the word document seperately and changing the source which is very time consuming and kinda boring. Is there anyway to change all the links at once? I tried highlighting them all and changing the sourse but it still makes me to them one at a time. Can anyone help? Thanks guys.

I am trying to put together a calendar events list for my organization that
will be publicized in the local press. I have set up a web page that allows
folks to input specific information about their event which I can then
download to an Excel spreadsheet. From there I want to be able to import the
data (what, when, where, etc.) into a Word document. Copy and paste takes way
too much time and I don't know a thing about macros. How can I create one
Word template that includes data fields that links to specific cells in
Excel? Mail Merge would seem to be the obvious answer however I am not trying
to create several form letters, I am trying to create one document that lists
several different events. Any help in layman's terms is greatly appreciated!

I'm using office 2003.
I have an Excel spreadsheet that contains data that are mailmerged into
a word document. To simplify the process for others, I made an EXCEL
macro that flags the active row, launches the mailmerged word
document(which filters all except the flagged data), merges to a new
document (fixing merge fields), and then closes the original document.
Only the last step fails. This should be the simplest step, and I've
tried using quotes to no avail. What am I doing wrong?

Sub MakeReferral()
'save row number in holdrow variable
holdrow = Selection.Row
Cells(holdrow, 101).Value = 1
Dim oWord As Word.Application
Dim myDoc As Word.Document
Set oWord = CreateObject("word.application")
oWord.Application.Visible = True
Set myDoc =
oWord.Application.Documents.Open("p:aftercarereferral.doc")
With myDoc.ActiveWindow
With ActiveDocument.MailMerge
.Destination = wdSendToNewDocument
.SuppressBlankLines = True
With .DataSource
.FirstRecord =
ActiveDocument.MailMerge.DataSource.ActiveRecord
.LastRecord =
ActiveDocument.MailMerge.DataSource.ActiveRecord
End With
.Execute Pause:=False
End With
'close referral.doc
'*********************************************************************************
'this causes "runtime error '424'Object_required"
Windows(referral.doc).Close savechanges:=wdDoNotSaveChanges
End With
Set oWord = Nothing
'Clean up
Cells(holdrow, 101).Value = ""
End Sub

After yours success yesterday answering my post I've got a slightly harder one for you all.

I have got an excel document containing job requests for workers around the building. Is it possible for excel to copy the cell values automatically into a table within word to save typing things twice including dates etc.

The idea scenario would be for me to type all the info into excel then a word doc open be filled in automatically. It can then be printed off, given to the correct person then saved and filed.

Please remember I am reasonably new to excel but have already got the excel document how I need it, (thanks to this forum).

I have tried linking cells to tables using paste special but messed it up a few times.

Hoping you can help

Mike

I am trying to put together a calendar events list for my organization that
will be publicized in the local press. I have set up a web page that allows
folks to input specific information about their event which I can then
download to an Excel spreadsheet. From there I want to be able to import the
data (what, when, where, etc.) into a Word document. Copy and paste takes way
too much time and I don't know a thing about macros. How can I create one
Word template that includes data fields that links to specific cells in
Excel? Mail Merge would seem to be the obvious answer however I am not trying
to create several form letters, I am trying to create one document that lists
several different events. Any help in layman's terms is greatly appreciated!

I would like to copy word doc into an excel doc, rather than going into the
word doc each time and doing a copy/paste.... is I have done this with other
exel docs but not going through word.... any help would be much appreciated!

I currently have 2 files, 1 of which is a MS Excel spreadsheet and the other
a MS Word document.
I have a large range of cells in my spreadsheet that I would like to copy
into the MS Word document, but I'm having a few problems.
First of all, I do not want to do any linking from the Word doc to the Excel
spreadsheet. I want the Word doc to basically work by itself without having
to link to the spreadsheet.
I tried using the Paste Special option but that didn't work the way I would
have liked. The excel info gets copied fine, but then the info is converted
into a Table and all of my formulas do not work anymore.
So I was left with inserting an Object (Spreadsheet) in Word, then tried
copying the excel material. This worked up to a certain point, but
unfortunately the excel info exceeded more than 1 page in the ms word doc,
and it would cut off without going to the next page.
Any ideas?
Thanks

Hi everyone,
I've got a pair of files (xls + doc) where fields & graphs are linked into the word doc. The problem is I have the template files, but if I copy them to use for a report, the fields in the new word doc still link to the template file rather than it's own version of the spreadsheet.

The word doc and excel files will have the same name apart from the file extension... would it be possible to make the links in word dynamic? I haven't really explained it that well.. here's an example:

Currently I have template.xls and template.doc. If I make a copy of both and rename them reportA.xls and reportA.doc, the fields in reportA.doc still reference template.xls rather than reportA.xls.
Would it be possible to make links within the word doc such as [own filename without .doc].xls rather than just a static link to a specific file? I will have reportB, reportC etc. and I need each one to reference it's own excel spreadsheet.

If not is there any other way of dealing with this problem?

Thanks,
Adam


No luck finding an answer? You could always try Google.