Copying XML data to Word
I have got an Excel XML spreadsheet which grabs data from Microsoft
CRM. I have set it up to have 5 different sheets.
I want to copy information from each of these sheets into Word, but for
some reason, only data from the first sheet is copied. When I try to
copy cells from other sheets, I get blank cells in Word.
Can anyone tell me why?
And even better, is there an automatic way to copy this stuff into a
Word template so I don't have to manually select the cells?
...OUTLOOK 2003 BUG: Tasks do not accept HTML messages
When dragging a message received in HTML over to the Tasks folder the
body of the message disappears.
Works for me. What is your setup?
Connected to Exchange? If so; are you using Cached Exchange mode?
If not; POP3, IMAP or other...? and are you using an Outlook 2003 pst-file
or an Outlook 97-2002 pst-file?
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tip of the month:
-Create your own fully customized Toolbar
Subscribe to the newsletter to receive news and tips & trick...Execute a variable as an insertion into a VBA code line
2003 & 2007
Is there a way to obtain, via Inputbox, to run the code line below:
X = "MyToolsObject." & Application.InputBox("VB.NET File to test: ", "ENTER PROCEDURE NAME")
Assume: X = "MyToolsObject.Test "
Effectively, how can I "Execute" X as if it were the codeline below?
Dim MyToolsObject As ToolsNET.Tools
Set MyToolsObject = New ToolsNET.Tools
MyToolsObject.Test ' <<<<< *********** ...Help with Ask fields in Word 2007
I have a word template that I have created. I am going to be distributing
this document internationally and don't want to have to manage change
controls on multiple documents.
Since we decided against using an Infopath form via forms services I had to
scale back on the functionality in a few areas such as repeating rows and
fields. That being said, I can't figure out how to accomplish something that
should be rather simple.
I need to ask the user to enter their region when the form template is first
opened, display it in the footer. I can't figure out how to on...Textbox on chart doesn't print in Office 2003, but does in 2007
I have some charts that I create through C# code on a "template" worksheet
and then copy it over to a new worksheet using the following code. When
looking at the chart.Shapes, I can see the three Textbox objects that I want
and these are the only shapes available. I can see them on the screen in
both Excel 2003 and 2007 correctly. When I print in 2003 though, the
textboxes don't appear like they do for 2007. Can anyone shed some light on
why this might be happening?
// Copy the images and charts (note index starts at 1)
for (int z = 1; z <= wsTemplate.Shapes.Count; ...Protect Worksheet but allow to insert or delete rows
I have set up a worksheet, locked and unlocked cells as needed and I want to
allow the user to insert and delete rows. But, when I set protection and
tick "Insert Rows" and tick "Delete Rows"; the menu only will allow "Insert
Rows", the "Delete Rows" field is not accessible.
Do you get an error message saying that you can't delete the row since there are
locked cells on that row?
I do when I protect a worksheet using your options and then rightclick on a row
number and choose delete. (And that row contains locked cells.)
Bob L Hill...Word 2007 auto complete words or phrases
I have several long words and phrases that I use frequently. Can I tell Word
2007 to auto complete them when I start to type them?
Yes, if you create AutoCorrect entries for them; see
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Lee Geer" <Lee Geer@discussions.microsoft.com> wrote in message
>I have several long words and phrases that I use frequently. Can I tell
> 200...How do I merge an Excel mailing List with Microsoft Word Document
I have columns or in the old DOS version "fields" where I have placed first
name, Last name, street address, City, State and Zip. In addition I have a
field for the Salutation which may contain more than one first name, i.e.
Mary and Joe.
I want to merge these individual rows in excel into a Word document.
For help on Word mail merge using Excel as the data source.
And a training tutorial for c...2 VBA Q
1. Cells(i, 9) = DateDiff(Cells(i,7), "12/31/2003", "m") -
gives me type mismatch error -
I need to check that the end date is before 12/31/2003 and
then calculate the number of months till the end of the
2. If (Cells(i, 7) = "Complete" & Sheets("Plan").Cells(i,
7) = "mm/dd/yyyy") - does not work.
It works for - If (Cells(i, 7) = "Complete")
However, I need to check - that there is a date in the
cells - Sheets("Plan").cells(i,7)
else I want to leave the original comment - "Complete".
di...Using Access w/Word Merge (Access 2002)
I inserted a column in a data table for expiration date. While writing a
merge letter where I wanted to insert that information I discovered it didn't
show up in the Merge Fields. Should I have instead renamed an existing
column (field) and moved it where I wanted it on the data table?
I deleted all extraneous column/fields, so I don't have an empty field to
utilize. Must I create a new database or is there a way to identify this new
column as a data field?
How are you getting the data into your merge document?
Query from Word, Access query, VBA?
"Helen" w...How to convert currency into words?
Can anyone advise how do I convert 1,223.35 to ONE THOUSAND TWO HUNDRED
TWENTY THREE DOLLARS AND THIRTY FIVE CENTS?
Would prefer to have a formula to do this, instead of via VBA.
there is no inbuilt function for this - you need to use an add-in or code
.... check out
"Derrick" <Derrick@discussions.microsoft.com> wrote in message
> Can anyone advise how do I convert 1,223.35 to ONE THOUSAND TWO HUNDRED
> TWEN...Using VBA to define the ControlSource property of an unbound field
I have a text field in a subform which should display a result based
on the user's selection in a combo box (cboEndDate) in the main form.
I've gotten the code written in a sub named daycalc(), but can't
figure out how to get the subform to recognize this code as its
controlsource. It's just simply blank. How do you get the field in
the subform to recognize the VBA as its controlsource? If you need
more details, I'm glad to provide them. I'm hoping that this is a
simple thing that I'm just overlooking.
Thanks, Steve. daycalc() is a sub. I do, however, have a...Word crashing when formatting bullets
Operating System: Mac OS X 10.5 (Leopard)
I wonder whether anyone can help me. I have been having more and more frequent crashes with Word when I try and format my bullets. It doesn't everytime I format my bullets.
Thanks in advance for any help rendered
...How to protect a column?
I would like to protect some hidden columns. When I choose
"protection" in the menu, I only find the possibility to define area to
be modifed but I would like to do the opposite: define which areas can�t
How can I do this?
xpucto's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23748
View this thread: http://www.excelforum.com/showthread.php?threadid=374127
Is there some kinf of options to protect all hidden columns? Or to
protect function...SUM in random files in the folder
I have files in the folder.
how I consolidate in new sheet all the files, to sum for region, products?
OBS: I not know the amount of files in this one folder, so I know that the
these nominated archives for region,
a994.xls region A,
b323.xls region B
How to create a look with filename random ? and I not know the quantity file
But, all the worksheets have format the same.
Necessary they to charts with it, then I want create the table consolidate
...how do i get rid of dots between words in outlook?
There are dots between every word in my Outlook messages. How do I get rid
of them? So far, I have searched every term I can in help... to no avail.
In Word, it's the Paragraphy feature, but I guess not in Outlook. Please
help! (outlook 2003)
it's the same in outlook. are you using word or outlook's editor as the
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook Tips: http://www.outlook-tip...Import Word document into existing Publisher document
Is there a way to import a Word document into an existing Publisher document?
I know how to do it by creating a NEW Publisher document. The cut-and-paste
method does NOT work--all the formatting is lost. Help, please
...how do i save a new address typed on an envelop in word 2003
i want to save the address i type on an envelop under the envelop and labels
Save it where? You could add the envelope to a document and save the
You could use an envelope template - see the link at the end of
http://www.gmayor.com/changing_envelope_layout.htm and create and save an
envelope document including the address.
You could save the address in Outlook and insert the address from the
addressbook function in the envelope/label dialog, which stores recent
addresses. To do this Outlook must be your default e-mail application.
<>...Excel 2003 - VBA
Does anyone out there have a good source for reference material (beginner
please) on the listbox function that would help with the following task.
I have created a 2 column, 50 row listbox, fed from a 2000 element table in
the spread sheet. Column one is the item number and column 2 is the name. I
also have 2 textbox fields where I can enter either the number or the name
and would like the listbox to scroll so that the matching item is displayed
in the center, or as close as possible, of the 50 row window.
I have found many sources of information on the listbox and have figured out
much of ...Restart heading numbering in each new section of a Word 2007 docum
I have produced a thesis of around 100,000 words in Word 2007 using docx
format (because I want to use automated TOC and Indexing).
My doucment is divided into sections (using section breaks), each comprising
a chapter with a Title. I have been using the outline headings provided in
Styles, using levels 1 through to 6. Presently the numbering runs on through
the sections which results in huge numbers, as you would imagine.
How do I make the heading numbers reset to 1 in each new section of the
First of all, although there may be other good reasons for using Word 2007,
When I click on Edit and drop down to Undo - Undo is grayed out. Any idea why?
Have you performed some action that can be undone? Note that protecting and
unprotecting a form clears the Undo stack (as of course also does closing
and reopening the document).
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Shels" <Shels@discussions.microsoft.com> wrote in message
> When I click on Edit and drop down to Undo - Undo is grayed out. Any idea
>...CTRL+Z Lock & Protects Worksheet
When I press CTRL+Z, instead of performing an "undo", all
cells in the worksheet become protected and an unknwon
password has been assigned. Has anyone else experienced
maybe a macro is assigned to this shortcut. check the macros in your
workbook or in your personal.xls file
> When I press CTRL+Z, instead of performing an "undo", all
> cells in the worksheet become protected and an unknwon
> password has been assigned. Has anyone else experienced
Thanks, Frank, I will check. ...SumProduct in VBA
I have the following macro:
engid =3D "'[Export January.xls]Export_January'!$aq$2:$aq$43735"
rev =3D "'[Export January.xls]Export_January'!$ag$2:$ag$43735"
engid2 =3D Sheets("actual").Range("H4").Value
If Not IsNumeric(engid2) Then
engid2 =3D """" & engid2 & """"
pct =3D Application.Evaluate("SUMPRODUCT(--(" & engid & "=3D" _
& engid2 & "),--(" & rev & "))")
ThisWorkbook.Worksheets(&q...Using radio button controls in a Word form
I'm creating forms for users to download from a website. The first form I
developed contained a drop-down list and numerous radio buttons from the
Controls toolbar, and works perfectly for everyone who has downloaded one.
And they open ok for me, i.e. NOT in design view, when they are e-mailed to
me by users.
The second one I'm developing is similar and has no drop-down list and only
3 radio buttons. But after downloading to my PC this second form
frustratingly opens in controls design view so the buttons don't work.
Why is this? How can one form work perfectly an...Word 2003: Section breaks & page formatting
I have a Word 2003 document with 5 sections. Sections 1,2,3 are in portrait.
Section 4 is in landscape. Section 5 returns to portrait. When doing a
print preview, all formatting appears to be correct. But when I print, the
1st page of Section 5 prints in a reduced font in landscape formatting. I
have looked at all page and print settings and can't seem to find where the
issue is located. I have tried removing section breaks and reinserting them.
Help! Any thoughts on what is causing this issue?
Are you tracking changes? Or are there comments in the document? In eithe...