Pages

Search

Microsoft Word - Using Selection.Find.Text with Wildcards in Word 2007 VBA

Microsoft Word - Using Selection.Find.Text with Wildcards in Word 2007 VBA


Using Selection.Find.Text with Wildcards in Word 2007 VBA

Posted: 10 Dec 2013 02:47 PM PST

I am writing a macro to search a document for all instances of [TBR-XXX] and [TBD-YYY] ( X's and Y's are numbers, like 001, 002, etc., and yes, the square brackets are part of the item I'm looking for ). Once I find the instances, I put them into a table along with the corresponding section number from whence they came. 

 

The brackets and the hyphen are throwing me as they are special characters.  I've tried the following ( snippet of code ):

 

Selection.GoTo What:=wdGoToBookmark, Name:="bmStartOfBody"  ' Start at the beginning of the main body section


Selection.Collapse


    With Selection.Find
        .Text = "TB??^#^#^#"
        .Replacement.Text = ""
        .Forward = True
        .Wrap = wdFindStop
        .Format = False
        .MatchCase = False
        .MatchWholeWord = False
        .MatchWildcards = False
        .MatchSoundsLike = False
        .MatchAllWordForms = False
    End With
   
    Selection.Find.Execute

 

My document starts with the word, "The" and of course, the .Text search string above picks up on the capital T and thinks that is the first TBR/TBD item. From there, the whole thing breaks down. 

 

I've also tried the following for the .Text string:

 

"[TB??^#^#^#]"    (same result)

"\[TB??^#^#^#\]" (Same result)

"[[]TB??^#^#^#[]]" (Didn't work)

 

But when I used, "[TBR?^#^#^#]"  I found all the TBR values.

 

I could simply search for the TBR values and then the TBD values, but I'm just curious about the correct way to do the search using a string with the wildcards in there. Hopefully someone can shed some light on this for me. Thanks! By the way, I tried using the ^# with the "Find" feature in word with the "Use Wildcards" selected just to see if I could learn anything from the built in feature, but it said it can't use the ^# wildcard in a find using the built in feature. Ugh.


 

Really strange problem with bulleted lists

Posted: 10 Dec 2013 02:45 PM PST

I created a custom bulleted list a while back, using the process outlined here: http://shaunakelly.com/word/bullets/controlbullets20072010.html. It worked beautifully for the last three months. However, spontaneously starting today, whenever I click on the list style to use in my document, it won't let me tab over. It's not that the cursor moves and the bullet symbol doesn't; the tab key just doesn't work. This problem doesn't exist for the default bullet style.

When I open up an old document, the custom style works if I continue a list that I created before, but it doesn't work if I go to the top of the document and make a new list with the custom style. I also tried comparing the custom list styles of an old document and a new one, but there is no difference.

Also, if I start a new document and tab over a couple of times (so that I am not on the lefthand margin), and then apply my custom style, I can use the tab and shift-tab keys to move left and right. However, if I move the bullet all the way to the lefthand margin (the first-level of the list), the tab key stops working again. It's driving me nuts -- I can't make my outlines for my exams. Help!

Can't remove internal hyperlink to bookmark in Word 2010

Posted: 10 Dec 2013 02:40 PM PST

I am composing a document in Word 2010 where I have created bookmarks and hyperlinks to those bookmarks within the document.  Basically, I'm making it easy for the reader to click on a term and be taken to a place later in the document where there is an explanation of the term.

I've run into 2 related problems:

1) When I test the hyperlinks, some do not take me to the bookmarked location, but instead take me -- after a bit of motion on the screen -- back to the very same hyperlink.  In other cases, the hyperlinks work just fine.  There is a pattern here.  When I hover over the hyperlinks that work, I see the complete path for the file plus the bookmark.  When I hover over the hyperlinks that don't work correctly, I see only the bookmark, but not the path.

2) I have tried to remove the hyperlinks that are working incorrectly, but I can't.  When I right click on the link, and then click on "remove hyperlink," nothing happens.  Similarly, if I click "edit hyperlink" and delete the link in the dialog box, nothing happens.

On theory that I have a corrupted file, I tried creating a blank document and pasting the content from the old file into it.  That didn't work.

Help!

Mail Merge Problem - Word using Excel data

Posted: 10 Dec 2013 02:30 PM PST

Why is Word 97 Mail Merge merging in only a few fields from the wrong records contained in an excel 97 spreadsheet? In other words, the letter is merging most of the fields in just fine, but two fields are being pulled in from a different record and merged into every merge as if those two fields had been entered into the corresponding field in each record, which they have not.
There are 62 records in an excel spreadsheet. Word 97's mail merge query is merging only records with a certain person's name in the third field, which results in only the last 8 records being merged. Yet somehow, the 50th and 51st fields in the 48th record are being merged into every merge result as the addressee's first and last name. Those fields are blank in the relevant records, and the conditional field (If statement) has no default value plugging in those first and last names. I don't get it.

How Can I Unprotect Document Only When MS-Word Hidden Table Row Changes Based on Drop-Down Box Selection

Posted: 10 Dec 2013 02:19 PM PST

I currently have six forms that I have combined into one MS-Word document.  The form contains a combo-drop down box so that the user can select the desired form name and its applicable form while all other table rows/forms are hidden.

 

The problem I am encountering is that when I "restrict the document" and the form fields are active, if I attempt to select a different form from the drop-down list, I get error message:

 

            "This method or property is not available because the document is locked for editing"

 

I have listed below the VBA code contained in my document.  I have very limited knowledge in using VBA but I'm almost certain what I desire to have happen is doable......can anyone help?

-----------------------------

Option Explicit
Const OPA = "AWARD OF BID"
Const OPB = "AWARD OF BID-TMUA"
Const OPC = "CONTRACT"
Const OPD = "CONTRACT-TMUA"
Const OPE = "FINAL"
Const OPF = "FINAL-TMUA"
Private Sub Document_Open()
ComboBox1.List = Array(OPA, OPB, OPC, OPD, OPE, OPF)
End Sub

Private Sub ComboBox1_Change()
    If ComboBox1.Value = OPA Then
        With ActiveDocument.Tables(1).Rows(1)
        .HeightRule = wdRowHeightAuto
        .Borders(wdBorderBottom).LineStyle = wdLineStyleSingle
        .Borders(wdBorderLeft).LineStyle = wdLineStyleSingle
        .Borders(wdBorderRight).LineStyle = wdLineStyleSingle
        End With
        With ActiveDocument.Tables(1).Rows(2)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
         End With
        With ActiveDocument.Tables(1).Rows(3)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
         End With
         With ActiveDocument.Tables(1).Rows(4)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
         End With
        With ActiveDocument.Tables(1).Rows(5)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
         End With
        With ActiveDocument.Tables(1).Rows(6)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
         End With
    ElseIf ComboBox1.Value = OPB Then
        With ActiveDocument.Tables(1).Rows(1)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
        End With
        With ActiveDocument.Tables(1).Rows(2)
        .HeightRule = wdRowHeightAuto
        .Borders(wdBorderBottom).LineStyle = wdLineStyleSingle
        .Borders(wdBorderLeft).LineStyle = wdLineStyleSingle
        .Borders(wdBorderRight).LineStyle = wdLineStyleSingle
         End With
        With ActiveDocument.Tables(1).Rows(3)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
         End With
        With ActiveDocument.Tables(1).Rows(4)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
         End With
        With ActiveDocument.Tables(1).Rows(5)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
         End With
        With ActiveDocument.Tables(1).Rows(6)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
         End With
    ElseIf ComboBox1.Value = OPC Then
        With ActiveDocument.Tables(1).Rows(1)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
        End With
        With ActiveDocument.Tables(1).Rows(2)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
        End With
        With ActiveDocument.Tables(1).Rows(3)
        .HeightRule = wdRowHeightAuto
        .Borders(wdBorderBottom).LineStyle = wdLineStyleSingle
        .Borders(wdBorderLeft).LineStyle = wdLineStyleSingle
        .Borders(wdBorderRight).LineStyle = wdLineStyleSingle
         End With
        With ActiveDocument.Tables(1).Rows(4)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
         End With
        With ActiveDocument.Tables(1).Rows(5)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
         End With
        With ActiveDocument.Tables(1).Rows(6)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
         End With
    ElseIf ComboBox1.Value = OPD Then
        With ActiveDocument.Tables(1).Rows(1)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
        End With
        With ActiveDocument.Tables(1).Rows(2)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
        End With
        With ActiveDocument.Tables(1).Rows(3)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
         End With
         With ActiveDocument.Tables(1).Rows(4)
        .HeightRule = wdRowHeightAuto
        .Borders(wdBorderBottom).LineStyle = wdLineStyleSingle
        .Borders(wdBorderLeft).LineStyle = wdLineStyleSingle
        .Borders(wdBorderRight).LineStyle = wdLineStyleSingle
         End With
        With ActiveDocument.Tables(1).Rows(5)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
         End With
        With ActiveDocument.Tables(1).Rows(6)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
         End With
    ElseIf ComboBox1.Value = OPE Then
        With ActiveDocument.Tables(1).Rows(1)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
        End With
        With ActiveDocument.Tables(1).Rows(2)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
        End With
        With ActiveDocument.Tables(1).Rows(3)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
         End With
        With ActiveDocument.Tables(1).Rows(4)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
         End With
         With ActiveDocument.Tables(1).Rows(5)
        .HeightRule = wdRowHeightAuto
        .Borders(wdBorderBottom).LineStyle = wdLineStyleSingle
        .Borders(wdBorderLeft).LineStyle = wdLineStyleSingle
        .Borders(wdBorderRight).LineStyle = wdLineStyleSingle
         End With
        With ActiveDocument.Tables(1).Rows(6)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
         End With
    ElseIf ComboBox1.Value = OPF Then
        With ActiveDocument.Tables(1).Rows(1)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
        End With
        With ActiveDocument.Tables(1).Rows(2)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
        End With
        With ActiveDocument.Tables(1).Rows(3)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
         End With
        With ActiveDocument.Tables(1).Rows(4)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
         End With
        With ActiveDocument.Tables(1).Rows(5)
        .HeightRule = wdRowHeightExactly
        .Height = ".5"
        .Borders(wdBorderBottom).LineStyle = wdLineStyleNone
        .Borders(wdBorderLeft).LineStyle = wdLineStyleNone
        .Borders(wdBorderRight).LineStyle = wdLineStyleNone
         End With
        With ActiveDocument.Tables(1).Rows(6)
        .HeightRule = wdRowHeightAuto
        .Borders(wdBorderBottom).LineStyle = wdLineStyleSingle
        .Borders(wdBorderLeft).LineStyle = wdLineStyleSingle
        .Borders(wdBorderRight).LineStyle = wdLineStyleSingle
         End With
    End If

lbl_Exit:
  Exit Sub
End Sub

On startup windows 2013 products attempt to recover data and then crash.

Posted: 10 Dec 2013 11:44 AM PST

Upon launching word 2013, a window pops up saying the that "Microsoft Word is trying to recover your information..." Below that it states that "this might take several minutes" The only option presented is cancel. Within a few seconds of this window appearing it closes on its own. I've looked in task manager and it appears that the program actually closes instead of just going into the background. I've tried restarting my computer and running the program as an administrator without success. I am using windows 8. A similar process occurs when I attempt to launch my other office programs. I've tried searching the internet for similar problems, but have not found anything that describes my problem.  If anyone could provide assistance or even a link to a possible solution that would be much appreciated.

Docx documents display as a white rectangle in Office 2007

Posted: 10 Dec 2013 10:50 AM PST

Hi.  This question has been asked before but the answer as noted here:  http://answers.microsoft.com/en-us/windows/forum/windows_7-desktop/all-docx-icons-are-displayed-as-white-rectangle/8f2199e9-5c1d-43dc-afcb-9ce7515e5eada  by Ramesh Srinivasan  REG file here

referred to a fix for Office 2010.  Will this same fix work for 2007?  If not, can someone provide a similar solution for 2007?  The 2010 users seemed very happy with the results and I have the same issue in 2007 after migrating to Windows 7.

Thanks,
Tom

need help with macro for Word

Posted: 10 Dec 2013 10:43 AM PST

I am not even sure if this is possible.  I want to find that out before I even waste any time trying to do it on my own.  I am a transcriptionist.  I have reports with a "header" at the top with patient info, IN CAPS, in the middle of a jumble of special characters and codes that are used for importing the document.  I have to enter the patient info lower down in the same document, this time not in caps but Last, First order.  Each document obviously has a different patient name.  What I was hoping to do is create a macro that can look at the patient info I type in the body of the document and populate that, in caps and in the correct order, into the proper space in the header.  Is that a possibility?  Thanks for any help on this.

Pop-up Error Message on MS Word Startup (Office 365 Home Premium)

Posted: 10 Dec 2013 10:32 AM PST

Running Windows 8.1

When double-clicking on a document name in File Explorer I get the following pop-up error message:-


When I click OK the document continues to open up in Word, and seems to be OK. I'm not sure whether it is actually OK as I've been getting this message since product installation.

Any ideas? Is there a problem?


Email attachment issues with MS Word and Windows 8

Posted: 10 Dec 2013 09:52 AM PST

I am working with document in Word 2013 for example, and after I finished working with it, I want to send it as attachment.  But when I select "Share" and then select "Send as Attachment," I get the message that "Word couldn't send mail because of MAPI failure." 


I have MacBook also and I can send from within Word but in Windows 8, it will not let me.  Is the Microsoft Mail program/APP not compatible with MS Office 2013?


Microsoft Word has stopped working" error when you close Word 2013

Posted: 10 Dec 2013 09:48 AM PST

 

 

Each time when I close Office Word 2013,  I receive the below error message: 

Microsoft Word has stopped working


 


Please solve this problem.

 

Regards

 

Suresh Kumar K

Font change in a protected document

Posted: 10 Dec 2013 09:45 AM PST

I have a protected document and most everything works as it should.  Issue is in one line there is a change in the font size.  In unprotect mode, it works fine, but when I protect the document, this font change does not work.  In this one line, users are to have the ability to add text and when they do, I need the font size to stay in a smaller font.  Anyone have this issue too?

Mail Merge from SharePoint 2013

Posted: 10 Dec 2013 08:33 AM PST

Hello,

A user is trying to do a mail merge with the data source as an Excel document, hosted on our SharePoint 2013 site. I came across http://support.microsoft.com/kb/826838, which mentions that performing a mail merge from an HTTP:// location is not supported in Office 2010 and below.

I was just wondering whether that is still the case in Office 2013 running SharePoint 2013. This doesn't seem to be a possibility, but I want to check to make sure.

Thanks for your input!

Dave

Word is squishing all of my text together, help!

Posted: 10 Dec 2013 08:32 AM PST

Well, I don't really know how to describe this, so I took a screen shot, but the text in my Word documents are all squished together. These files were saved and looked normal in the first place, but suddenly look like this:How

How can I fix this?

how to create multi-celled tables

Posted: 10 Dec 2013 08:28 AM PST

i am having an issue with a table i am trying to create in microsoft word 2010 

i want to create  4 column table that has varying numbers of rows, in the first column i want 3 rows the second one i want 3 rows as well but for the 3rd and the 4th i want to have 5 rows in one column and 7 rows in the other, all these numbers include the first 4 columns, i try spitting the table but after the second row it won't let me go any higher than 3 

can you all help me  

2 lines to 1 line spacing

Posted: 10 Dec 2013 07:51 AM PST

How do I change from 2 lines spacing to 1 line spacing

 between messages typed in a letter

Screen view incorrect (Landscape doc appearing in portrait)

Posted: 10 Dec 2013 07:42 AM PST

Hi I've just got the latest Word version and i've opened an older document.  The document has two A5 sized text boxes on a landscape setting.  In the new version it opens it as a a portrait document (so I have to tip my head to read it right).  The text direction is running top to bottom on the screen so I can edit it correctly, but I can't view it right. If I simply try and alter the orientation of the page it turns the page but not the text.

Any suggestions?

Cannot open Word file: The XML data is invalid according to the schema.

Posted: 10 Dec 2013 06:30 AM PST

Dear Support,

Here is another classic..
Editing/correcting my thesis, which is a 166MB, 250+page document. This is a pain as it is, since Word is super slow and freezes all the time.

However, now I can't even open the file any more, since there appears to be an error in the document.xml. 
I tried opening and editing document.xml with Oxygen, but the editor displays 91 errors (!), which even increase when I fix some end tags.
Apparently this has been an issue for quite a while now with Word, with an appropriate fix from Microsoft still lacking.
The live chat support couldn't have been of less use.
Dear Microsoft, do you find it acceptable to have your software randomly smash documents beyond recovery?

Best wishes
Torben

Word VBA - Move cursor to start of current paragraph but don't move it if it is already there

Posted: 10 Dec 2013 06:25 AM PST

I want to move the cursor to the start of the current paragraph. If I do the normal

    Selection.MoveUp Unit:=wdParagraph, count:=1

the cursor goes to the start of the current paragraph, unless it is already there, in which case it moves to the beginning of the previous paragraph.  How do I prevent it from doing that, ie don't move it if it's already at the start of the paragraph.

Is it possible to have an invisible note indicator in the text?

Posted: 10 Dec 2013 05:20 AM PST

Two sequences of notes within one displayed series aren't so bad, assuming a need to present annotations and textual notes on the same page.  (The idea came from this thread.) A great deal can be done to separate the series visually, although not geographically on the page. E.g., the textual notes can be in a different typeface as well as being given different indicators. Whether the custom indicator in the text is always the same or whether it has a little series of its own is independent of the indicator in the second series of actual notes. The indicator in the notes can be even be deleted and yet the note remains! In this case it might be desirable to substitute something else, e.g. a line number. Here's an example of 2 sequences within one display series. I wouldn't really mix the custom indicator * with the line number or  blank indicator alternatives shown below.

57
*
58
59
**
60
     [blank indicator]
61
25 [line number substituted for indicator]
62

I've tried unsuccessfully to use an invisible custom indicator in my text. Fixed spaces aren't accepted. Is there such a thing as an invisible indicator in Word? I seem to recall that it was in another program.

Double direction font change

Posted: 10 Dec 2013 04:24 AM PST

Sometimes I use multiple changes of font direction in one place. Is there a possibility to change font characteristics for one direction only? The problem I have that one of directions is italic, and when I turn it off, this turns on italic on other direction, and vice versa. Tried to make global replace of font format - does not help. Thank you.

Word 2010 Not Replacing misspellings!

Posted: 10 Dec 2013 01:18 AM PST

Hi,
My installation of Word has developed the habit of highlighting misspellings, presenting me with a list of alternatives and then NOT replacing the misspelling with the selected word. It does not always make this mistake but I cannot see a rule in its error. So, for example, in the above sentence I made three misspellings. Word identified all of them but only made the correct substitution once, on the last of the three. It has now gone back to not making the substitution.

All help gratefully received!

George

Automatically add a new row when reaches the last row (WORD 2010)

Posted: 10 Dec 2013 12:00 AM PST

Automatically add a new row when reaches the last row (word 2010)

I made a table in WORD 2010 and put 3 rows in it.
What i want is that if a user reaches the last row (no matter what cell in the last row), its automatically add a new row.
Or a Button when pressed is adding a row.

I hope this is possible and thank you very much.

p.s, sorry about my english if i have spelling mistakes

How to stop list of recent documents from disappearing in Word 2010

Posted: 09 Dec 2013 11:38 PM PST

The list of recent documents that are supposed to appear when I click "File>Recent" always disappear after a while of staying there. I'm not sure what triggers it. This had never happened in Word 2007. Is Word 2010 clearing the list after a set amount of time has past? How do I prevent that from happening?

Paragraph numbering - related to heading numbers

Posted: 09 Dec 2013 08:58 PM PST

How do I create paragraph numbers based on the heading number?

For example:

1.0  MAIN HEADING (Based on Heading Style)

1.1  Paragraph of text.  More text more text

 

2.0  MAIN HEADING (Based on Heading Style)

2.1   SUB HEADING (Based on Heading Style)

2.1.1 Paragraph of text. More text more text

2.1.2 Paragraph of text. More text more text

 

the "Paragraph of text" I want to autonumber as per heading styles.

 

Thanks in advance.

Regards

Alan

Saved but lost file

Posted: 09 Dec 2013 07:25 PM PST

I recently was working on a paper and saving it to my flash drive. Well my flash drive malfunctioned and now there is no path to the file I lost, is there still a way to retrieve from Word?

Bullet format in Word Web App

Posted: 09 Dec 2013 07:23 PM PST

Hi,

When I want to decrease the indent, while I'm using a bulleted list, in normal Microsoft Word, I just need to press Enter. But in the Word Web App, pressing Enter removes the bullet and goes to the next line, so each time I need to select the decrease indent button. Is there a way to fix this, please?

Thanks!

How to permanently disable 'Don't add space between paragraphs of the same style' option?

Posted: 09 Dec 2013 06:48 PM PST

Hello,

Can someone please tell me whether I can permanently disable the above option in the Paragraph dialog box. I have tried using the Set as Default feature where available, but this makes no difference. Each time I apply paragraph formatting to text in some way, this option is enabled by default and it is driving me mad having to disable each time. The only way around this is to use styles, but this is not always the most efficient option for me. I use both Office 2010 for PC and Office 2008 for Mac, and have not been able to permanently disable this most annoying and poorest of design features from either program. 

Any help or advice appreciated, cheers. N.

Print Area in Word 2013

Posted: 09 Dec 2013 05:32 PM PST

Trying to set Print Area in Word 2013 Windows 7.  Anyone know how or has this too been changed?

New word document opens with small box at top of page

Posted: 09 Dec 2013 05:14 PM PST

Recently every time I open a new document the cursor appears in a small box at the top of the screen. I can type within the box but not outside it. The amount of text I can write in the box appears to be limited.

I don't know how this came to be my default format or what it is or more importantly how to get rid of it. Please help.

Setting Default for Word Documents

Posted: 09 Dec 2013 04:07 PM PST

My default font setting in Word keeps reverting back to Calibri. I set the default for all documents as Times New Roman size 12, and every time I open a blank document it's on Calibri size 11. So frustrating! I've been setting the default by going to the "font" tab and then clicking on the default for all documents in the Normal template. When I open a new document I just click on "Blank Document." What can I do?

Corrupted Office word files

Posted: 09 Dec 2013 02:59 PM PST

What has happened to my word docs? I cannot open them - the icon for these docs is a plain orange/yellow sheet instead of the the normal whote with blue W logo on - this happens on docs I created and saved myself over the past couple years or with a word doc attachment that looks normal on the email but try open in and it says doesnt recognise programme. I then get a Microsoft pop up asking me to upgrade. This Office package (Word Starter 10) was part of my computer when I bought it and has worked fine for the past couple years since new - suddenly this happens - very important docs I cannot get access to.

Anyone know why this has happened and what I do to get the docs back to normal format so I can open, edit save etc.

Performance issues with MS Office and Charter High-Speed Security Suite (aka F-Secure) - Microsoft Office forums

Performance issues with MS Office and Charter High-Speed Security Suite (aka F-Secure) - Microsoft Office forums


Performance issues with MS Office and Charter High-Speed Security Suite (aka F-Secure)

Posted: 30 Dec 2005 12:22 PM PST

No problems here using F-Secure
ie using the f-secure office plugin does give some delay in opening any
office doc, but I dont believe it any more than any office av plugin

"Mike Fink" <com> wrote in message
news:DGgtf.3128$lga... 
(which 
recently 
software 
the 
anything 
and 


bank holidays for 2006

Posted: 30 Dec 2005 01:26 AM PST

Many thanks Milly - That saved me a bit of time! Happy New Year, Dean

"Milly Staples [MVP - Outlook]" wrote:
 

Install Office 2003 to drive other that 'C'

Posted: 29 Dec 2005 06:46 AM PST

Hi Mackman,

While the major portions of MS Office can be installed on a separate drive there are parts that go in the Windows folders and the
Common Files area that are placed on the same drive as Windows.

=========
<<"Mackman" <microsoft.com> wrote in message news:com...
I built a new computer running Windows XP Pro. Everything is working fine.
I want to install Office 2003 on 'D' drive because the 'C' drive partition is
full. When I type in the path for 'D' drive the installer tells me there is
not enough room on 'C' drive and stops. I have tried many times to install
on 'D' drive but it always tells me that 'C' is full and stops. I set up my
hard drive with 5 gigs for the OS on 'C' drive, 145 gigs on 'D' drive for all
the other programs and 150 gigs on 'F' drive for back up and video and music
storage. I reallize now a 5 gig 'C' drive was not enough and am trying to
avoid reformatting the hard drive.

Any help would be appreciated. >>
--
Let us know if this helped you,

Bob Buckland ?:-)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*

For Everyday MS Office tips to "use right away" -
http://microsoft.com/events/series/administrativetipsandtricks.mspx



updating from Millenium to xp for MSN messenger

Posted: 29 Dec 2005 12:59 AM PST

Windows XP Home Upgrade version or Windows XP Pro Upgrade version.

But I am not at all sure why you're asking operating system questions in a
newsgroup relating to problems with Office setup.
--
Cari (MS-MVP)
Printing & Imaging
http://www.coribright.com/windows



"com" <microsoft.com>
wrote in message news:com... 


ms Word 2000 question

Posted: 28 Dec 2005 02:22 PM PST

Perfecto! Thanks again!

Re-Installing MSO2k3

Posted: 28 Dec 2005 07:51 AM PST

Hi Bob, thanks for replying! Yes, I agree that the CMW is the ideal
solution. I'm actually helping somebody do this, and the person won't
be present for several days. My solution would be to use the CMW to
design the changes and then deploy them to the clients, and that's what
I'm going to propose. (That along with an OPS file)

Even though this should solve the issue, my task was to find out 'how
to reinstall office'.

Is it safe to say that you cannot reinstall office using MST,
setup.ini., command line params, but rather uninstall it first and then
reinstall it? I believe that REINSTALL=ALL will mearly pull update
files from an administrative source. Is this correct?

Bill

Setup Files

Posted: 28 Dec 2005 07:46 AM PST

Thanks... found them.

Is it ok if I create a folder "Office Setup files" and move them there?
At least I will be able to find them when I need them.

This started when I tried to get word in office to accept speaking input
about 4 days ago. Now I've totally forgotten how to do that or where I
even saw it. Probably in here somewhere.

John

Bob Buckland ?:-) wrote:
 

Want to upgrade Office 2003 Standard Trial to Office 2003 Professi

Posted: 27 Dec 2005 05:05 PM PST

Thanks DL, all I had to do was uninstall the standard trial and activate one
of the programs and all the other programs converted over to professional
full. I thought I was going to have to uninstall the professional and
reinstall it after I uninstalled the standard trial. Worked great, thanks.

"DL" wrote:
 

Installation hangs

Posted: 27 Dec 2005 09:31 AM PST

You're welcome, Glad I could help :-)
If you rate the reply as helpful other users with a similar problem will be
able to see that it has been solved.


"adanedhel9" wrote:
 

office 2003 professional Installation hangs - no error message

Posted: 27 Dec 2005 09:04 AM PST

Hi DL,
Thanks for the suggestions - I was going to try a repair but noticed that
there was no entry in Add/Remove programs for Office, so when I put the disk
in it started an install. I don't know if it made any difference but this
time I selected a typical rather than complete install and the process ran
through without a hitch. I selected the visit office update option on the
final install dialogue and it noticed I already had the three required
updates which then installed without any problems. I was surprised that I was
not nagged to re-activate the product, so some part of the previous
installation survived.
I left Works and Active sync installed, my next plan was to uninstall
activesync and see if office either returned or would install. I'd rather not
have works on the pc but space is not an issue and I can remove the shortcuts
from the start menu so as not to confuse family members!
I still suspect that office may be gone when I get up tomorrow, but the
install was so effortless that I'm hopeful it will still be there.
If not I'll check the install log and see if it had errors.
Again, thanks for the help :-)

"DL" wrote:
 

the feature you are trying to use is on a CD ROM....

Posted: 27 Dec 2005 07:45 AM PST

If i place my office cd into the drive and select ok, the message box
reappears and says the file cannot be found within that cd. Have you any
other suggestions?

"Cari (MS-MVP)" wrote:
 

Installation problem - clip art related

Posted: 26 Dec 2005 05:53 PM PST

Sorry for the confusion. It's Office 2003. Office 2000 appears to have
successfully been removed and replaced by Office 2003.

"garfield-n-odie" wrote:
 

Trying to install Office 2003 in to my Microsoft XP Computer

Posted: 26 Dec 2005 04:53 PM PST

Thank you very much for all the help. Happy Holiday!

"garfield-n-odie" wrote:
 

Start Menu

Posted: 25 Dec 2005 07:47 PM PST

Thanks
"garfield-n-odie" <microsoft.com> wrote in message
news:%phx.gbl... 


I am trying to install Office 2003 and keep getting "Error 1406."

Posted: 24 Dec 2005 09:16 PM PST

Hi Rhonda,
Try the following page:
http://support.microsoft.com/?kbid=321445
It details the cause of your error and how to fix it - Fingers Crossed!
:-)

"Rhonda Mlodinoff" wrote:
 

Setup for Sync Outlook

Posted: 24 Dec 2005 03:53 PM PST

On Sun, 25 Dec 2005 00:10:41 -0000, DL wrote:
 


I looked at several, but will probably try http://www.synchpst.com first
since it seems to be of the KISS mode. I have gotten away with overwriting
the pst in the past, but have never been real comfortable with that
approach.

Merry Christmas and Happy New Year.

I cannot import calendar from Windows 98 computer to XP

Posted: 19 Dec 2005 07:03 PM PST

I don't understand what you mean by an Outlook file. It is not an Outlook
file as far as I know. I did a direct cable connect to move my exported
Microsoft Office Calendar file from my laptop to my desktop.

"Milly Staples [MVP - Outlook]" wrote:
 

HELP! Database Utility no good after archive and install Microsoft Office for Mac

HELP! Database Utility no good after archive and install Microsoft Office for Mac


HELP! Database Utility no good after archive and install

Posted: 08 Jul 2009 08:54 AM PDT


Hello there - I have sorted this - it was a simple fact that the caches folder in my documents was locked after the install. Unlocking it has sorted the problem. Many thanks for your replies!

spanish version of office 2008

Posted: 07 Jul 2009 02:44 AM PDT

On 7/7/09 6:36 AM, in article C6791C04.10E5C%org,
"Michel Bintener" <org> wrote:
 

It doesn't get all files though. See this link to manually remove
everything.

<http://www.entourage.mvps.org/install/remove_office.html>

--
Diane

Scripts in Office

Posted: 06 Jul 2009 12:59 AM PDT


In article <h2sn2j$2o0$org>, mocha99 <mocha99>
wrote:
 

Office uses AppleScript, but I am not clear on the similarities and
differences. Microsoft has said VBA will return in the next major
Office release.

Microsoft Office 2008 WILL NOT INSTALL!!

Posted: 05 Jul 2009 07:10 PM PDT

> Funny thing is I can't even check if I'm an Admin account because my laptop is so messed up. Every time i click accounts in system preferences, it crashes.

In System Preferences (before clicking Accounts), try going to Security, then check the box to "Require password to unlock each secure system preference", then close and and re-open System Preferences and see if you can open Accounts without the crash.

I would also go to Utilities (in Finder, in Go menu, or in the Applications folder) and then run Disk Utility, then select your hard drive and then go to the First Aid tab/pill and click the "Repair Disk Permissions" button and after that is finished, see if you can't install Office.

Clip Gallery

Posted: 05 Jul 2009 06:45 PM PDT


Thanks Bob,
Maybe you missed the original post in this thread. My problem is that Clip Gallery for Word 2008 doesn't retain keywords for graphics downloaded and imported from the MS clipart site.

As you suggest, I always access Clip Gallery "using either Insert> Picture> Clip Art or the Insert Clip Art button on the Drawing Toolbar." The issue is that Clip Gallery doesn't preserve keywords for imported graphics, making searching for appropriate art much more difficult.

I've recently discovered another workaround as well:

I only import clipart into Clip Gallery for MS Office X, and occasionally I copy the contents of the "Personal" clipart folder for Office X over the "Personal" clipart folder for Office 2008. This has worked like a charm. I can use Clip Gallery for Office 2008 with all keywords preserved for imported art.

Best,

kjsjp

Office Serial Number

Posted: 05 Jul 2009 08:26 AM PDT


In article <caR9absDaxw>,
com wrote:
 

Barbara, the reason some people ask this question is some software uses
online activation to prevent you from installing more copies than your
license permits. If you intend to remove the software from a particular
computer, you have to signal this to the online servers to reclaim your
license key.

This is NOT the case with Office for Mac, which does not use online
activation.

Can't update Office 2008

Posted: 05 Jul 2009 01:35 AM PDT

Hi William,

Hmm... tried that but no go... Finally found that changing the MTU on the router and in Network settings to 1492 magically sorted it (previously set to the default of 1500). Talk about weird voodoo!

Thanks for the suggestions and the kind help. Cheers
Ziggx

AutoUpdating Office X

Posted: 04 Jul 2009 08:31 AM PDT


On 7/4/09 8:31 AM, in article caR9absDaxw,
"com" <com> wrote:
 

You are fully updated. Microsoft does not update each application with
updates. See Confused over Microsoft Update Version numbers?

<http://tinyurl.com/cwf8bk>

The true test of any upgrade is the Microsoft Component Plugin. It's
always updated.

Office for Mac X is end of life. No further updates will be issued.

--
Diane



Office 08 works only for one user

Posted: 02 Jul 2009 07:02 PM PDT

OS X 10.5.7
Office 12.1.0

I installed all updates but to no luck. I am not sure what the Spaces feature is that you speak of. When logged in under one user everything still works fine but when I log out of that one and into the other, no good. As soon as you open Word in opens in print layout but looks different. The page is all the way at the top and you cannot type. If you switch the draft you can type. Totally lost.

Shaun

Simple question about weird behavior of the HELP window in Excel

Posted: 02 Jul 2009 05:10 PM PDT


Hi Peter;

Very glad it's been corrected. And not to chastise in any way, but it would
have been remedied sooner if you had mentioned in the original message that
the Title Bar wasn't visible & that the help window covered the entire
screen... I'm afraid we can only go by what the user describes, so starting
with the basics is often necessary until the situation is fully disclosed.
I, for one, don't automatically recommend trashing prefs or .plists or
anything else until I'm reasonably sure that it's warranted :-)

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 7/4/09 3:20 AM, in article caR9absDaxw,
"com" <com> wrote:
 

updating Office 2008 from 12.0.0 to 12.1.0

Posted: 02 Jul 2009 06:45 AM PDT


Going to Help> Check for Updates is the typical method. It's virtually
automatic from there. If you're having some sort of problem nobody can
really offer any meaningful suggestions unless you describe exactly *how*
you have been trying and exactly *what* the results have been. Otherwise
it's just a guessing game.

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 7/2/09 9:45 AM, in article caR9absDaxw,
"com" <com> wrote:
 

Installing an upgrade to a new Mac

Posted: 01 Jul 2009 11:37 AM PDT


Yes, your expectation is correct. The upgrade packages are actually full
versions but need verification of a prior version in order to be installed.
The older version need not be physically on the Mac being upgraded as long
as you have the previous source disk. Just make sure that if a trial version
of Mac Office exists on the new systems that you run the Remove Office
utility to get rid of it before installing the software.

--
HTH |:>)
Bob Jones
Office:Mac MVP

<com> wrote in message
news:caR9absDaxw... 

Another user using Microsoft Office

Posted: 01 Jul 2009 07:18 AM PDT


Adam

Many thanks. This sorted it!

Thanks
Robert