<?xml version="1.0" ?><rss version="2.0" xmlns:ec="http://www.eggheadcafe.com"><channel><title>eggheadcafe.com Microsoft Word Unanswered Messageboard Posts</title><link>http://www.eggheadcafe.com</link><pubDate>Thu, 06 Jun 2013 08:00:33 GMT</pubDate><description>EggHeadCafe - The .NET developer's portal of choice</description><language>en-us</language><item><title><![CDATA[microsoft word has stopped working]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10474017/microsoft-word-has-stopped-working.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10474017/microsoft-word-has-stopped-working.aspx]]></link><description><![CDATA[<p>Source<br />
Microsoft Office Word</p>
<p>Summary<br />
Stopped working</p>
<p>Date<br />
&lrm;22/&lrm;05/&lrm;2013 14:23 PM</p>
<p>Status<br />
Report sent</p>
<p>Description<br />
Faulting Application Path:&nbsp;C:\Program Files\Microsoft Office\Office12\WINWORD.EXE</p>
<p>Problem signature<br />
Problem Event Name:&nbsp;APPCRASH<br />
Application Name:&nbsp;WINWORD.EXE<br />
Application Version:&nbsp;12.0.4518.1014<br />
Application Timestamp:&nbsp;45428028<br />
Fault Module Name:&nbsp;StackHash_cf5b<br />
Fault Module Version:&nbsp;6.1.7600.16385<br />
Fault Module Timestamp:&nbsp;4a5bdadb<br />
Exception Code:&nbsp;c0000374<br />
Exception Offset:&nbsp;000c283b<br />
OS Version:&nbsp;6.1.7600.2.0.0.768.3<br />
Locale ID:&nbsp;1033<br />
Additional Information 1:&nbsp;cf5b<br />
Additional Information 2:&nbsp;cf5bf56c10d891ecd6557c2dd101716c<br />
Additional Information 3:&nbsp;bef3<br />
Additional Information 4:&nbsp;bef3cd6574c986624d56149c52252308</p>
<p>Extra information about the problem<br />
Bucket ID:&nbsp;2676058056</p>&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10474017/microsoft-word-has-stopped-working.aspx" target="_self">read more</a>]]></description><pubDate>Wed, 29 May 2013 04:35:03 GMT</pubDate></item><item><title><![CDATA[DOC files issue in win 7]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10473413/doc-files-issue-in-win-7.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10473413/doc-files-issue-in-win-7.aspx]]></link><description><![CDATA[<span style="color: #222222; font-family: 'segoe ui', tahoma, arial, helvetica, sans-serif; line-height: 18.203125px; white-space: normal; background-color: #f0f3f4;">I have my notes related to programming in msword 3003 doc files. now after i installed win7,they are not opening what should i do ?I have installed office 2007 but doc file is not changed,apart from that i want to install 2010,before that i want to rectify my doc file issue</span>&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10473413/doc-files-issue-in-win-7.aspx" target="_self">read more</a>]]></description><pubDate>Sun, 21 Apr 2013 03:37:31 GMT</pubDate></item><item><title><![CDATA[Putting manual page breaks in ms word table]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10472788/putting-manual-page-breaks-in-ms-word-table.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10472788/putting-manual-page-breaks-in-ms-word-table.aspx]]></link><description><![CDATA[<p>Hi All,</p>
<p>&nbsp; This is a different question that I posted before. I want to get the page Break inside a table in MS word so I have <br />
a table in MS word, Inside the table, I have a text called PageBreak in one of the rows of the table. As soon as I see this word PageBreak,<br />
I want an actual PageBreak inside the table. I know how to achieve this if I don't have a table in Microsoft word by replacing the text with ^m, but I am having problem with page break inside the table.<br />
&nbsp;I want to write this in a macro. </p>
<p>How can I acheive this.</p>
<p>Any help will be greatly appreciated.</p>&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10472788/putting-manual-page-breaks-in-ms-word-table.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 14 Mar 2013 17:38:31 GMT</pubDate></item><item><title><![CDATA[Inserting manual page breaks in ms word document]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10472773/inserting-manual-page-breaks-in-ms-word-document.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10472773/inserting-manual-page-breaks-in-ms-word-document.aspx]]></link><description><![CDATA[<p >Hi All,</p>
<p>&nbsp;&nbsp; I am trying to replace the page Break word in MS word document with actual PAGE Break so I wrote the macro below, but I am not getting the <br />
desired results. I tried putting false instead of true for&nbsp; .MatchWildCards=True, but that didn't work either. I just want to do page break <br />
wherever I see the word -- PAGE Break -- in my MS word document.</p>
<p>&nbsp;</p>
<p >With Selection.Find<br />
&nbsp;&nbsp;&nbsp; .Text = "-- PAGE Break --"<br />
&nbsp;&nbsp;&nbsp; .Replacement.Text ="^m"<br />
&nbsp;&nbsp;&nbsp; .Forward=True<br />
&nbsp;&nbsp;&nbsp; .Wrap = wdFindContinue<br />
&nbsp;&nbsp;&nbsp; .Format = False<br />
&nbsp;&nbsp;&nbsp; .MatchCase=False<br />
&nbsp;&nbsp;&nbsp; .MatchWholeWord= False<br />
&nbsp;&nbsp;&nbsp; .MatchWildCards=True<br />
&nbsp;&nbsp;&nbsp; .MatchSoundsLike=False<br />
&nbsp;&nbsp;&nbsp; .MatchAllWordForms=False<br />
END WITH</p>
<p >I spend lot of time figuring this out, but it seem that inserting page break through Macro is not working. I am using Office 2007(MS word 2007)</p>
<p >Any help will be grealy appreciated.</p>&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10472773/inserting-manual-page-breaks-in-ms-word-document.aspx" target="_self">read more</a>]]></description><pubDate>Wed, 13 Mar 2013 18:07:11 GMT</pubDate></item><item><title><![CDATA[Set &lt;br&gt; tag for each line ending in ms.word 2007]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10472496/set-ltbrgt-tag-for-each-line-ending-in-msword-2007.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10472496/set-ltbrgt-tag-for-each-line-ending-in-msword-2007.aspx]]></link><description><![CDATA[i have 50lines in my ms.word2007 i want to set this <strong>&lt;br&gt;</strong> for each line ending how will i do that ?&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10472496/set-ltbrgt-tag-for-each-line-ending-in-msword-2007.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Feb 2013 00:18:55 GMT</pubDate></item><item><title><![CDATA[Outlook 2007 send messages do not show in send file]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10472186/outlook-2007-send-messages-do-not-show-in-send-file.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10472186/outlook-2007-send-messages-do-not-show-in-send-file.aspx]]></link><description><![CDATA[<span>&nbsp;
<p style="margin: 0in 0in 10pt;"><span>The messaging interface has returned an unknown error.w</span></p>
</span>&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10472186/outlook-2007-send-messages-do-not-show-in-send-file.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:01:12 GMT</pubDate></item><item><title><![CDATA[How do I change the Header to reflect CHAPTER TWO of a book? The whole document changes!]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10471031/how-do-i-change-the-header-to-reflect-chapter-two-of-a-book-the-whole-document-changes.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10471031/how-do-i-change-the-header-to-reflect-chapter-two-of-a-book-the-whole-document-changes.aspx]]></link><description><![CDATA[I'm writing a book and put in a header "Chapter One on the first 5 pages, then did a page break, starting a new chapter, Chapter 2.&nbsp; I can't change the header - the whole book says Chapter One....&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10471031/how-do-i-change-the-header-to-reflect-chapter-two-of-a-book-the-whole-document-changes.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:01:12 GMT</pubDate></item><item><title><![CDATA[Get shape to stay within selected cell on a table]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10470924/get-shape-to-stay-within-selected-cell-on-a-table.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10470924/get-shape-to-stay-within-selected-cell-on-a-table.aspx]]></link><description><![CDATA[Hi guys!<br />
<br />
Got an annoying problem with some code.<br />
<br />
I have a form field in a cell within a table that runs some code to add a shape into&nbsp;its cell once clicked.<br />
<br />
The problem is, when the shape is added, it doesn't always stay within the cell. It can sometimes be outside in an adjacent cell above or below.<br />
<br />
Here's the code:<br />
<br />
'Set Rng as current cell<br />
&nbsp;&nbsp;&nbsp; Set Rng = Selection.Range<br />
<br />
'Are there any shapes in the current cell, if so delete. Causes error 5852 if no shapes in ShapeRange<br />
&nbsp;&nbsp;&nbsp; If Rng.ShapeRange.Count &lt;&gt; 0 Then Rng.ShapeRange.Delete<br />
<br />
'Get the height and width of the selected cell<br />
&nbsp;&nbsp;&nbsp; With Rng.Cells.Item(1)<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; oShpWidth = .Width - 12 '-12 as don't want to fill the entire width<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; oShpHeight = .Height / 3 ' by 3 as don't want to fill entire height<br />
&nbsp;&nbsp;&nbsp; End With<br />
<br />
'Add shape and position<br />
&nbsp;&nbsp;Set Shp = myDocument.Shapes.AddShape(msoShapeFlowchartMagneticDisk, 0.5, 10, oShpWidth, oShpHeight, Rng)<br />
<br />
<br />
Any thoughts?<br />
<br />
Thanks<br />
<br />
Pete&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10470924/get-shape-to-stay-within-selected-cell-on-a-table.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:01:12 GMT</pubDate></item><item><title><![CDATA[Has anyone tested if VBA 6.5 macros in Word 2003 run without glitches under Windows 8]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10470829/has-anyone-tested-if-vba-65-macros-in-word-2003-run-without-glitches-under-windows-8.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10470829/has-anyone-tested-if-vba-65-macros-in-word-2003-run-without-glitches-under-windows-8.aspx]]></link><description><![CDATA[I have Windows 7 Toshiba&nbsp;laptop,&nbsp;new August 2012,&nbsp;that is Windows 8 compatible, and came with a special upgrade deal.<br />
<br />
MicroSoft say that Office 2003 is not compatible with Windows 8. This is a change from their pre-release statement. However, online comments indicate that if you ignore the messages that pop up during installation, Office 2003 works fine. Mostly, I run Word 2003, and occasionally Excel, but I have a host of sophisticated macros running in Word 2003 / VBA 6.5. Has anyone tested whether VBA 6.5 macros for Word 2003 work without glitches under Windows 8?<br />
<br sab="257" />
Thanks<br sab="258" />
<br sab="259" />
John Davidson<br sab="260" />&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10470829/has-anyone-tested-if-vba-65-macros-in-word-2003-run-without-glitches-under-windows-8.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:01:12 GMT</pubDate></item><item><title><![CDATA[writing a macro to insert page breaks]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10470665/writing-a-macro-to-insert-page-breaks.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10470665/writing-a-macro-to-insert-page-breaks.aspx]]></link><description><![CDATA[Hi All,<br>
</br><br>
</br>I want to write a macro in MS word that insert page break in the ms word document where ever there is a sentence called <br>
</br>----PAGE BREAK--- in the word document<br>
</br><br>
</br>I have around 200 page word document where there are at least 100 PAGE BREAK sentences in the document. I want the macro that inserts the page break wherever the PAGE BREAK sentence is seen.<br>
</br>&nbsp;Also, I want to write "THIS IS A DRAFT DOCUMENT" as the HEADER and FOOTER&nbsp;for the entire document. <br>
</br><br>
</br>any help will be greatly appreciated.<br>
</br><br>
</br>&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10470665/writing-a-macro-to-insert-page-breaks.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:01:14 GMT</pubDate></item><item><title><![CDATA[The global template normal.dotm is already open as an add in program word 2007]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10470461/the-global-template-normaldotm-is-already-open-as-an-add-in-program-word-2007.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10470461/the-global-template-normaldotm-is-already-open-as-an-add-in-program-word-2007.aspx]]></link><description><![CDATA[When I go to start word the above message pops up every time.&nbsp; The global template normal.dotm is already open as an add in program.&nbsp; I am pretty much stupid when it comes to the details of any of the Microsoft Office programs, so if someone has an answer for this please be detailed about how to fix it.&nbsp; I have read in the other forums about the startup folder for word and I have looked, but have no idea where it is.&nbsp; I am using windows 8 pro, and Microsoft Office 2007.&nbsp; Please help.&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10470461/the-global-template-normaldotm-is-already-open-as-an-add-in-program-word-2007.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:01:15 GMT</pubDate></item><item><title><![CDATA[Work through a series of open documents using VBA]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10470388/work-through-a-series-of-open-documents-using-vba.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10470388/work-through-a-series-of-open-documents-using-vba.aspx]]></link><description><![CDATA[I have a macro and a user form in the normal template. The macro is as follows:<br />
Sub ProcessDocuments()<br />
Do<br />
UserForm1.Show<br />
Loop Until Application.Documents.Count = 0<br />
End Sub<br />
<br />
The user form code is:<br />
Private Sub CommandButton1_Click()<br />
Selection.TypeText Text:=TextBox1.Text<br />
Unload Me<br />
ActiveDocument.ActiveWindow.WindowState = wdWindowStateMinimize<br />
Application.ActiveWindow.Activate<br />
End Sub<br />
<br />
What I am trying to do is work through a series of open documents, so once I have added text from the user form to one document, the document is minimised and the next document becomes the active document. As it is, each time I click the command button, it adds text to the same document, even though it is minimised. If I insert ActiveDocument.Close, the code runs fine and goes through all the documents I have open, but I don't want to do that as I need to keep the documents open. I have searched and searched, but can't find anything on this. I can't refer to the documents by name as they will vary.&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10470388/work-through-a-series-of-open-documents-using-vba.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:01:15 GMT</pubDate></item><item><title><![CDATA[When the data from excel sheet converted into mail merged document then some fields appears into diff. fonts. How 2 maintain d same font or hw 2 change d fonts of these merged fields? Pls guide.]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10470125/when-the-data-from-excel-sheet-converted-into-mail-merged-document-then-some-fields-appears-into-diff-fonts-how-2-maintain-d-same-font-or-hw-2-change-d-fonts-of-these-merged-fields-pls-guide.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10470125/when-the-data-from-excel-sheet-converted-into-mail-merged-document-then-some-fields-appears-into-diff-fonts-how-2-maintain-d-same-font-or-hw-2-change-d-fonts-of-these-merged-fields-pls-guide.aspx]]></link><description><![CDATA[&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10470125/when-the-data-from-excel-sheet-converted-into-mail-merged-document-then-some-fields-appears-into-diff-fonts-how-2-maintain-d-same-font-or-hw-2-change-d-fonts-of-these-merged-fields-pls-guide.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:01:16 GMT</pubDate></item><item><title><![CDATA[How can I remove an unwanted paragraph break that appears in the middle of a footnote?]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10469918/how-can-i-remove-an-unwanted-paragraph-break-that-appears-in-the-middle-of-a-footnote.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10469918/how-can-i-remove-an-unwanted-paragraph-break-that-appears-in-the-middle-of-a-footnote.aspx]]></link><description><![CDATA[<span style="font-family: &quot;arial&quot;,&quot;sans-serif&quot;; font-size: 12pt; mso-fareast-font-family: calibri; mso-fareast-theme-font: minor-latin; mso-ansi-language: en-us; mso-fareast-language: en-us; mso-bidi-language: ar-sa;">I&rsquo;m having a problem with the footnotes in a Word document that happens to contain 40 pages of a &nbsp;book chapter that I&rsquo;m still writing. For some reason Word suddenly started inserting paragraph breaks between the notes and the footnote separator line a few days ago.&nbsp; I went to Word Help and figured out how to fix this &ndash; going into draft mode, clicking on show footnotes and then show footnote separator and manually taking out the unwanted paragraph break marks.&nbsp; All was well for a couple of days. Then, suddenly, today, a paragraph break appeared in the middle of one footnote.&nbsp; It appears underneath the footnote separator line -- just as before, but only on one page, in a footnote that starts on one pages and continues on another. &nbsp;I can&rsquo;t fix it using the above process.&nbsp;&nbsp; </span>&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10469918/how-can-i-remove-an-unwanted-paragraph-break-that-appears-in-the-middle-of-a-footnote.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:01:17 GMT</pubDate></item><item><title><![CDATA[Changing the active document in a series of open documents]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10469917/changing-the-active-document-in-a-series-of-open-documents.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10469917/changing-the-active-document-in-a-series-of-open-documents.aspx]]></link><description><![CDATA[I have a user form stored in the normal template. I want to use this to edit each document in a variable&nbsp;group of&nbsp;documents I have open. So basically, I make the changes and the document saves (I can do this bit fine), and then the active document is minimised, and the next open document becomes the active document. I get the minimise bit, but the minimised document remains the active document. I can't identify the next document by name, as this will be variable.&nbsp;<br />
I can use the user form fine if after making the changes and saving I then close the active document- but this is not what I want to do- I need to go through each document and keep them all open.&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10469917/changing-the-active-document-in-a-series-of-open-documents.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:01:17 GMT</pubDate></item><item><title><![CDATA[In a mail merge, I want to skip fields that are blank.]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10469828/in-a-mail-merge-i-want-to-skip-fields-that-are-blank.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10469828/in-a-mail-merge-i-want-to-skip-fields-that-are-blank.aspx]]></link><description><![CDATA[&nbsp;I cannot find a way to do if..then..else. &nbsp;I am using word 2007 with XP. &nbsp;If there is a simpler way than programming, I would like to know that also.&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10469828/in-a-mail-merge-i-want-to-skip-fields-that-are-blank.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:01:18 GMT</pubDate></item><item><title><![CDATA[Microsoft Office 2007 'freezes' when using 'save as']]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10468786/microsoft-office-2007-freezes-when-using-save-as.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10468786/microsoft-office-2007-freezes-when-using-save-as.aspx]]></link><description><![CDATA[Using&nbsp;'save as' in MS Ofc 2007 hangs up computer. I've tried deleting, per MS instructions,&nbsp;in the registry but this does not solve the problem.&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10468786/microsoft-office-2007-freezes-when-using-save-as.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:01:18 GMT</pubDate></item><item><title><![CDATA[How do you force uppercase for a drop-down box without selecting all caps?]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10468692/how-do-you-force-uppercase-for-a-dropdown-box-without-selecting-all-caps.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10468692/how-do-you-force-uppercase-for-a-dropdown-box-without-selecting-all-caps.aspx]]></link><description><![CDATA[I have a form-fill document that requires a name to be in all caps. Not a problem, my drop-down can contain all caps. However, I need to reference this field using the cross reference. Is it possible to have the field not in caps so I can referenced it, but still have it print in all caps?<br />
<br />
I've tried changing the font to be "all caps" but that is not honored. Is there a switch that would force it to be caps?&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10468692/how-do-you-force-uppercase-for-a-dropdown-box-without-selecting-all-caps.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:01:18 GMT</pubDate></item><item><title><![CDATA[No Ruby-text for chinese characters available?]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10468564/no-rubytext-for-chinese-characters-available.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10468564/no-rubytext-for-chinese-characters-available.aspx]]></link><description><![CDATA[I use Win7, Word10, and I only mananage to add Ruby manually, I didn't find a way to add it automatically like in Word07&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10468564/no-rubytext-for-chinese-characters-available.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:01:20 GMT</pubDate></item><item><title><![CDATA[i have Word 07.  I combined two documents and now my type is all in red and underlined.  ,]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10468128/i-have-word-07--i-combined-two-documents-and-now-my-type-is-all-in-red-and-underlined--.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10468128/i-have-word-07--i-combined-two-documents-and-now-my-type-is-all-in-red-and-underlined--.aspx]]></link><description><![CDATA[IWhen I combined 2 documents, all the type turned red and underlined.&nbsp; Like a dummy, I hit save and now I cannot undo it.&nbsp; There are also extra margins&nbsp; called the mark-up area showing the formatting, font, etc.&nbsp; When I try to open a new Word document, it does the same thing.&nbsp; How do I get rid of this?<br>
</br>
<br>
</br>&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10468128/i-have-word-07--i-combined-two-documents-and-now-my-type-is-all-in-red-and-underlined--.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:01:23 GMT</pubDate></item><item><title><![CDATA[word inster pic scan pro]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10467402/word-inster-pic-scan-pro.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10467402/word-inster-pic-scan-pro.aspx]]></link><description><![CDATA[&nbsp;hi all.<br />
<br />
&nbsp;
<p style="margin: 0in 0in 10pt;"><span style="font-family: calibri;">I am using 2007 word file in word we insert scanner doc with shortcut key &nbsp;alt+ips, now I want to know the manual option in toll bar</span></p>
<br />
<br />
<br />
thanks <br />
<br />
usha&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10467402/word-inster-pic-scan-pro.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:01:53 GMT</pubDate></item><item><title><![CDATA[Word Addin problem: Unable to add comment to a content control]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10467062/word-addin-problem-unable-to-add-comment-to-a-content-control.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10467062/word-addin-problem-unable-to-add-comment-to-a-content-control.aspx]]></link><description><![CDATA[I need to add comments to a content control based on some condition. I have tried the below 2 approaches.<br />
<span style="font-family: consolas; color: #0000ff; font-size: 13px;">
<p>1. <br />
this</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</span>
<p><span style="font-family: consolas; font-size: 13px;">.Application.ActiveDocument.Comments.Add(</span><span style="font-family: consolas; color: #0000ff; font-size: 13px;">this</span><span style="font-family: consolas; font-size: 13px;">.Application.Selection.Range, </span><span style="font-family: consolas; color: #a31515; font-size: 13px;">"XXX property was&nbsp;modified"</span>);//This works but the comment goes to selection focus, which is obvious. I tried to select my content control so that this line would add the comment to content control. What I get is "This Command is not available"<br />
<br />
2. Below line gives the same "this Command is not available" COM Exception.</p>
<p>&nbsp;</p>
<p>control.Range.Comments.Add(control.Range, "My comment");<br />
<br />
Please help.</p>&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10467062/word-addin-problem-unable-to-add-comment-to-a-content-control.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:01:55 GMT</pubDate></item><item><title><![CDATA[Why does the down arrow get "stuck inside a graph" when scrolling through a document]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10467011/why-does-the-down-arrow-get-stuck-inside-a-graph-when-scrolling-through-a-document.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10467011/why-does-the-down-arrow-get-stuck-inside-a-graph-when-scrolling-through-a-document.aspx]]></link><description><![CDATA[<p style="margin: 0in 0in 10pt;"><span style="font-family: calibri;">Using the up and down arrow keys to move line-by-line through a document, if I encounter a graph, the arrow keys goes inside the graph and then cycles through all the options in the graph and will cycle forever. The only way to exit the graph is to use page-up or page-down, or to click with the mouse outside the graph. My company jumped from Word 2003 directly to Word 2010, so I don't know if this "functionality" (to be read with a derisive tone!) is new to Word 2010 or if it existed in Word 2007, but either way, it seems a ridiculous way to have it behave. Is there an option to change this, or am I stuck with this "improvement"? Having to use the page-down and then work my way back up to where I really want to be is a hassle, and the mouse is a total productivity killer and I use it only when absolutely forced to, and even then, reluctantly.</span></p>&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10467011/why-does-the-down-arrow-get-stuck-inside-a-graph-when-scrolling-through-a-document.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:01:56 GMT</pubDate></item><item><title><![CDATA[Macro to print from one bookmark to the next]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10466417/macro-to-print-from-one-bookmark-to-the-next.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10466417/macro-to-print-from-one-bookmark-to-the-next.aspx]]></link><description><![CDATA[I need a macro that will print from one bookmark to the next multiple times. So it will print from Bookmark1 to Bookmark2 then from Bookmark4 to Bookmark5 and from Bookmark8 to Bookmark9. I want it to print into one document. I originally tried to define sections and have it print the sections but couldn't get it to work.<br />&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10466417/macro-to-print-from-one-bookmark-to-the-next.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:01:57 GMT</pubDate></item><item><title><![CDATA[Need macro to insert text (with text fields and tables) based on a user clicking check box]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10465753/need-macro-to-insert-text-with-text-fields-and-tables-based-on-a-user-clicking-check-box.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10465753/need-macro-to-insert-text-with-text-fields-and-tables-based-on-a-user-clicking-check-box.aspx]]></link><description><![CDATA[I have this code so far:<br />
<p>Private Sub CheckBox195_Click()<br />
If ActiveDocument.CheckBox195.Value = True Then<br />
Selection.GoTo What:=wdGoToBookmark, Name:="EmpGoal"<br />
Selection.InsertAfter "If yes, what type of work?&nbsp;&nbsp;&nbsp; "<br />
End If</p>
<p>End Sub</p>
<br />
The problem is I want it to insert an underlined text field following the question mark for the user to fill in and it will not paste into the code. In addition, the next block of the document I want&nbsp;inserted if the user clicks on the next check box is a page long and included multiple text fields and tables.&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10465753/need-macro-to-insert-text-with-text-fields-and-tables-based-on-a-user-clicking-check-box.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:02:00 GMT</pubDate></item><item><title><![CDATA[Dropdown combo box list values in color]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10465506/dropdown-combo-box-list-values-in-color.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10465506/dropdown-combo-box-list-values-in-color.aspx]]></link><description><![CDATA[Hi <br />
Wondering if it's possible to show dropdown list values in color ie say if the dropdown list has high, medium and low - the high value shows&nbsp;as green, medium&nbsp;as yellow, and low as red. Also,&nbsp;if the user select any value it should save in the&nbsp;cooresponding color. I have created the dropdown using activex control.&nbsp;<br />
Any help will be highly appreciated. <br />
Thanks, <br />&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10465506/dropdown-combo-box-list-values-in-color.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:02:01 GMT</pubDate></item><item><title><![CDATA[values for ActiveX dropdown combo in Word]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10465353/values-for-activex-dropdown-combo-in-word.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10465353/values-for-activex-dropdown-combo-in-word.aspx]]></link><description><![CDATA[Hi there!<br />
<br />
Wondering if anyone help me regarding populating values for different dropdown boxes which are inserted as ActiveX controls. I want to be able to use the dropdown to show different values from which users could pick up one value. I am relatively new to this technology so any walkthrough will be much appreciated. <br />
Thanks in advance. <br />
Shoro&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10465353/values-for-activex-dropdown-combo-in-word.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:02:03 GMT</pubDate></item><item><title><![CDATA[Find a word in word document by IGNORING Carriage return (^13 / ^10)]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10465153/find-a-word-in-word-document-by-ignoring-carriage-return-13--10.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10465153/find-a-word-in-word-document-by-ignoring-carriage-return-13--10.aspx]]></link><description><![CDATA[Hi<br />
&nbsp;I'm looking for a Vba to find a specific text in Ms. Word document ignoring Carriage return or Line feed. Words simple Find option (Ctrl + F) finds a word but if a word is separated by a line feed or carriage return, word doesn't find that.&nbsp; There is a option to Ignore white spaces &amp; Punctuation characters but not Carriage return or Line feed. For clear understanding of my query please see the below example<br />
<br />
&nbsp;<span style="color: #ff0000;"><strong>I'm trying to find <span style="color: #7030a0;">Professional</span> word</strong></span><br />
<br />
&nbsp;<strong>word finds :</strong> <span style="background-color: #f2dcdb;">Professional</span> Level<br />
<br />
<strong>&nbsp;word doesn't find :</strong> <span style="background-color: #fdeada;">Profe</span><br style="background-color: #fdeada;" />
<span style="background-color: #fdeada;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ssional</span> Level<br />
<br />
&nbsp;Replacement of Carriage return or Line feed is possible but I can not do that as that will mess my documents appearance.<br />
<br />
&nbsp;Thanks&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10465153/find-a-word-in-word-document-by-ignoring-carriage-return-13--10.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:02:07 GMT</pubDate></item><item><title><![CDATA[VBA Code to determine who  has file open ?]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10464174/vba-code-to-determine-who--has-file-open-.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10464174/vba-code-to-determine-who--has-file-open-.aspx]]></link><description><![CDATA[&nbsp;I&nbsp; have &nbsp;a shared&nbsp; ms word document . Sometimes&nbsp; the document is accessible in read-only situation. I am searching a <br />
VBA Code to determine who &nbsp;has file open.<br />
<br />
Best regards <br />&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10464174/vba-code-to-determine-who--has-file-open-.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:02:41 GMT</pubDate></item><item><title><![CDATA[Why does spell-check not check grammar on an unprotected form?]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10463546/why-does-spellcheck-not-check-grammar-on-an-unprotected-form.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10463546/why-does-spellcheck-not-check-grammar-on-an-unprotected-form.aspx]]></link><description><![CDATA[Whether I use VBA code, or run manually, spell check does not check grammar of text in a form field (unprotected document)- standard text has both spelling and grammar checked, and I have used code to set grammar to be checked with spelling, but to no avail with form fields.&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10463546/why-does-spellcheck-not-check-grammar-on-an-unprotected-form.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:02:45 GMT</pubDate></item><item><title><![CDATA[if..then..else text is not printing into the document in Word 2010 -. What can I do]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10463485/ifthenelse-text-is-not-printing-into-the-document-in-word-2010--what-can-i-do.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10463485/ifthenelse-text-is-not-printing-into-the-document-in-word-2010--what-can-i-do.aspx]]></link><description><![CDATA[&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10463485/ifthenelse-text-is-not-printing-into-the-document-in-word-2010--what-can-i-do.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:02:45 GMT</pubDate></item><item><title><![CDATA[Spell Check not working for UK English in word macro]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10463437/spell-check-not-working-for-uk-english-in-word-macro.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10463437/spell-check-not-working-for-uk-english-in-word-macro.aspx]]></link><description><![CDATA[Hi,<br />
<br />
Spell check not working for UK english in word macro. Please help me to resolve the issue.<br />
<br />
Code is given below<br />
<br />
<br />
arrData = Split(Replace(frmSectionB.txtBody.Text, ".", " "))<br />
For intCount = 0 To UBound(arrData)<br />
If Left(arrData(intCount), 1) &lt;&gt; vbCrLf And Left(arrData(intCount), 1) &lt;&gt; "." Then<br />
<br />
<br />
blnTemp = Application.CheckSpelling(arrData(intCount), "CUSTOM.DIC")<br />
If blnTemp = False Then<br />
txtBody.SelStart = InStr(1, Replace(frmSectionB.txtBody.Text, ".", " "), " " &amp; arrData(intCount) &amp; " ", vbTextCompare)<br />
MsgBox "Incorrect spelling", , arrData(intCount)<br />
txtBody.SetFocus<br />
Exit Sub<br />
End If<br />
End If<br />
Next<br />
<br />
<br />
Advance Thanks<br />
<br />
<br />&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10463437/spell-check-not-working-for-uk-english-in-word-macro.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:02:45 GMT</pubDate></item><item><title><![CDATA[Creating programmed template in word]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10453507/creating-programmed-template-in-word.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10453507/creating-programmed-template-in-word.aspx]]></link><description><![CDATA[Hi, I have to make this template in word wherein the user has the option to select, what data he wants in the template (through a checkbox kind of UI). The data is contained in a word file. The data can be table, paragraph. How do I implement this in word ? Please help.&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10453507/creating-programmed-template-in-word.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:05:07 GMT</pubDate></item><item><title><![CDATA[security  taskpane]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10419684/security--taskpane.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10419684/security--taskpane.aspx]]></link><description><![CDATA[&nbsp;I have&nbsp;this&nbsp; piece of&nbsp; VBA code <br />
<br />
&nbsp;If Err.Number &lt;&gt; 0 Then<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MsgBox "this procedure doesn't continue..." _<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp; vbCrLf &amp; "please change the security settings " _<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp; vbCrLf &amp; vbCrLf &amp; " 1. Click on the&nbsp;&nbsp;&nbsp; '&nbsp;Trusted Publishers ' Tab&nbsp;" &amp; vbCrLf _<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp; " 2.&nbsp;cljck '&nbsp;Trust access to Visual basic Project.'", _<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; vbCritical<br />
&nbsp;&nbsp;&nbsp;CommandBars.FindControl(ID:=3627).Execute&nbsp;&nbsp;&nbsp;<br />
&nbsp;&nbsp;&nbsp; End If<br />
<br />
&nbsp; my problem is to view the message box&nbsp; and the task pane at the same time . Is it possible ?<br />
<br />
<br />
<br />&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10419684/security--taskpane.aspx" target="_self">read more</a>]]></description><pubDate>Thu, 28 Mar 2013 23:05:08 GMT</pubDate></item><item><title><![CDATA[SOLVED... Use a bookmark as the file path]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10410451/solved-use-a-bookmark-as-the-file-path.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10410451/solved-use-a-bookmark-as-the-file-path.aspx]]></link><description><![CDATA[<span style="color: #000000;">***Editted*** SOLVED!! (See&nbsp;<span style="color: #e36c09;">Orange&nbsp;</span>below)<br />
<br />
I have a word document that has fields that are filled in by an access database and then saved and attached to an email.&nbsp; Everything works great, except...<br />
I am trying to set this up at multiple locations.&nbsp; Each location will have a different file structure.&nbsp; I have created a form, in Access, that they can designate where they want the information saved at so I don't have to comb through my code and edit it for each new location. This&nbsp;path name is sent to the&nbsp;Word document&nbsp;to a bookmark called&nbsp;"RootDirectory".<br />
When the&nbsp;Word document is closed, there is some code that&nbsp;tells it to saveas...&nbsp;<br />
Everything runs fine as long as the pathname, specified in the saveas action in Word, is specifically spelled out (S:\QUALITY\CAR_Documentation).&nbsp; However, if I try to replace this text with&nbsp;&nbsp;"ActiveDocument.Bookmarks("RootDirectory").Range.Text", it doesn't work.<br />
Here is my code:<br />
<span style="background-color: #00b050;">This works;<br />
</span></span><br />
<div class="reCodeBlock" style="overflow-y: auto;border: #7f9db9 0px solid;">
<div style="background-color: #fff;"><span style="margin-left: 0px !important;"><code style="color: #069; font-weight: bold;">Private</code> <code style="color: #069; font-weight: bold;">Sub</code> <code style="color: #000;">Document_Close() </code></span></div>
<div style="background-color: #fff;"><span><code>&nbsp;</code><span style="margin-left: 3px !important;">&nbsp;</span></span></div>
<div style="background-color: #fff;"><span style="margin-left: 0px !important;"><code style="color: #069; font-weight: bold;">Dim</code> <code style="color: #000;">NewFileName </code><code style="color: #069; font-weight: bold;">As</code> <code style="color: #069; font-weight: bold;">String</code></span></div>
<div style="background-color: #fff;"><span><code>&nbsp;</code><span style="margin-left: 3px !important;">&nbsp;</span></span></div>
<div style="background-color: #fff;"><span style="margin-left: 0px !important;"><code style="color: #069; font-weight: bold;">If</code> <code style="color: #000;">ActiveDocument.ProtectionType &lt;&gt; wdAllowOnlyFormFields </code><code style="color: #069; font-weight: bold;">Then</code></span></div>
<div style="background-color: #fff;"><span style="margin-left: 0px !important;"><code style="color: #000;">ActiveDocument.Protect wdAllowOnlyFormFields, </code><code style="color: #069; font-weight: bold;">True</code></span></div>
<div style="background-color: #fff;"><span style="margin-left: 0px !important;"><code style="color: #069; font-weight: bold;">End</code> <code style="color: #069; font-weight: bold;">If</code></span></div>
<div style="background-color: #fff;"><span><code>&nbsp;</code><span style="margin-left: 3px !important;">&nbsp;</span></span></div>
<div style="background-color: #fff;"><span style="margin-left: 0px !important;"><code style="color: #000;">NewFileName = </code><code style="color: blue;"><span style="background-color: #ffff00;">"S:\QUALITY\CAR_Documentation\"</span> &amp; ActiveDocument.Bookmarks("</code><code style="color: #000;">CARNbr</code><code style="color: blue;">").Range.Text &amp; "</code><code style="color: #000;">\CAR_</code><code style="color: blue;">" &amp; ActiveDocument.Bookmarks("</code><code style="color: #000;">CARNbr</code><code style="color: blue;">").Range.Text &amp; "</code><code style="color: #000;">.doc" </code></span></div>
<div style="background-color: #fff;"><span style="margin-left: 0px !important;"><code style="color: #000;">ActiveDocument.SaveAs FileName:=NewFileName </code></span></div>
<div style="background-color: #fff;"><span><code>&nbsp;</code><span style="margin-left: 3px !important;">&nbsp;</span></span></div>
<div style="background-color: #fff;"><span style="margin-left: 0px !important;"><code style="color: #069; font-weight: bold;">End</code> <code style="color: #069; font-weight: bold;">Sub</code></span></div>
</div>
<br />
<span style="color: #000000;"><span style="background-color: #ff0000;">This&nbsp;did NOT work;</span><span style="background-color: #ffffff;"><span style="color: #e36c09;">&nbsp;&nbsp; </span><span style="color: #e36c09;">Works just fine now as explained below</span><br />
<br />
</span></span>
<div class="reCodeBlock" style="overflow-y: auto;border: #7f9db9 0px solid;">
<div style="background-color: #fff;"><span style="margin-left: 0px !important;"><code style="color: #069; font-weight: bold;">Private</code> <code style="color: #069; font-weight: bold;">Sub</code> <code style="color: #000;">Document_Close() </code></span></div>
<div style="background-color: #fff;"><span><code>&nbsp;</code><span style="margin-left: 3px !important;">&nbsp;</span></span></div>
<div style="background-color: #fff;"><span style="margin-left: 0px !important;"><code style="color: #069; font-weight: bold;">Dim</code> <code style="color: #000;">NewFileName </code><code style="color: #069; font-weight: bold;">As</code> <code style="color: #069; font-weight: bold;">String</code></span></div>
<div style="background-color: #fff;"><span><code>&nbsp;</code><span style="margin-left: 3px !important;">&nbsp;</span></span></div>
<div style="background-color: #fff;"><span style="margin-left: 0px !important;"><code style="color: #069; font-weight: bold;">If</code> <code style="color: #000;">ActiveDocument.ProtectionType &lt;&gt; wdAllowOnlyFormFields </code><code style="color: #069; font-weight: bold;">Then</code></span></div>
<div style="background-color: #fff;"><span style="margin-left: 0px !important;"><code style="color: #000;">ActiveDocument.Protect wdAllowOnlyFormFields, </code><code style="color: #069; font-weight: bold;">True</code></span></div>
<div style="background-color: #fff;"><span style="margin-left: 0px !important;"><code style="color: #069; font-weight: bold;">End</code> <code style="color: #069; font-weight: bold;">If</code></span></div>
<div style="background-color: #fff;"><span><code>&nbsp;</code><span style="margin-left: 3px !important;">&nbsp;</span></span></div>
<div style="background-color: #fff;"><span style="margin-left: 0px !important;"><code style="color: #000;">NewFileName = <span style="background-color: #ffff00;">ActiveDocument.Bookmarks(</span></code><span style="background-color: #ffff00;"><code style="color: blue;">"RootDirectory"</code><code style="color: #000;">).Range.Text &amp; </code></span><code style="color: blue;"><span style="background-color: #ffff00;">"\"</span> &amp; ActiveDocument.Bookmarks("</code><code style="color: #000;">CARNbr</code><code style="color: blue;">").Range.Text &amp; "</code><code style="color: #000;">\CAR_</code><code style="color: blue;">" &amp; ActiveDocument.Bookmarks("</code><code style="color: #000;">CARNbr</code><code style="color: blue;">").Range.Text &amp; "</code><code style="color: #000;">.doc" </code></span></div>
<div style="background-color: #fff;"><span style="margin-left: 0px !important;"><code style="color: #000;">ActiveDocument.SaveAs FileName:=NewFileName </code></span></div>
<div style="background-color: #fff;"><span><code>&nbsp;</code><span style="margin-left: 3px !important;">&nbsp;</span></span></div>
<div style="background-color: #fff;"><span style="margin-left: 0px !important;"><code style="color: #069; font-weight: bold;">End</code> <code style="color: #069; font-weight: bold;">Sub</code></span></div>
</div>
<br />
<span style="color: #e36c09;">The code works just fine.&nbsp; I didn't set the access code to tell it to "rename" the bookmark when it sent the information over to the Word doc.&nbsp; It was, in essence, deleting my bookmark instead of just filling in the data but leaving the bookmark.<br />
<br />
I added this little bit of code to my module and ... Viola!! Success!<br />
<br />
<div class="reCodeBlock" style="overflow-y: auto;border: #7f9db9 0px solid;">
<div style="background-color: #fff;"><span style="margin-left: 0px !important;"><code style="color: #000;">Dim s As Range </code></span></div>
<div style="background-color: #fff;"><span><code>&nbsp;</code><span style="margin-left: 3px !important;">&nbsp;</span></span></div>
<div style="background-color: #fff;"><span style="margin-left: 0px !important;"><code style="color: #000;">Set s = objWord.ActiveDocument.Bookmarks("RootDirectory").Range </code></span></div>
<div style="background-color: #fff;"><span style="margin-left: 0px !important;"><code style="color: #000;">s.Text = rstCAR.Fields("YourCompanyDocsPath") </code></span></div>
<div style="background-color: #fff;"><span style="margin-left: 0px !important;"><code style="color: #000;">objWord.ActiveDocument.Bookmarks.Add ("RootDirectory"), s </code></span></div>
</div>
<br />
<br />
</span>&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10410451/solved-use-a-bookmark-as-the-file-path.aspx" target="_self">read more</a>]]></description><pubDate>Sat, 31 Mar 2012 16:00:28 GMT</pubDate></item><item><title><![CDATA[Smartart]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10363624/smartart.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10363624/smartart.aspx]]></link><description><![CDATA[Hi,<br />
<br />
I'm trying to turn a Smartart graphic into a fixed picture I can place on different handouts. Previously&nbsp;I've been pasting into PowerPoint and then "Save as picture" but this time the graphic is huge when I paste it and it becomes a huge job to resize everything.<br />
<br />
Can anyone suggest either how to stop the graphic from changing size, or how else I can "group" Smartart together?<br />
<br />
Thanks heaps&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10363624/smartart.aspx" target="_self">read more</a>]]></description><pubDate>Sat, 31 Mar 2012 16:00:29 GMT</pubDate></item><item><title><![CDATA[Two Ref Field Codes on one line in Word 2007]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10353876/two-ref-field-codes-on-one-line-in-word-2007.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10353876/two-ref-field-codes-on-one-line-in-word-2007.aspx]]></link><description><![CDATA[<p >I need to create a Table of Contents that links to paragraph numbers (<strong>not</strong> page numbers).</p>
<p>I received the solution from another forum.&nbsp; Put it in a table and make a second column for the paragraph numbers and&nbsp;in the first column hide the page numbers by moving the tab marker over to the right so they are hidden.&nbsp; You can insert the paragraph numbers by using the Reference tool and referencing a paragraph with the paragraph number.</p>
<p>&nbsp;</p>
<p>Thanks</p>&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10353876/two-ref-field-codes-on-one-line-in-word-2007.aspx" target="_self">read more</a>]]></description><pubDate>Sat, 31 Mar 2012 16:00:33 GMT</pubDate></item><item><title><![CDATA[Links and Source Change]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10351801/links-and-source-change.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10351801/links-and-source-change.aspx]]></link><description><![CDATA[<br />
<br />
I have a link embedded on a Word10 Document connected to Excell Data Base. The issue I am having is that when I select the Change Source on Links it results in an endless&nbsp;circular spinning. I am unable to&nbsp;re-link to another&nbsp;Excell Data source and update my&nbsp;Word Document..... NEED HELP... - Dave&nbsp;&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10351801/links-and-source-change.aspx" target="_self">read more</a>]]></description><pubDate>Sat, 31 Mar 2012 16:00:33 GMT</pubDate></item><item><title><![CDATA[Split macro to save in .DOCM]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10351728/split-macro-to-save-in-docm.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10351728/split-macro-to-save-in-docm.aspx]]></link><description><![CDATA[I am doing a word merge from Access and from there want to split the resulting .DOCM into single pages.&nbsp; I have a macro setup to do this which works fine if going into a .DOC however there is a macro embedded that I have to have once split.&nbsp; Here is the macro script I am using:<br />
<br />
<p>Sub SplitByPage()<br />
'<br />
' SplitByPage Macro<br />
'<br />
Dim docName As String<br />
Dim Counter As String<br />
Dim DocDir As String<br />
Dim sPath As String<br />
Dim sName As String<br />
Dim Letters As Long<br />
Dim rDoc As Document<br />
Dim rLoad As String<br />
Dim fDialog As FileDialog<br />
Set fDialog = Application.FileDialog(msoFileDialogFolderPicker)<br />
With fDialog<br />
.Title = "Select Folder To Save Split Files and click OK"<br />
.AllowMultiSelect = False<br />
.InitialView = msoFileDialogViewList<br />
If .Show &lt;&gt; -1 Then<br />
MsgBox "Cancelled By User"<br />
Exit Sub<br />
End If<br />
DocDir = fDialog.SelectedItems.Item(1)<br />
If Right(DocDir, 1) &lt;&gt; "\" Then DocDir = DocDir + "\"<br />
End With<br />
Set rDoc = ActiveDocument<br />
With rDoc<br />
If Len(.Path) = 0 Then<br />
.Save<br />
End If<br />
If UCase(Right(.Name, 1)) = "X" Then<br />
sName = Left(.Name, Len(.Name) - 5)<br />
Else<br />
sName = Left(.Name, Len(.Name) - 4)<br />
End If<br />
rLoad = rDoc.FullName<br />
End With<br />
With Selection<br />
.EndKey Unit:=wdStory<br />
Letters = .Information(wdActiveEndPageNumber)<br />
.HomeKey Unit:=wdStory<br />
End With<br />
Counter = 1<br />
While Counter &lt; Letters + 1<br />
Application.ScreenUpdating = False<br />
docName = DocDir _<br />
&amp; sName &amp; Chr(32) &amp; _<br />
LTrim$(Str$(Counter)) &amp; ".docm"<br />
ActiveDocument.Bookmarks("\page").Range.Cut<br />
Documents.Add<br />
With Selection<br />
.Paste<br />
.EndKey Unit:=wdStory<br />
.MoveLeft Unit:=wdCharacter, Count:=1<br />
.Delete Unit:=wdCharacter, Count:=1<br />
End With<br />
ActiveDocument.SaveAs FileName:=docName, _<br />
FileFormat:=wdFormatDocument<br />
ActiveWindow.Close<br />
Counter = Counter + 1<br />
Application.ScreenUpdating = True<br />
Wend<br />
rDoc.Close wdDoNotSaveChanges<br />
Documents.Open rLoad<br />
End Sub</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p >&nbsp;</p>
I get an error that says " Run-Time error '6294':<br />
Incompatible file type and file extension<br />
<br />
When I go into debug it highlights these two lines:<br />
<br />
ActiveDocument.SaveAs FileName:=docName, _<br />
FileFormat:=wdFormatDocument<br />
<br />
Can anyone help with this?<br />
<br />
Thanks in advance.&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10351728/split-macro-to-save-in-docm.aspx" target="_self">read more</a>]]></description><pubDate>Sat, 31 Mar 2012 16:00:33 GMT</pubDate></item><item><title><![CDATA[Global ContentControl event handler]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10305301/global-contentcontrol-event-handler.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10305301/global-contentcontrol-event-handler.aspx]]></link><description><![CDATA[I'm using VBA in Word 2007.<br />
<br />
Can I make a global document content control event handler <strong>any</strong> open doucment, not just those doucments created from the template holding the code?<br />
<br />
My goal is that any time someone clicks in a content control, the existing placeholder text is seleted making it easy to replace by typing.&nbsp; If I put this code in the ThisDocument module for a document template, when I click in a content control, all text is selected:<br />
==============<br />
Private Sub Document_ContentControlOnEnter(ByVal ContentControl As ContentControl)<br />
ContentControl.Range.Select<br />
End Sub<br />
==============<br />
<br />
My problem is <strong>that only works for douments created from that template</strong>.&nbsp; I tried putting that code in a global template stored in the Word startup directory that loads with word, but it doesn't work for doucments I open.<br />
<br />
I've been reading up on event handlers and I can see how to make a global one for word application events that fires for any open document, but not Document events, which it seems the "ContentControlOnEnter" is a document event.<br />
<br />
Help?!<br />
<br />
Thanks.&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10305301/global-contentcontrol-event-handler.aspx" target="_self">read more</a>]]></description><pubDate>Sat, 31 Mar 2012 16:00:34 GMT</pubDate></item><item><title><![CDATA[Selecting bookmarks via UserForm]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10301584/selecting-bookmarks-via-userform.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10301584/selecting-bookmarks-via-userform.aspx]]></link><description><![CDATA[I have a form with a bunch of bookmarked tables that I want to be able to hide unhid select, copy and paste via a user form.&nbsp;<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ActiveDocument.Bookmarks(zoneBookmark).Range.Select<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Selection.Copy<br />
<br />
I want the zoneBookmark to vary based on input from a combo box created from a custom userform. There are about 15 different bookmarked tables<br />
<br />
Here was my first try.<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;If zoneType = "General Standard Dryer" Then .Bookmark zoneBookmark.Range.Text = "GeneralGeneral"<br />
<br />
Any input?&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10301584/selecting-bookmarks-via-userform.aspx" target="_self">read more</a>]]></description><pubDate>Sat, 31 Mar 2012 16:00:34 GMT</pubDate></item><item><title><![CDATA["Nicht vom nächsten Absatz trennen" in Word 2007]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10284514/nicht-vom-nchsten-absatz-trennen-in-word-2007.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10284514/nicht-vom-nchsten-absatz-trennen-in-word-2007.aspx]]></link><description><![CDATA[<span style="font-style: italic;">Hallo,<br />
<br />
ich habe eine Problem mit der Option "Nicht vom nächsten Absatz trennen" in Word 2007. Im betreffenden Dokument werden Positionsrahmen (außen) als Marginalie verwendet. Der Marginalie folgt jeweils eine neuer Absatz. Im Falle eines Umbruchs auf die nächste Seite sollen Text und Marginalie zusammen stehenbleiben. Dazu wurde der Absatz Marginalie (also der Posistionsrahmen) mit der Option "Nicht vom nächsten Absatz trennen" formatiert. Das funktioniert auch korrekt - jedoch nicht, wenn eine Tabelle folgt. Ist dies der Fall, wird vor der Tabelle umgebrochen und die Marginalie bleibt allein auf der vorherigen Seite stehen. Auch wenn die Tabelle nur eine Zeile hat o.ä.<br />
<br />
In Word 2003 funktioniert diese Formatierung einwandfrei - in 2007 jedoch nicht.<br />
<br />
Ich finde absolut keine Lösung für dieses Problem! Danke für jeden Hinweis!</span>&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10284514/nicht-vom-nchsten-absatz-trennen-in-word-2007.aspx" target="_self">read more</a>]]></description><pubDate>Sat, 31 Mar 2012 16:00:35 GMT</pubDate></item><item><title><![CDATA[total numbering 2 of 3 sections]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10284244/total-numbering-2-of-3-sections.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10284244/total-numbering-2-of-3-sections.aspx]]></link><description><![CDATA[<title></title>



    p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Arial}

<p class="p1">I have a document with 3 sections. There are 10 total pages. I am trying to show section 1 and section 2 as being 1 of 8 while section 3 has a separate numbering scheme (x of 2). The first 2 sections are linked with 'same as previous' and the 3rd section unlinked with a next page section break. The 3rd section shows as starting on page 1 correctly and is using SectionPage as the total. This shows up as 1 of 2 and 2 of 2 correctly (page 9 and 10 of total). The first section is set to start on 1 and is using NumPages as the total. The second section is linked to the first and is using NumPages as the total as well. Section 1 and 2 show x of 10 as the total page. I am trying to show this as x of 8. I can't use Bookmarks and PageRef because I need section 1 and 2 to be dynamic and the page with the bookmark may not always be needed to render. Is there a different merge statement or combination of statements i could use to get the total number of pages for multiple sections? thanks.</p>
<p class="p1"></p>
<p class="p1"></p>
<p class="p1"></p>
<p class="p1"></p>
<p class="p1">----------</p>
<p class="p1"></p>
<p class="p1">this has been resolved.</p>&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10284244/total-numbering-2-of-3-sections.aspx" target="_self">read more</a>]]></description><pubDate>Sat, 31 Mar 2012 16:00:35 GMT</pubDate></item><item><title><![CDATA[Convert Word (table) to PDF - missing/incorrectly sized lines/borders]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10283532/convert-word-table-to-pdf--missingincorrectly-sized-linesborders.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10283532/convert-word-table-to-pdf--missingincorrectly-sized-linesborders.aspx]]></link><description><![CDATA[Converting Word (table) to pdf - lines screwed up - googled as far back as 2004.<br />
BUG STILL exists. HELP/FIX PLEASE?<br />
http://www.pcreview.co.uk/forums/missing-table-lines-conversion-pdf-t878406.html<br />
http://forums.adobe.com/thread/305508<br />
<br />
Trying to convert any word doc with tables (&amp; shading) to PDF<br />
- basic table, black borders throughout <br />
- shaded headings, black outline border<br />
- shaded subheadings, black outline border<br />
<br />
However when convert to PDF:<br />
- 'displays' NO top cell border for some/all shaded rows<br />
- shows diff thickness lines<br />
- each conversion, diff lines missing/incorrectly sized <br />
- however converted pdf prints perfectly fine<br />
<br />
Adobe know about the bug, per PRMW's (Paul's) post on 2009-07-15 15:44:34, however only offered a painful time consuming workaround using non-freeware Adobe Pro:<br />
http://acrobatusers.com/forum/pdf-creation/word-pdf-table-lines-missing-or-faded#comment-78139<br />
- "It is not feasable to edit 200+ tables in the PDF every time the PDF is generated, as we maintain the original in word.<br />
- "This complete issue seems to have been passed off by Adobe as no problem and that there is a work around. I consider this an unsatisfactory response from a major product supplier.<br />
<br />
Microsoft TechNet &amp; NitroPdf said it's an Adobe issue &amp; to contact Adobe to fix the bug.<br />
<br />
Tried, but proble exists:<br />
* Word 2010 &gt; File&nbsp; &gt; Save &amp; Send &gt; Create PDF/XPS Document<br />
* Word 2010 &gt; Save As &gt; Pdf<br />
* Word 2010 &gt; Print &gt; PrimoPdf&nbsp; (even tried properties &gt; advanced &gt; dpi 300/600/2400) &gt; Custom<br />
* Word 2010 &gt; Print &gt; doPDF v7&nbsp; (even tried 'high quality images)<br />
* Word 2010 &gt; Print &gt; PDFCreator<br />
* Word 2010 &gt; Print &gt; CutePdf Writer&nbsp;&nbsp;&nbsp; (even worse)<br />
* Nitro Pdf Reader&nbsp; &gt; Convert From File &gt; (even worse)<br />
* www.pdfonline.com &gt; Word to Pdf&nbsp;&nbsp;&nbsp;&nbsp; (even worse)<br />
* www.wordtopdf.com &gt; email: Sorry, an unexpected conversion failure occurred when converting your file. <br />
<br />
Software:<br />
* Word 2010 - tried with .docx &amp; .doc (97 to 2003)<br />
* Adobe Reader 8.2.6 (freeware), then upgraded to Adobe Reader X 10.0.1 (freeware)<br />
* GhostScript 9.01 w32 (freeware)<br />
* CutePdf Writer (freeware)<br />
* PrimoPdf (freeware)<br />
* Nitro Pdf Reader 1.4.0.11 (freeware)<br />
* doPDF 7.2.361 (freeware)<br />
* PDFCreator 1.2.0 (opensource - www.pdfforge.org)<br />
<br />
Seems to display better at 300%, but lines still not right (even at 2400%), but who views pdf's at this zoom?&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10283532/convert-word-table-to-pdf--missingincorrectly-sized-linesborders.aspx" target="_self">read more</a>]]></description><pubDate>Sat, 31 Mar 2012 16:00:35 GMT</pubDate></item><item><title><![CDATA[Microsoft Office Outlook does not recognize "FirstName1 on email merge]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10273841/microsoft-office-outlook-does-not-recognize-firstname1-on-email-merge.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10273841/microsoft-office-outlook-does-not-recognize-firstname1-on-email-merge.aspx]]></link><description><![CDATA[I am trying to send a broadcast e mail from Outlook 2007.&nbsp; I have successfully done this before.&nbsp; I brought up the Word Document and related it to an excel 2007 list of names and e mail addresses.&nbsp; I checked off the recipients in the list that I want to receive the e mail.&nbsp; I then previewed the e mails and scrolled through all of them and they looked perfect.&nbsp; I finally hit finish and merge then send e mail message, put in the subject line and chose HTML and chose to FirstName1 in the other drop down box.&nbsp; Looks all clear to me but when I hit ok I get a message that Microsoft Office Outlook does not recognize "Gertrude".........(which is the first FirstName1 on my Excel spreadsheet list.&nbsp;&nbsp; <br />
<br />
What did I do wrong?&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10273841/microsoft-office-outlook-does-not-recognize-firstname1-on-email-merge.aspx" target="_self">read more</a>]]></description><pubDate>Sat, 31 Mar 2012 16:00:36 GMT</pubDate></item><item><title><![CDATA[Ignore blank rows when populating word combobox from excel range]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10272164/ignore-blank-rows-when-populating-word-combobox-from-excel-range.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10272164/ignore-blank-rows-when-populating-word-combobox-from-excel-range.aspx]]></link><description><![CDATA[Hi, I am populating a word userform multi row combo box using data from an excel range. My code works fine, however, the combobox also populates with entirely blank rows (there are entirely blank rows in the excel range- the excel range is constantly changing, so I can't just set the range to rows where there are entries). I would like to either ignore entirely blank rows in the range, or, if not possible, remove them from the combobox, or at least hide them. I do not want to ignore a row in the range if some of the cells are blank, only if an row is completely blank.
<div><br />
</div>
<div>The code I am using is as follows:</div>
<div><br />
</div>
<div>
<div>Private Sub UserForm_Initialize()</div>
<div>Dim sourcedoc As Document</div>
<div><br />
</div>
<div>Dim xlApp As Excel.Application</div>
<div>Dim xlbook As Excel.Workbook</div>
<div>Dim Locarray As Variant</div>
<div>Dim bStartApp As Boolean</div>
<div>On Error Resume Next</div>
<div>Set xlApp = GetObject(, "Excel.Application")</div>
<div>If Err Then</div>
<div>&nbsp;&nbsp;bStartApp = True</div>
<div>&nbsp;&nbsp;Set xlApp = New Excel.Application</div>
<div>End If</div>
<div>On Error GoTo 0</div>
<div>With xlApp</div>
<div>&nbsp;&nbsp;'Set xlbook = .Workbooks.Open("S:\PINTEL - Post box for intelligence reports\13 Report system back office\Reporting system data.xls")</div>
<div>&nbsp;&nbsp;Set xlbook = .Workbooks.Open("C:\Users\Johnny\Desktop\Reporting system data.xls")</div>
<div><br />
</div>
<div>&nbsp;&nbsp;Locarray = xlbook.Names("locationrange").RefersToRange.Value</div>
<div>&nbsp;&nbsp;xlbook.Close SaveChanges:=False</div>
<div>&nbsp;&nbsp;Set xlbook = Nothing</div>
<div>End With</div>
<div>If bStartApp Then xlApp.Quit</div>
<div>Set xlApp = Nothing</div>
<div>ComboBox1.List = Locarray</div>
<div><br />
</div>
<div><br />
</div>
<div>Set xlApp = Nothing</div>
<div>Set xlbook = Nothing</div>
<div>End Sub</div>
</div>&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10272164/ignore-blank-rows-when-populating-word-combobox-from-excel-range.aspx" target="_self">read more</a>]]></description><pubDate>Sat, 31 Mar 2012 16:00:36 GMT</pubDate></item><item><title><![CDATA[issues with SaveAs]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10270969/issues-with-saveas.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10270969/issues-with-saveas.aspx]]></link><description><![CDATA[Hi,<br />
<br />
Not sure if I'm in the right place to post this, so I apologize in advance if it's not.&nbsp; I'm on Win7 with Office 2007, and I have the SaveAs PDF extension installed.&nbsp; I want to write a simple macro in VB to save the current file (which always starts out as .docx) in three formats: docx, rtf, and pdf.<br />
<br />
I know I can save to same format (in this case .docx) with ActiveDocument.Save.&nbsp; No problem there.<br />
<br />
I know I should be able to use ActiveDocument.SaveAs to save in wdFormatRTF and wdFormatPDF.&nbsp; Should SaveAs know what the proper extension is, or do I have to feed that info to the FileName argument to SaveAs?&nbsp; It seems NOT to know, which means I have to code it (e.g., array with my list of file types and their associated extensions), which seems really silly.&nbsp; <br />
<strong>ISSUE1</strong>: Is there some way to get to the default extension for a given WdSaveFormat (so I don't have to code it)?<br />
<br />
SaveAs wdFormatRTF seems to save the file just fine.&nbsp; However, it changes my focus from the .docx to the .rtf.&nbsp; <br />
<strong>ISSUE2</strong>: Is there some way to stay on the original (.docx) file when I do a SaveAs?&nbsp; Or is there some other way to save as a different file type without activating the newly-saved file?&nbsp; <br />
<br />
My code so far is below.&nbsp; <br />
<br />
-- mdeck<br />
<br />
<blockquote> Sub MultiSave()<br />
'<br />
' MultiSave Macro<br />
' save the current document to current format and additional named formats<br />
'<br />
&nbsp;&nbsp;&nbsp; Dim i As Integer, rc As Integer<br />
&nbsp;&nbsp;&nbsp; Dim strDocName As String, strDocExt As String<br />
&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
&nbsp;&nbsp;&nbsp; 'define named formats<br />
&nbsp;&nbsp;&nbsp; Const myFileTypes = 3&nbsp;&nbsp; 'how many file types do I have?<br />
&nbsp;&nbsp;&nbsp; Dim thisFormat As Variant<br />
&nbsp;&nbsp;&nbsp; Dim myFormats(1 To myFileTypes, 2) As Variant&nbsp;&nbsp; 'wdFormat and ext<br />
&nbsp;&nbsp;&nbsp; myFormats(1, 1) = wdFormatDocumentDefault 'Word default document file format. For Microsoft Office Word 2007, this is the DOCX format.<br />
&nbsp;&nbsp;&nbsp; myFormats(1, 2) = ".docx"<br />
&nbsp;&nbsp;&nbsp; myFormats(2, 1) = wdFormatRTF&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Rich text format (RTF).<br />
&nbsp;&nbsp;&nbsp; myFormats(2, 2) = ".rtf"<br />
&nbsp;&nbsp;&nbsp; myFormats(3, 1) = wdFormatPDF&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'PDF format.<br />
&nbsp;&nbsp;&nbsp; myFormats(3, 2) = ".pdf"<br />
&nbsp;&nbsp; &nbsp;<br />
&nbsp;&nbsp;&nbsp; 'get filename parts and set the directory<br />
&nbsp;&nbsp;&nbsp; strDocExt = Right(ActiveDocument.Name, Len(ActiveDocument.Name) - InStrRev(ActiveDocument.Name, ".") + 1)<br />
&nbsp;&nbsp;&nbsp; strDocName = Left(ActiveDocument.Name, InStrRev(ActiveDocument.Name, ".") - 1)<br />
&nbsp;&nbsp;&nbsp; ChangeFileOpenDirectory ActiveDocument.Path<br />
&nbsp;&nbsp; &nbsp;<br />
&nbsp;&nbsp;&nbsp; 'if not blocked, save to current format<br />
&nbsp;&nbsp;&nbsp; If ActiveDocument.ReadOnly = False Then ActiveDocument.Save<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
&nbsp;&nbsp;&nbsp; 'save to indicated formats that are different from current format<br />
&nbsp;&nbsp;&nbsp; For i = 1 To myFileTypes<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If (strDocExt &lt;&gt; myFormats(i, 2)) Then ActiveDocument.SaveAs _<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FileName:=strDocName + myFormats(i, 2), _<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FileFormat:=myFormats(i, 1), _<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AddToRecentFiles:=False<br />
&nbsp;&nbsp;&nbsp; Next<br />
End Sub<br />
</blockquote>&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10270969/issues-with-saveas.aspx" target="_self">read more</a>]]></description><pubDate>Sat, 31 Mar 2012 16:00:38 GMT</pubDate></item><item><title><![CDATA[Mail Merge for Office Name Plates]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10269594/mail-merge-for-office-name-plates.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10269594/mail-merge-for-office-name-plates.aspx]]></link><description><![CDATA[I need to start this by saying that I have done this once but for some reason only the Gods know I didn't save it.&nbsp; I am in charge of the Name Plate for our floor some 111 offices, I have a lot of movement so this is an onerous task at the best of times.&nbsp; <br />
<br />
I have set up a template as a lable in Word 2003 for the Name Plate sheets.&nbsp; I want&nbsp;to use the&nbsp;master spreadsheet (Excel 2003)&nbsp;as a data source.&nbsp; Some of the offices only have one occupant and some have two.&nbsp; The&nbsp;Master sheet tells me the office number, what division the people in that office work in, where in the office the&nbsp;person sits&nbsp;and their name.&nbsp;&nbsp;<br />
<br />
I want to print each offices name plate with the names of the occupants on it in the correct position.&nbsp; Here is what I want to accomplish in words. Words in &lt;&nbsp; &gt; are the fields<br />
<br />
IF&nbsp;&nbsp;&nbsp;&nbsp;Next Record &lt;office number&gt; = Previous Record &lt;office number&gt;<br />
Then&nbsp;&nbsp; insert &lt;position&gt; &lt;Name&gt;<br />
Else&nbsp;&nbsp;Go To next lable<br />
<br />
The lable/template would look like this<br />
<br />
101&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Purchasing&nbsp;<br />
<br />
A.&nbsp;John Smith<br />
B.&nbsp;Jane Doe<br />
<br />
The IF THEN ELSE statements only work if I want to insert text it doesn't work to have it compare the current record with the previous record.<br />
<br />
This probably wouldn't be so frustrating if A. I had save it the last time I did it, B. if everything I found on the web didn't all deal with form letters.&nbsp; <br />
<br />
Please Help!<br />
<br />
Maura<br />&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10269594/mail-merge-for-office-name-plates.aspx" target="_self">read more</a>]]></description><pubDate>Sat, 31 Mar 2012 16:00:40 GMT</pubDate></item><item><title><![CDATA[sections missing, jumping and radical page numbers.]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10267836/sections-missing-jumping-and-radical-page-numbers.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10267836/sections-missing-jumping-and-radical-page-numbers.aspx]]></link><description><![CDATA[Hi,&nbsp; <br />
Word 2007, XP pro.<br />
I am preparing a 100+ page document with mainly portrait pages and some landscape pages&nbsp;and . I have figured out the section breaks ok and even figured out the header and footer features ok but<br />
in the header/footer I&nbsp;am missing some sections - it jumps from say section&nbsp;8 to 10 missing 9.<br />
I add a header to section 4 but it only adds it to the 1st page of section 4, I then add a header to the 2nd page of section 4 and it adds the header to the rest of that section but also adds it to section 1 (skipping 2 and 3)aaaarrrggh :)<br />
<br />
I tried adding page numbers so that the entire document was numbered regardless of the seperate sections in the footer area but that is just totally confusing as it seems to be quite random as to where the numbers now start and finish and when I add numbers it changes the formatting of some of the landscape pages making them overflow onto the next page down.<br />
Any help would be much appreciated<br />
Regards<br />
Gordon&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10267836/sections-missing-jumping-and-radical-page-numbers.aspx" target="_self">read more</a>]]></description><pubDate>Sat, 31 Mar 2012 16:00:40 GMT</pubDate></item><item><title><![CDATA[Selecting Objects by Name in Word with VBA]]></title><guid isPermaLink="false"><![CDATA[http://www.eggheadcafe.com/community/word/67/10267619/selecting-objects-by-name-in-word-with-vba.aspx]]></guid><link><![CDATA[http://www.eggheadcafe.com/community/word/67/10267619/selecting-objects-by-name-in-word-with-vba.aspx]]></link><description><![CDATA[I am trying to create a template where I replace certain pictures through a macro. I want to be able to select the picture by name.<br />
<br />
A few questions.<br />
<ol>
    <li>How do I name an object preferably not through VBA? I have tried to use the Properties and controls toolbox.</li>
    <li>How do I add meaningful names to Objects?</li>
    <li>How do I select the object that I have named through the controls toolbox?</li>
</ol>
I am trying the code below but keeps erroring out.<br />
<br />
ActiveDocument.Shapes("Service Code").Select&nbsp;&nbsp;<a href="http://www.eggheadcafe.com/community/word/67/10267619/selecting-objects-by-name-in-word-with-vba.aspx" target="_self">read more</a>]]></description><pubDate>Sat, 31 Mar 2012 16:00:40 GMT</pubDate></item></channel></rss>