Pages

Search

Microsoft Word - VBA Module "in two places"

Microsoft Word - VBA Module "in two places"

VBA Module "in two places"

Posted: 13 Mar 2014 03:26 PM PDT

My Word application has two templates which are identical except that one is US English and the other is UK English.  So far everything has been OK because all my VBA code has been stored in Normal.dot.

Now I am trying to get my head around Modules, because I'd like to be able to distribute these templates in the future.

Can I make a Module in some way "appear" automatically in both templates and have any VBA code changes I make in one automatically reflected in the other? Actually I only need this during development, but it might be generally useful.

Send to Mail Receipient button in Quick Access Bar grayed out

Posted: 13 Mar 2014 03:05 PM PDT

I have MS Office Home and Student Version 2010. I  am trying to send a Word document in the body of an email. The document contains a photo. I customized the Quick Access Toolbar to add the command "Send to Mail Recipient". When I open the Word document I want to send, the Send to mail recipient button is grayed out.  I went into control panel and did a repair on the MS Office Student and Home, but the command is still grayed out. How can I get this to work? Also does this command work for other formats such as PDF or XPS documents? Thanks. *** Email address is removed for privacy ***

default document properties

Posted: 13 Mar 2014 03:02 PM PDT

Hi,

I would like to ask a couple of questions about setting default document properties. (1) I would like to set "subject" field to a default  value of MLSC 1115. Can I do this or do I have to edit that field every time I create a document? I know that some of this needs to be done by a registry edit, but I can't find "subject" in the registry. 

(2) what is the proper way to enter my degrees after my name in the author field? Everytime I try to do this it thinks I am trying to enter multiple authors. For example what if I wanted my name to appear as: Joe blow BSc, MSc, MD ?

Thanks. Tom

Linked Word/Excel: Changing Excel Source File path

Posted: 13 Mar 2014 02:58 PM PDT

Greetings,  

I use a linked word/excel document with 140 or so linked places.  When I email the Word and Excel or move them to a new location, the links no longer work (of course).  The way I change it is hitting Alt-F9 then Find/Replace the file name for the old excel document with the file name for the new excel doc.

So the excel name when I hit Alt-F9 is something like: C:\\Users\\vm\\desktop\\template\\template.xlsx.  

Is there somewhere I can go that shows the source path for the Excel document that uses two backslashes like the above?  Currently, I right click on the Excel file, click Security, then copy the "Object name".  However, that only includes one backslash (i.e. it would be like the above with single backslashes: C:\Users\vm\desktop\template\template.xlsx), so then I have to add a second backslash when I paste to the find/replace box in my Word document.  A minor inconvenience, but I thought perhaps there is a way around it...

Thanks in advance!

Linked Word/Excel: Want to Highlight all linked text

Posted: 13 Mar 2014 12:59 PM PDT

Greetings,

I have a Word document that has about 140 sections linked to Excel.  I want to be able to highlight all 140 places quickly (they are generally a few words or numbers long).  How can I highlight all linked sections quickly and easily?

Thanks!

Underlining tab in numbered list

Posted: 13 Mar 2014 12:59 PM PDT

Hi,

I can't seem to find a way to underline the tab between the number and the title in my automated list.

It used to be in the 'Options', 'Advanced options' menu in Word 2007, but Word 2013 doesn't have it.

My lists all look like this:

1.  First Title

2.  Second Title 

But they should look like this:

1.  First Title

2.  Second Title

Anyone know how to do it?

Legal size document that will only come up as Letter size on a legal document.

Posted: 13 Mar 2014 12:22 PM PDT

 I have removed Header and Footer and set the page as Legal, however the text is still on the page as if it were a Letter document. I cannot get it to pull the text up from the next page.

Passing arguments to Word Starter 2010

Posted: 13 Mar 2014 11:09 AM PDT

Hello there.

I need to pass an argument to open a file with Word Starter 2010. I see that the application launching Word is CVH.EXE which take a string as argument:

 "C:\Program Files (x86)\Common Files\microsoft shared\Virtualization Handler\CVH.EXE "Microsoft Excel Starter 2010 9014006604090000" 

I tried to make a batch file adding %1 to the string:

word.bat:

@echo off "C:\Program Files (x86)\Common Files\microsoft shared\Virtualization Handler\CVH.EXE "Microsoft Excel Starter 2010 9014006604090000" %1

echo on

if I pass the absolute path it works:

  • word.bat c:\documents\document1.doc

but if I pass the RELATIVE one, it doesn't

  • word.bat document1.doc

since for some reason it adds "c:\windows\" to the path and Word Starter 2010 says: "impossible to open c:\windows\document1.doc".

Is there a way to get rid of this problem? Thanks you all in advance!

How to change a color within a style?

Posted: 13 Mar 2014 10:42 AM PDT

hen I change the color selection within a style, it shows all of the colors in the "palette" but for a given style, I can't seem to change.  What I'm looking for is the ability to change the color to another within that palette.  I can change the font color, but some have background colors as well that I can't seem to change - screen print below, hopefully will clarify.  Thanks in advance!

Word 2013 Zoom feature

Posted: 13 Mar 2014 10:29 AM PDT

With previous versions of Word, if I zoomed out to 10% I received an application window like the following.

Now with Word 2013, I get something more akin to this,

Is this a limitation of my video card or simply the new way of doing things? Is there an option that I can set to receive the older arrayed display of pages? Does it have to do with Word's close association with OneDrive?

Not a deal breaker but I'd like the old array of pages back.

Edit Header Causes Header to Disappear

Posted: 13 Mar 2014 09:55 AM PDT

I have a Word document that includes headers and footers. I normally work in Print Layout view and can see the Header and Footer text in this view. They are also visible in Print Preview and on the printed copy. When I try to edit the Header or Footer, the text disappears. If I click Show/Hide, a single paragraph mark is displayed.

Any ideas?

How to stop Word 2013 from autocorrecting my words

Posted: 13 Mar 2014 09:06 AM PDT

I'm using Word 2013 on a Windows Surface RT (8.1) and finding Word 2013 extremely annoying. The autocorrect function is causing unnecessary headaches. I'm a writer of historical fiction, so I'm using some foreign terms. Word 2013 corrects every single one of them, no matter how many times I hit undo or have disabled every aspect of autocorrect that I can. I would appreciate any assistance on how to prevent Word 2013 from making a mess of my manuscript.

Unable to make MS OFFICE 2013 background permanent...

Posted: 13 Mar 2014 08:31 AM PDT

I frequently use word, power - point and the others, so, I need a change now in the office. As a result I was customizing word. Whenever, I select the "background" into an option like - "Calligraphy" it gives the background for a time being, but as soon as I closes word the background is turning to "No background". How to make this change permanent??? Please help.....

Divide Landscape into 2 pages

Posted: 13 Mar 2014 08:27 AM PDT

Hi all and thank you for your help.

I need to print programs for a sports event.

A4 Landscape

How do I divide the page in 2 x A5 pages so that I can add content onto both sides as if it was 2 x A5 pages?

Please help me out.

I need to replace a strings of two characters with one exotic Unicode character. Doc is 700,000 words

Posted: 13 Mar 2014 08:26 AM PDT

Greetings. I have a 700,000 word document which uses two character combinations such as s* or i^ to stand for an s with a dot underneath or an i with a macron (line) above it. There are sixteen different combinations which exist throughout the document (upper case and lower case transliterations for foreign alphabet characters). I want to replace each of the sixteen different two character stand-ins with the correct Unicode character for each of the sixteen cases. The Unicode characters exist. I realize it will take sixteen operations. What is the procedure for each of these global replacements?. While we are at it, I also need to change 1,600 words, all different, scattered throughout the document which have a code at the beginning of the word and at the end, a code which may be customized as needed, these words I need to change from normal typeface into BOLDFACE (without manually changing each one.) Can this be done within Word or is this a manipulation to the file outside Word? I actually write in a DOS processor and these files were converted to RTF to be read by Word. Now I want to take the final step and use the possibilities of WORD to make a more sophisticated publication ready document. Thanx

BOOK BINDING LAYOUT

Posted: 13 Mar 2014 07:56 AM PDT

Dear Sir,

   I am approaching your goodself for a help to sort out a problem being faced on MS word 2013 involving page layout. I want to convert a document in A4 size to book form. But on choosing book form option and 'Auto' for 'sheets per page', print out becomes too narrow consuming extra pages(scanned copy of print out sample attached for your ready reference). I have tried to decrease the margins by changing gutter but this decreases inside margin thereby shortening binding space. I have searched the net also but did not get a suitable solution.

What should be the ideal margins and how are the normal margins related to those for book form? What is the function of sheet per page?

So I request you to kindly offer your expertise so that I can print the book with a proper layout having smaller but suitable margins.

Thanking you and expecting your help and co-operation at the earliest.


R K Bhattacharyya

Word section breaks to force pages

Posted: 13 Mar 2014 07:54 AM PDT

Hi there

How would I force a particular page of a document ie. the first actual page of a document after cover and index, to always print on the right hand side (or always the next odd page of the whole document).

Odd page section break is not the thing as it is already an odd page as I insert a next page section break and restart page numbering so it is always page 1 of section 2 or 3.

The problem is we have started printing all documents double sided and if the contents run over more than 1 page then we end up with the actual first page of the document printed on the back side of the contents page which is not acceptable.

Is this possible at all please anyone - I have really struggled with this!

I don't seem to be able to do it with section breaks - what about an escape code or something that inserts a blank page (preferably not visible to the users) if the last page of section 2 is odd so it misses a page then starts on the next odd page (f the whole document).

I can't believe this has not been done already and would appreciate some guidance.

Many thanks

GwenR

Mail Merge and Printing

Posted: 13 Mar 2014 06:56 AM PDT

Hi

I have to create lots of mail merged letters and each batch will have the same number of pages but each batch can have a different number of pages depending on the letter at the time.

I need to have the first page as letterhead and all other pages as plain paper. These will all be single sided sheets.

I have set up our printer as shown in the attached image with Drawer 3 being letterhead and other drawers are plain paper

eg I currently have a 1 page document with 20 merged names and addresses so in this instance every copy should be on letterhead. I have tried various permutations of p1s1-P1s20 or P1s1-P20s20, etc and i get one page on letterhead and the rest on plain paper

Similarly if i had 20 x 3 page letters I need Page 1 from each letter on letterhead and Pages 2 and 3 on plain paper.

Can anyone assist with this please

Regards

John

Remove Text from Chapter heading

Posted: 13 Mar 2014 06:21 AM PDT

I am creating a document that includes importing other documents, 1 of these has text in the Level 1 headings, for example: Section 1 Start of Day Session 

How do I remove the word Section for the heading? I have opened the Styles option to remove but can find where I can do this. Any help is appreciated.

Thanks Jimmy

Word Mail Merge - Embedded hyperlink not working in IF Formula

Posted: 13 Mar 2014 06:18 AM PDT

Hi,

I have add a hyperlink to an IF formula within a mail merge, but once I press AltF9 to return to the actual letter the hyperlinks aren't active links. Please could you advise me on why this might be.

Thanks in advance

Amending spelling corrections

Posted: 13 Mar 2014 05:56 AM PDT

I have, by mistake, added "taht" to my dictionary, by clicking "Add to Dictionary" while using the spell checker.  How do I get it out of my dictionary again?

2 table of contents in 1 document and problems for a heading style to be recognised in both

Posted: 13 Mar 2014 04:01 AM PDT

I am having problems to define, in the same word document, a general table of contents and a table of contents for an appendix.

First, I defined a new heading style for the appendix, to use an A before the number of the appendix and to be able to start from 1 again (I.e.: A1-1. INTRODUCTION).

Now I have two table of contents, one at the beginning, and other for the appendix (bookmarked section). I marked headings in the appendix with the "Add text" command (Menu References) and they show up in the general table of contents, but they do not show up in the table of contents of the appendix. I have no idea what should be done, since I've tried to do something and the only way for the text to appear in the appendix table of contents seems changing headings to a general "Heading 1" style. Of course I want to use my own "HeadingApp 1" style, which appears with no problem in the general table of contents.

Please someone lightens me and tell me which is the problem with adding table of contents, applied to one bookmarked section.

Thanks in advance!!

Comments showing as 'Administrator'

Posted: 13 Mar 2014 03:49 AM PDT

There are a number of us working on a document and we tend to use comments within the document in Word.  There is a mix of Word 2010 and Word 2013 working on the document.  When we make comments two editors (one Office 2013, One 2010) have their comments shown with their names and two (again one 2013, one 2010) have their comments shown as 'Administrator'.  This is in a work environment with full domain authentication, and at the top right corner and in File>Account of Office 2013 it is showing the correct user information.

This causes issues on working out who's made which comments, can anyone shed any light on this, and how we may potentially fix it?

Laurie

Two or three-column footnotes in a one-column page layout

Posted: 13 Mar 2014 12:09 AM PDT

My page layout is single-column and I want it to be that way; but, as the text has many short footnotes, I want them to be in two or three columns. Is this possible, if so, how?

How to colour edge of page (Strip) in Word

Posted: 12 Mar 2014 10:07 PM PDT

Hi Everybody,

Office word 2010

Win 7

i want to colour out side margin

as like in

here combination of grey & Light blue Strip

Plz. Suggest

Thanks in advanced

Ravi Vare

Can't open document due to unspecified error after using equation editor. Please Help!!

Posted: 12 Mar 2014 08:47 PM PDT

Hello computer experts,

I have been working on a file for a very long time. I used quite the equation editor a lot and I have a feeling this is the problem. Before it shut down, I was not able to scroll to the last page for some reason.

Now I have the error: 

The file *file name* cannot be opened because there are problems with the contents unspecified error change.

When I click details, it says: 

Unspecified error

Location: Part: /word/document.xml, Line:2, Column: 74774 

I have uploaded the file to 

https://www.dropbox.com/s/13weh7hhuaofe3a/lab%20ia%20svistovitch%20boiling%20point%20of%20salt%20water%202014%20grade%2012.docx

My attempt at solution: 

I have looked into xml files and used notepad++. However, I  have no clue what I am looking for/looking to erase. 

I use Microsoft 2007 if that helps

Thanks, 

Tiffany

Deleting not needed lines in a numbered list in forms in Word 2003

Posted: 12 Mar 2014 08:18 PM PDT

In one part of my form there's a list of attachments.  This list is automatically numbered followed by whatever the corresponding attachment is ie

Attachment 1 Briefing Documents/Package

Attachment 2 Initial Project Report

Attachment 3 Project Program

Attachment 4 Environmental Checklist

Attachment 5 Photos

(My list allows for 16 attachments).

If the user isn't intending to include the particular attachment, he/she deletes it but this leaves "Attachment x" and the rest of the line is blank ie

Attachment 1 Briefing Documents/Package

Attachment 2 Initial Project Report

Attachment 3

Attachment 4

Attachment 5 Photos

What I need is this:

Attachment 1 Briefing Documents/Package

Attachment 2 Initial Project Report

Attachment 3 Photos

Can this be done and if so, how do I do it?

Add Word Table with Formatting

Posted: 12 Mar 2014 08:18 PM PDT

Hi,

I would like to use a Macro to create a new Table with formatting.

Here is what I would like to do, I have split is into 2 parts, but if it is better to only use 1 part then that is fine...

Macro Name = Add_Programme

Ask Questions:

1. Please enter the Programme Name: {ProgrammeName}

   Default = Programme Name

2. Please enter Season Number: {SeriesNumber}

   Default = n

3. Please enter total number of Episodes: {TotalEpisodes}

   Default = 1

Then…

Goto End of Document [CTRL+END]

Line Feed/Chr(11) [Count = 3]

Table = 4 Rows by 3 Columns

Table Alignment = Center

With this formatting:

Row1 ~

        Height = 1cm

        Merged (3 Columns)

        Width = 5.74cm

        Text Style = Heading1, Programme Name

        Fill = 8 to Right, Down 1 <Any Colour will be fine, as I can just change the number to my colour>

        Text = {ProgrammeName}

        Top/Bottom = Centred

        Left/Right = Centred

Row2 ~

        Height = 0.6cm

        Merged (3 Columns)

        Width = 5.74cm

        Text Style = Sub-Title

        Fill = 7 to Right, Down 1 <Any Colour will be fine, as I can just change the number to my colour>

        Text = "Season " & {SeriesNumber}

        Top/Bottom = Centred

        Left/Right = Centred

Row3 ~

        Height = 1cm

Column1 ~

           Width = 1.74cm

           Text Style = Sub-Title

           Fill = 7 to Right, Down 1 <Any Colour will be fine, as I can just change the number to my colour>

           Text = Episode

           Top/Bottom = Centred

           Left/Right = Centred

Column2 ~

           Width = 2.6

           Text Style = Sub-Title

           Text = "Recorded" & Chr(11) & "Date"

           Top/Bottom = Centred

           Left/Right = Centred

Column3 ~

           Width = 1.4cm

           Text Style = Sub-Title

           Text = Seen

           Top/Bottom = Centred

           Left/Right = Centred

Row4 ~

        Height = 0.5cm

Column1 ~

           Text Style = Episode

           Text = 1

           Top/Bottom = Centred

           Left/Right = Right

Column2 ~

           Text Style = Recorded Date

           Text = ""

           Top/Bottom = Centred

           Left/Right = Centred

Column3 ~

           Text Style = Seen

           Text = ""

           Top/Bottom = Centred

           Left/Right = Centred

So I get the following table:

Place Cursor into the final Cell (Row4, Column3)

Then "Insert Rows Below" using ({TotalEpisodes} - 1)

And enter text as 2 to {TotalEpisodes} from Row5 to {TotalEpisodes}

So I get the following table if {TotalEpisodes} = 4:

Thank you in advance,

Neil

using word 2013 when printing a table I have to reset "list markup"

Posted: 12 Mar 2014 06:16 PM PDT

After typing a 3 column table when I try to print it the pre-print shows a smaller table with the right side having a rectangular  "grey scale" area and if I continue by clicking print this is the way it prints (smaller with the right side having a grey scale rectangle). if I select "settings" "document info" drop-down shows,

"print markup" checked. if I uncheck it the table becomes normal size and prints ok.

how can I remove the "print markup" 

Show built in style

Posted: 12 Mar 2014 04:30 PM PDT

I frequently use the Heading 4 built in style. However, only Headings 1, 2 and 3 appear in the style list. How can I make it always appear in the list?

French proofing tools

Posted: 12 Mar 2014 04:11 PM PDT

I need to add French proofing tools to the English version of Office 2013 which I purchased today

Need Help with Mail Merge to Email in Office 2007 and Windows 7

Posted: 12 Mar 2014 03:51 PM PDT

I'm using Office 2007 and have lots of work experience using the mail merge to directory, letters and email. I haven't figured out how to make the merge to email work for me on my home computer. I use yahoo and gmail. I've tried to set up Outlook but it's still not working. Can anyone point me to something that will help me set up Outlook to work with the mail merge?

MS Word Tables

Posted: 12 Mar 2014 03:37 PM PDT

Hi Guys,

Just wondering how to change cell margins for single cells instead of all cells.

Thanks in advance.