Linking Excel and Word Documents
For some reason, I can't figure out how to link a cell in a MS Word table to
a corresponding field in MS Excel, and the cell in Word update automatically
whenever I open that particular document, reflecting any changes in the
Excel file prior to that.
Is this even possible? How?
Office v. X
You're on the right track. Yes, it is possible, but it involves some work.
I think I should write a tutorial about this because a lot of questions
about linking have been coming up in the newsgroups.
There are several ways to accomplish your goal. I'll only descr...How do I save a file to PDF format in Word 2010
When I try to save the file in PDF format I get the message that the file is
being used by another user.
How do I save it to a PDF.file
Do you have Adobe Acrobat full version or just the reader? If you only have
the reader, you can't convert a document to pdf. If this is the case, you can
search the internet for some free software to do the conversions.
> When I try to save the file in PDF format I get the message that the file is
> being used by another user.
> How do I save it to a PDF.file
By chance, are you usin...Upload Word Document using VBA
I want to upload Word 2007 templates to an Access 2007 table using vba
against click event of a button. Later, I want to open a word document using
one of the selected templates on the Click event of another button. My
problem is I do not know how to upload and download the word document word
document using vba.
Can anyone help me please?
Haven't tried that yet for 2007, but used it a bunch when I had Office XP (I
think that was 2002). When I used it, it worked GREAT!!
If this information was h...Copying Excel 2007 Charts as picture into Word
Having a heck of a time trying to automate a process where we copy Excel 2007
charts and paste to a Word document as pictures. The code works and copies
all of the relevant ranges from Excel. But when pasting to Word the chart
disappears? Not a problem when the desired exhibit being pasted is all text
from Excel. But for some reason the chart object (and it doesn't matter what
kind of chart, line, bar, pie, etc.) won't copy over to the Word document.
Never had this problem in earlier versions of Excel. Always pasted charts
Copying out of Excel using:
objXL.Range...slipping text around linked Excel charts in Word
Hey guys :) I'm linking multiple charts from Excel into my thesis
(Word), and expect to need to edit text above and below these charts as
my thesis is revised. The problem I'm anticipating is that when I
delete text above a large chart, it often leaves an empty void if the
chart is too big to move up over the page break. What I would like is
to have some text below the chart move up (slip around the chart) to
fill this empty space. Pasting these charts in creates
plugs/roadblocks for the text to get stuck between. Is there a way
around this? Many thanks!!!
Which version... May n...Upgrade from 2004 to 2006
I've read a lot of articles in this group describing how you can't upgrade
between different localized versions of money.
My question is: How do I see what version my 2004 is?
First, where'd you buy it?
"Carsten Hoeck" <email@example.com> wrote in message
> I've read a lot of articles in this group describing how you can't upgrade
> between different localized versions of money.
> My question is: How do I see what version my 2004 is?
Post back what Help > About says re the vers...Keynote Speakers Announced for XML 2004
Keynote Speakers for XML 2004 Announced
Speakers Include Executives from IBM, Microsoft, DaimlerChrysler;
World's Largest XML Trade Conference Slated for Nov. 15-19
in Washington, D.C.
Alexandria, Va. August 17, 2004 - IDEAlliance, a leading industry association
dedicated to fostering XML and other information technology standards, today
announced the keynote speakers for XML Conference and Exposition 2004, being
held Nov. 15-19 at the Marriott Wardman Park Hotel in Washington, D.C. The
keynote presenters are:
" Michael Daconta, Metadata Program Man...Money 2004 #87
I use Money 2004 to do bill paying and receive cleared transactions from my
bank. It was working fine until this past Saturday. Now it seems to connect
to the bank but no transactions are downloaded. I checked online with my bank
and there are transactions available but they are not being downloaded
anymore. I called my online banking support number and they gave me some
steps to fix it but none did the job. Hope someone can help me. I'm using
Windows XP and IE 6.0. Thanks in advance.
In microsoft.public.money, Mandarina wrote:
>I use Money 2004 to do bill paying and receive cl...rpc-https ISA 2004 help
I have an exchange 2003 sp1 running on server 2003 and it reside inside a
perimeter network. It is a single server entity...it is it's own DC, CA,
Exchange, DNS, GC.
I have ISA 2004 running on server 2003 sitting in front of the perimeter and
internal networks. I have port 25 allowed in to the Exchange server and an
SSL tunnel allowed to the Exchange server.
client: Outlook 2003 (XP-SP2)
When I run outlook /rpcdiag from inside either the perimeter or internal it
connects via HTTPS, but resolves the external FQDN for exchange to the
If I run OWA Externally I am fir...Word 2007 centering all text
I am working on a document where I want certain sections centered (logo at
top, title of article, etc) but the rest to be standard right-alignment.
However when I select a certain section of text/image to be centered, it
centers everything in the document. It will allow certain sections to be
left-aligned or justified without affecting the rest of the document, but
centering affects everything. Please help.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.m...Copying contacts into Word
I have Outlook 2000 (and another PC with Outlook 2003 if this makes my problem easier).
Is there an quick way to get names, email addresses, postal addresses, etc of all contacts in each
Contact Groups (I think that's what they are called - the groups are in bold in the "Address Book"
I want to put them in Word tables (with a different table for each group). I can double-click on a
contact and copy each details into Word using copy and paste, but doing this for each contact in a
Contact Group (there are hundreds) isn't feasible.
If there's a way to cop...long filenames
Ok, I just wanted to try findfirst function because it
seems it takes care of long file names (which
CListBox::Dir doesn't). Do you know any solution to
retreive long file names?
If it works, what's wrong with this:
m_ListDirs.Dir(CFile::directory | 0x8000, "*.*");
for (int i = 0; i < m_ListDirs.GetCount(); ++i)
for (std::vector<...Export addresses from Word to Excel
How can I export addresses from Word to Excel so that the address lines stay in one cell
How does your data look in Word?
>How can I export addresses from Word to Excel so that
the address lines stay in one cell?
Dave Peterson posted the following advice to a similar question:
I do this:
Inside Word, select the table and do two Edit|Replaces.
First one replaces paragraph mark (^p) with a unique string ($$$)
second one replaces manual line break (^l) (l...how do i do my writing in microsoft word in columns
please because im doing a newspaper article for m homework and i dont know
how to put it in columns
From the Page Layout tab of the Ribbon, select Columns in the Page Setup
In versions of Word before 2007, from the Format menu, select Columns.
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"helpll" <firstname.lastname@example.org> wrote in message
news:F35B6521-2024-4BF7-A82E-5C174B1D27B3@microso...Disabling Word 2007 startup box
Is it possible to disable the Word 2007 startup box. I mean the first yellow
box that appears with the text 'Microsoft Office Word 2007'.
On Sat, 5 Dec 2009 09:46:02 -0800, Abi <Abi@discussions.microsoft.com>
>Is it possible to disable the Word 2007 startup box. I mean the first yellow
>box that appears with the text 'Microsoft Office Word 2007'.
Edit the desktop shortcut to add a space and the characters /q at the
end, after the closing quote mark:
"C:\Program Files\Microsoft Office\Office12\WINWORD.EXE" /q
For more things you c...Filename is locked for editing in Excel 2002 SP3
We have some spreadsheets on the network drive. Everytime myself or a
coworker at different times try to open the spreadsheet, we receive the
message "Filename is locked for editing". No one on the network has the file
open. Everyone has closed and turned their machines off, but I am still
unable to access the spreadsheet.
Can you let me know what I need to do to access the spreadsheet. We made
sure read-only is not checked in properties.
When this happens on a single user's pc, a common solution is to close excel and
to delete the files in the windows temp folder--and...Removing Routing From A Word Document! How? Thanks
How do you remove the routing from a Word document.
...Excel data to Word for Mail merge
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline; modification-date="Tue, 5 May 2008 05:45:46
Content-Ty...Import/Export Contacts with Microsoft Outlook to Money 2004 premium
I am trying to figure out how to use the new feature
that allows a user to Import/Export Contacts with
Microsoft Outlook through money 2004 premium
...Can MS Money SB 2004 handle more than one company?
I cannot find this information anywhere so I hope someone
here can share their experience. I have two completely
separate companies, each handled in separate Quickbooks
files. Personal finances are handled in Quicken. Of
course these three do not talk to each other so that any
transaction between any two of these entities has to be
entered twice, once in each file. Before I switch to
Money, can someone tell me whether Money can handle each
of these three entities separately (i.e., generate
separate tax information for each) yet still talk to each
other (e.g. have a debit in one ac...i want to swap text in one Word document?
I want to be able to use one document and insert two types of text, i.e., one
manual as Australian version and one manual as NZ version. Want to be able
to switch texts in the same document.
And your question is what?
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Anita." <Anita.@discussions.microsoft.com> wrote in message
>I want to be able to use one document and insert two types of text, i.e.,
> manual as Australian ...how do i extra data from excel into Word Document template
I have two columns in my spreadsheet:
*Name* and *amount due*:
I have 100 records of a *name of a person* and a*mount due for each*.
I wanna be able to Extract Each data from the spreadsheet
and put it into a general Word Document Template for example
Dear [name goes here],
Please advised that you have $[amount due] left and this should be
paid by the end of the month.
How do i go about extracting this data and just basically automating
the whole process?
-------------------------------------------------------------...Cannot link from Excel to Word using named ranges
After installing SP3 for Office 2003, our users can no longer paste named
ranges from Excel into a Word doc. The range is selected and named in Excel,
then copied. I switch to a Word doc and choose Paste Special, then "paste
link" as Microsoft Office Excel Worksheet Object. When I select OK, an error
appears --"Word cannot obtain the data for the Excel.Sheet.8 link."
If the range that I need copied in Excel is not named, then when cells are
added or deleted the entire contents that should be linked in Word will not
For instance, if the range A1:B7...User input a filename
I'm trying to a create a very simple MFC dialog box in Visual C++
6.0. I want to the user to input a file name, but I cannot figure out
how to go about doing that. I don't want them to write out the entire
path in a Edit Box, rather some sort of explorer that lets them
navigate to the file they want.
Any help would be greatly appreciated.
You can use the CFileDialog common control.
if (Dlg.DoModal() == IDOK)
//they selected a file.
<email@example.com> wrote in message
Is there a function that will let me calculate the rank of a word durin
data entry the same way the function rank(#) works on numbers?
why won't a simple sort work. It could be done automatically, if desired,
with each entry...
"MacScott >" <<MacScott.firstname.lastname@example.org> wrote in message
> Is there a function that will let me calculate the rank of a word during
> data en...