Microsoft Office Word Forum

Microsoft Office Word Forum - WordBanter http://www.wordbanter.com A Word forum covering all aspects of Microsoft Word acting as a webgateway with the finest Microsoft community Word newsgroups en Sat, 31 Jul 2010 17:18:41 GMT vBulletin 60 http://www.wordbanter.com/images/002/misc/rss.jpg Microsoft Office Word Forum - WordBanter http://www.wordbanter.com Is There A Way To Build A Macro To Open, Process, Save, And Close A Number Of Files http://www.wordbanter.com/showthread.php?t=146448&goto=newpost Wed, 28 Jul 2010 01:34:14 GMT I have 4000 files in one directory. Each file requires I run ten macros to process the file. Is there a way to -- 1. Open A File 2. Run the ten macros (or a combination of the ten) 3. Save the file 4. Close the file 5. Go to the next file in the directory and repeat Thank you in advance for your... I have 4000 files in one directory.
Each file requires I run ten macros to process the file.
Is there a way to --
1. Open A File
2. Run the ten macros (or a combination of the ten)
3. Save the file
4. Close the file
5. Go to the next file in the directory and repeat

Thank you in advance for your replies. ]]> General Discussion HowdeeDoodee http://www.wordbanter.com/showthread.php?t=146448 <![CDATA[Macros won't open after reopening excel]]> http://www.wordbanter.com/showthread.php?t=146446&goto=newpost Tue, 27 Jul 2010 20:32:46 GMT Hi, I saved my excel wksheet with macros disabled with notification, but apon reopening I cannot find a way of enabling them. Also when I go to the macros, they don't show... as if there aren't any. Not sure what I've done wrong. I also saved the worksheet w/ Macros enabled and still cannot get them to work. What should I do?
Cheers. ]]> General Discussion TC10 http://www.wordbanter.com/showthread.php?t=146446 Attach Auto-Update Macro to Word Document? http://www.wordbanter.com/showthread.php?t=146445&goto=newpost Tue, 27 Jul 2010 15:22:51 GMT Hey guys, I wrote a macro that auto-updates all fields in a word document upon opening the document. I realized that this macro is local to my computer, so other people who open the file are not having their fields auto-update. Is there a way to attach a macro to a word document so anyone who... Hey guys,

I wrote a macro that auto-updates all fields in a word document upon opening the document. I realized that this macro is local to my computer, so other people who open the file are not having their fields auto-update.

Is there a way to attach a macro to a word document so anyone who uses the document will have the macro work for them? I have tried searching for an answer for a while, but no dice.

Thank you very much,
UCHelp ]]> Mailmerge UCHelp http://www.wordbanter.com/showthread.php?t=146445 Like or Contains Statement Word 2007? http://www.wordbanter.com/showthread.php?t=146444&goto=newpost Tue, 27 Jul 2010 14:55:30 GMT Is there a way to search a field using a statement that will find a specific character in a field of variable length? The field contains: G, GR, GS, GSR, GSU, GSUR, GU, GUR, S, SR, SU, AND SUR. I want to be able to find each occurance of a letter contained therein. Any help you can give will... Is there a way to search a field using a statement that will find a specific character in a field of variable length?

The field contains: G, GR, GS, GSR, GSU, GSUR, GU, GUR, S, SR, SU, AND SUR. I want to be able to find each occurance of a letter contained therein.

Any help you can give will be appriciated. ]]> Mailmerge Art Lewis http://www.wordbanter.com/showthread.php?t=146444 Sentences altered from Copy and Paste http://www.wordbanter.com/showthread.php?t=146443&goto=newpost Tue, 27 Jul 2010 12:44:35 GMT I copied (copy and paste) a PDF file to Word and this is exactly what I got: this type of ambiance in home decorating. This is designed to be happy and convivial. When you add vivacious colors and patterns to pillows, cushions and slip-covers, it enhances and brightens the home. For those who... I copied (copy and paste) a PDF file to Word and this is exactly what I got:

this type of ambiance in home decorating. This is designed to be happy and convivial.
When you add vivacious colors and patterns to pillows, cushions and slip-covers, it enhances
and brightens the home. For those who visit, they will feel welcomed from the first moment they
enter the door.

This is a long document (50 pgs). How can I fix this without going from line to line and backspacing to bring the single words back to a complete sentence?

Thanks ]]> New Users Johnhds http://www.wordbanter.com/showthread.php?t=146443 <![CDATA[Four equations select & enter 4 Paragraphs]]> http://www.wordbanter.com/showthread.php?t=146442&goto=newpost Mon, 26 Jul 2010 23:15:19 GMT I am running a mail merge document from Access 2007 to Word 2007.
The “CurCln” field has twelve iterations of four letters: G, GR, GS, GSR, GSU, GSUR, GU, GUR, S, SR, SU AND SUR.

I want to enter a MAILMERGE statement in four places in a merge Word document using the Ctrl F9 method. There will be four statements that will select for each of the four letters ( G, S, R, U) that will enter a corresponding paragraph contained in a bookmarked separate Word document.

The logic I want is something like the following, but I do not know how to translate it to work in MAILMERGE and obviously, I don’t know how to call up a bookmark. I would be grateful for any help you can give me.

Field “CurCln” contains: G, GR, GS, GSR, GSU, GSUR, GU, GUR, S, SR, SU, SUR
C:\GSUR.docx has four bookmarked paragraphs named bmG, bmS, bmR, bmU

Eq G: IF(“CurCln” Like "G*", C:\GSUR.docx bmG,””)
Eq S: IF(("CurCln" Like “S*” or CurCln Like "*S*"), C:\GSUR.docx bmS,””)
Eq R: IF(("CurCln" Like “"*R", C:\GSUR.docx bmR,””)
Eq U: IF(("CurCln" Like “*U” or "CurCln" Like "*U*"), C:\GSUR.docx bmU,””)

Perhaps this could be done another way by selecting paragraph sets: Four paragraphs for GSUR, three for GSU, one for S and so on for all twelve iterations.

Art Lewis ]]> Mailmerge Art Lewis http://www.wordbanter.com/showthread.php?t=146442 I need help please! with an application. http://www.wordbanter.com/showthread.php?t=146437&goto=newpost Sun, 25 Jul 2010 10:20:58 GMT Hi.
I want to copy and paste paragraphs onto an application but the application sheet (which is also on MS word) won't let me paste. I click inside the box to paste and it pastes the paragraph outside the box. Is there any thing/command i can do or undo to be able to paste text in the application?

thanks for the help in advance ]]> General Discussion lonerangerette http://www.wordbanter.com/showthread.php?t=146437 How to Delete a Default Word Macro? http://www.wordbanter.com/showthread.php?t=146425&goto=newpost Fri, 23 Jul 2010 19:24:08 GMT My Word 2003 installation keeps switching to a complex font setting, even after I've uninstalled and reinstalled several times. I'm kind of learning to live with that until 2007 comes along. BUT there's one thing that's driving me nuts!!!

I'm a complete keyboard queen. If I don't need to take my fingers off the board, I'm happy.

Ever since the mysterious switch, the keyboard combination Ctrl+Shift changes my paragraph / text reading switches from Right To Left.

My first solution was to create a custom macro called do_nothing and reassign the Ctrl+Shift keyboard shortcut to a macro that does absolutely nothing, but Word won't recognize the Ctrl+Shift by itself (without a third qualifier key).

I located the macro in the Word Commands Macro dialogue box (RTLPara), and I want to just delete it, but I can't find a way to do that (because it's an innate / default / native Word macro, I'm guessing).

Any help? ]]> General Discussion kaje http://www.wordbanter.com/showthread.php?t=146425 Can I stop Word 2010 opening? http://www.wordbanter.com/showthread.php?t=146422&goto=newpost Fri, 23 Jul 2010 09:11:55 GMT I have used Word 97 years and have recently 'upgraded' to Office 2010.

I am immensely frustrated by the new version of Word but will keep it for compatibility reasons. However I'd prefer to use Word 97 for day-to-day tasks.

However, whenever I double-click on a .doc file Word 2010 insists on opening, even if I choose Open With and choose Word 97!

Is there any way to stop Word 2010 from hijacking the .doc file extension and allowing me to open files with the program I prefer.

(I'm using XP SP3)

Thanks
Steve ]]> General Discussion Stevegatw http://www.wordbanter.com/showthread.php?t=146422 Bibliography numbering http://www.wordbanter.com/showthread.php?t=146409&goto=newpost Wed, 21 Jul 2010 22:27:09 GMT I am using Word 2007/2010 and trying to include the Bibliography. When I do that, it comes up as the author name and year in parentheses. How can I modify this so that I can include [1] at the first reference, so on and so forth? And also at the end of the document I can list the bibliography in numbered order.

[1]
[2]
[3]
.
.
.
.
.
.
.

Thank you in advance! ]]> General Discussion Andy K http://www.wordbanter.com/showthread.php?t=146409 Image in document not displaying properly http://www.wordbanter.com/showthread.php?t=146408&goto=newpost Wed, 21 Jul 2010 20:59:36 GMT I can't get this image to display correctly, if you see in the attatched image it's almost like it's cut off, or behind the layer in photoshop or something. If I drag the image onto a page below this one it displays correctly, what is going on here?

Attached Images

]]> General Discussion cow87 http://www.wordbanter.com/showthread.php?t=146408 Excel Tables to MS Word http://www.wordbanter.com/showthread.php?t=146406&goto=newpost Wed, 21 Jul 2010 19:47:15 GMT Hello :) I have a project where I am getting 1,500 Excel tables. The tables need to be formatted and colored to look pretty, then imported into Word and laid out, and create a table of contents for each table title. I am going to deliver (1) a Word doc with a table of contents and 1,500 pretty... Hello :)

I have a project where I am getting 1,500 Excel tables. The tables need to be formatted and colored to look pretty, then imported into Word and laid out, and create a table of contents for each table title. I am going to deliver (1) a Word doc with a table of contents and 1,500 pretty tables, and (2) an Excel file with a straight list of pretty tables.

I currently get 1,500 tables that look like this:

I take a table design and "Copy Paste Special Format" 1,500 times, which keeps the data but styles the background. (some tables have more rows than others so i have to go back and touch up 50% of the tables and it comes out looking like this:

I then copy all the rows in Excel and paste it into Word. I highlight the entire selection of table data and adjust the columns that get squished to even them out. I highlight all 1,500 table names and style them as a "heading", so I can make a table of contents. I also insert page breaks throughout the entire document to prevent tables from being cut off and partially displayed on the next page. The word doc looks like this:

My questions/comments:
Is there any way I can improve this process? I know that I can make a macro to import data from Excel to Word and it will automatically style it. The benefit to this is also if data changes in Excel, you only have to update one document. The downside to this is that it appears you have to make a lot of selections and import the tables to be styled one-by-one. Is this so? I need the Excel tables and Word tables to be styled. The way I am currently doing it seems okay, but Im curious if there is a better way? Can I insert "headings" in Excel and will it carry over to Word to make the table of contents easier to make? Is there anything I am missing that will let me take a ton of unstyled tables, apply a design to them and export them with a table of contents with page numbering? ]]> Tables ripcurlksm http://www.wordbanter.com/showthread.php?t=146406 Want my Document to Print on One Page http://www.wordbanter.com/showthread.php?t=146405&goto=newpost Wed, 21 Jul 2010 15:46:30 GMT I recently started using Word 2010 and have not been able to figure out how to "force" it to shrink my document enough to print on one page. It used to be a radio button on the page setup on Word 2000 (I know, I'm slow to transition!), but I can't seem to find it or an option to do this anywhere on 2010
Does anyone know how to do it?
Thanx! ]]> Page Layout IAMDOREE http://www.wordbanter.com/showthread.php?t=146405 pagination question http://www.wordbanter.com/showthread.php?t=146401&goto=newpost Tue, 20 Jul 2010 22:51:31 GMT Whats the best way to manually affect the pagination of a letter so that later revisions will not result in pagination having to be removed? Hard page break, keep with next or both? Or is there another way? Whats the best way to manually affect the pagination of a letter so that later revisions will not result in pagination having to be removed? Hard page break, keep with next or both? Or is there another way? ]]> General Discussion af489 http://www.wordbanter.com/showthread.php?t=146401 <![CDATA[Unable to use "Send to" in Office 2003]]> http://www.wordbanter.com/showthread.php?t=146399&goto=newpost Tue, 20 Jul 2010 18:07:04 GMT Search keywords - mail recipient greyed out, send to in missing excel 2003 Excel, Word, Powerpoint, Access, Notes 8.5.1, Vista, XP, The ONLY fix I have been able to do is create a regfile with the following: File is attached below, change txt to... Search keywords - mail recipient greyed out, send to in missing excel 2003
Excel, Word, Powerpoint, Access, Notes 8.5.1, Vista, XP,

The ONLY fix I have been able to do is create a regfile with the following:
File is attached below, change txt to reg.

------------------------------------------------------------------
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows Messaging Subsystem]
"InstallCmd"="rundll32 setupapi,InstallHinfSection MSMAIL 132 msmail.inf"
"MAPI"="1"
"CMCDLLNAME"="mapi.dll"
"CMC"="1"
"MAPIX"="1"
"MAPIXVER"="1.0.0.1"
"CMCDLLNAME32"="mapi32.dll"
"OLEMessaging"="1"

-----------------------------------------------------------------------
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows Messaging Subsystem\MSMapiApps]
"inetsw95.exe"=""
"choosusr.dll"=""
"msab32.dll"=""
"nwab32.dll"=""
"outstore.dll"="Microsoft Outlook"
"newprof.exe"="Microsoft Outlook"
"outlook.exe"=""
"wfxmsrvr.exe"="Microsoft Outlook"
"msexcimc.exe"=""
"exchng32.exe"=""
"schdmapi.dll"="Microsoft Outlook"
"pilotcfg.exe"="Microsoft Outlook"
"mailmig.exe"="Microsoft Outlook"
"admin.exe"=""
"msspc32.dll"="Microsoft Outlook"
"cnfnot32.exe"="Microsoft Outlook"
"ilpilot.exe"="Microsoft Outlook"
"events.exe"=""
"ilxOlkCompanion.fil"="Microsoft Outlook"
"ilxolk.fil"="Microsoft Outlook"
"ilxolk_aux.dll"="Microsoft Outlook"

Attached Files

Mail.txt (1.9 KB)

]]> General Discussion PGlenn http://www.wordbanter.com/showthread.php?t=146399