Microsoft Word

28K

Solutions

Content

21K

Contributors

Microsoft Word is a commercial document editing program that is part of the Microsoft Office suite. It features numerous text-editing tools for creating richly formatted documents, along with tools for the use of macros in Word documents. Word's native file formats are denoted either by a .doc or .docx file extension. Plugins permitting the Windows versions of Word to read and write formats it does not natively support, such as the OpenDocument format (ODF) are available. Word can import and display images in common bitmap formats such as JPG and GIF. It can also be used to create and display simple line-art.

How to use bookmark in Word Vba?

I want to use bookmark in MS word using vba.
There is an excel sheet to find words and replace in document. In the list there are expansion of number units (eg: Hz - hertz) but I want to ignore this to replace in my word doc if its after a number(eg: 90 Hz). If it is anywhere in text then it can replace with its expansion.
So I want to use bookmark whenever it finds "number" before the "unit" and the name of the bookmark can be "autounit_1" for the 1st time it finds then for 2nd "autounit_2" and so on.
Whenever the macro will run it will ignore the bookmark and replace the rest.

My code: it is only replacing whatever is listed in excel. I want to use bookmark in this.

Sub Replace()

Dim xl As New Excel.Application
Dim wb As Workbook
xl.Visible = False
Dim ws As Worksheet
Dim SelectedFileItem As String
Dim FDialog As FileDialog
Set FDialog = Application.FileDialog(msoFileDialogOpen)
Dim lastRow
Dim find_text
Dim replace_text
Dim oCell
Dim r As Range
Dim afile
Dim ExcelWasNotRunning As Boolean
Dim num_chk
Dim bmRange As Range

Set bmRange = ActiveDocument.Bookmarks("autounit").Range

   With FDialog
   .Title = "Select a file"
   .AllowMultiSelect = False
   .InitialFileName = "D:\OneDrive - CACTUS\Documents"
   .Filters.Clear
   .Filters.Add "Excel files", "*.xlsx"
   
    If .Show = -1 Then
        SelectedFileItem = .SelectedItems(1)
        afile = SelectedFileItem
    Else
        MsgBox "You cancelled the operation"
     Exit Sub
    End If
    End With

Open in new window

…

31 Comments

I have a single user who just got a new computer and now can't embed MS Word documents in the OLE field of my Access Runtime application. At first MS Office wasn't licensed, but we took care of that and still have the problem. I disabled click-to-run, turned off User Account Control, went into the Trust Center of MS Word and enabled All controls related to the ActiveX Settings, I also turned off Safe mode. I disabled all but the basic Add-Ins that are working fine on my system. We are going to test disabling Anti-virus tomorrow morning, but wanted to see if anyone could think of anything else that might be causing this effect. I can successfully embed other document types, like MS Excel Worksheets, WordPad document, but MS Word isn't allowing the Insert Object mechanism to embed a .doc or .docx file.

When Windows makes a shortcut Word icon on his start menu, it adds those two little arrows, like a compressed folder, not sure if that's related. Before Office was licensed, he had two little gears instead. He is using Windows 10 Pro, MS Office 2013 without the full MS Access and click-to-run was a background process, but killing that didn't help either.

5 Comments

After a table draw in the Microsoft Word of Office 2016, any two cell merge cells in the middle of the table, cursor can not be inserted into the merged cell and if the merge then any text in that cell is deleted. But this is not the problem in office 2013. This problem is only in Office 2016. The cursor enters the merge cells in Office 2013, but why is the cursor not entering the office merged in Office 2016?

1 Comment

Question by

John L Colee

4d ago

Auto Office/Windows Updates

Anything opened in the browser or any SW i.e. Excel Word packages, although closed prior to the system being shut down, is auto-opened when powering back up - looks like recovery files functionality. Why is it defaulting to this and what to do to correct, many thanks,

2 Comments

Trying to print multiple copies of one page pdf to our copier and no matter how many copies i print it only prints 1 copy.
This printer is installed through our server \\server. I dont want to add this printer directly.

Things I tried:

- Other application like word printing multiple copies - Works
- Uninstalled Adobe reader DC and resinstalled - Same issue
- Deleted this printer and readded this printer from \\server
- While troubleshooting I placed the Print queue small window on the side and watched, as I click print, it only shows Copies Column - 1
- Checked other users in the office with same windows 10 os and same printer installed through the server - no issues printing pdfs multiple copies

What could be causing this issue, for Adobe Reader DC to only print 1 copy even though I am selecting multiple copies ?
What else can I try ?

Thanks

6 Comments

Question by

V M

5d ago

Auto_Open Outlook Macro?

Is there a way to run a short macro every time a new message, or reply message, is created in Outlook?

I would set default tab to 0.25" instead of 0.50; I understand that it is not possible to do this via the underlying MS Word template.

1 Comment

Hi

I have been asked to build a solution that saves documents and messages emailed back and forth in Outlook into some sort
of repository that can then be accessed from anywhere. I am looking for suggestions on the best way to do this using Excel/Outlook/Access VBA code, ASP.net webforms and SQL.

My initial thoughts were to automatically send a copy (CC) message of all Outlook emails to an email address set up specifically for this as a starting point
then either store the documents on the company cloud server or in an ASP.net folder or SQL database.

Thanks

2 Comments

LVL 1

Question by

kixelsyD

6d agoSolved

SharePoint 2016 - Convert to PDF - App

Hello All,
I have been searching for awhile for a SharePoint 2016 app that will convert Docx file to PDF. I have seem some scripts out there for converting using JavaScript, but none work. I have also seen some apps that will do the conversion but cost $1000s of dollars that I can't afford. I believe I can use Word automation services but I am out of my league when programing.

What I need is a way to bulk create PDF files from Word Document in a SharePoint 2016 document library. I hope to use a button to trigger the event.

Thank you,
Abe

1 Comment

Rowby Goren Makes an Impact on Screen and Online

LVL 12

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

I have some specific questions relating to Excel vba, Word vba and MailMerge.

My questions are:
1. I can get this instruction to work from Word vba:
ActiveDocument.MailMerge.Fields.Add Range:=Selection.Range, Name:="FirstName"
I can access a Word document from Excel vba, however this instruction fails. So my question is can this instruction
be issued from an Excel macro?

2. From Word it is possible to format the output of a MailMerge field using Toggle Field Codes. How can this be done from a vba macro? I have managed to do it using find and replace but surely there is a better way?

3. From an Excel macro I can invoke a simple Word macro, with code like:
Set WD = CreateObject("Word.Application")
WD.Run "runTxtConversion", txtFile
For me this works fine so long as there is only a single Word document open.
How can I make it work if there are multiple Word document?

I would be grateful for either direct answers or references to books or on-line documents that can answer my questions.

Many thanks,

Peter

2 Comments

Hi,

I want to create a macro in word which will find words listed in excel and replace the words in MS Word Document.
For example - In my excel the sheet contains 2 columns, 1st column Words_to_Find & 2nd column Words_to_Replace!! The list of words are Abbreviation, (Eg: DBS -Deep brain stimulation) . I want to replace the first instance in the document. Suppose if the full-form is not written in 1st instance the replace it ,
For Eg [ (DBS) has shown wide applications for treating various disorders in the central nervous system by using high frequency stimulation (HFS) sequences of electrical pulses. ]
In the above line DBS will be replaced by Deep brain stimulation but in the pattern of underline word in the above sentence. It will replace the word with "full-form (abbreviation)".
I am attaching Excel and word document.

Thank you.

43 Comments

LVL 51

Question by

Dale Fye

2018-09-13

Prevent users from saving a file which has been opened via Application.Followhyperlink method

I'm working with a client on an application which will display a list of files which are available for a user to review (file types: pdf, Excel, Word, PPT, Text).

The problem is that after these files are opened:

Application.Followhyperlink pathname\filename

The user has the ability to Save or Save As from the application (Acrobat, Excel, Word, PPT, NotePad, ...) user interface. Is there any way I can open open the files with some form of command line switch which would prevent any of those applications from allowing the user to even see the File option on the application menu? I only want them to be able to view and then close these documents.

4 Comments

Hi,

I have a situation where Windows 10 fails to return a complete search result from a mapped/network drive that consists of mainly Word, PDF, Excel documents.
I re-created index on SBS2011 server to see if it would make a difference, but to no avail.
Some words seems to return a more complete result than some other words. it is just very inconsistent from word to word that is used in search.
is that what we can expect or is there a way to fine tune it?

Thanks.

13 Comments

Hi All!
How to assign a value if cell contains "word" else the word retain?

Below is my sample output

CELL A        CELL B
PPM Triad      PPM
Geo Man      Geo Man
PPM Triad      PPM
PPM Triad      PPM
PPM Triad      PPM
PPM Triad      PPM

3 Comments

How To:

Create a Desktop or Taskbar icon for the online version of Microsoft Word 365
Make .doc & .docx file types open Word 365 online

Summary
I have lost Word 2010 Starter (free, ad-based version offered on limited PCs & laptops) when I had to rebuild a PC. One free option is to use the online version of Word in Office 365. I am using it now, but all my Word files no longer have a default app.

Being able to open a program via icon or double-click on a file is a time-saver. I'm not sure how to set this up, though, for the online version of Word or Excel. Or Outlook, for that matter.

Help!

7 Comments

Question by

Dwci

2018-09-11

Unable to find "Adobe PDF" resource files.

Error on Acrobat PDFMaker from Word in office 2016

Unable to find "Adobe PDF" resource files.

"Acrobat PDFMaker"

You must have Administrator priveleges to install these files. Please contact your local system administrator.

I have completely uninstalled Adobe 2017 and office and it works for an administrator but gets this message for other user. I have also given them administrative rights and still not a go.

Any direction would be much appreciated.

0 Comments

Hi,

I want to create a Word macro that will check for similar words in two documents and highlight those sentences with more than 6 similar words in 2nd document.
Example: Doc1 contains some sentences and 2nd document contains some sentences, so highlight sentences which contains more than 6 similar words in the 2nd document.

Thank you.

24 Comments

One of our software applications calls up Microsoft Word in order to print customer receipts. Each time a receipt is printed, it halts midway through and we're presented with the attached dialog box. If we click yes, the receipt prints as normal but it really is disruptive to the workflow. Is there any way to suppress this notification within Word or add an exemption of some sort?

We're running Office 365 ProPlus v16.0.10730.20088

6 Comments

Introduction to R

LVL 12

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

LVL 1

Question by

David

2018-09-09Solved

Can not print multiple MS Word .docx files

I can not print multiple MS Word documents (.docx suffix) that are in a single folder, from File Explorer, and the right click menu also does not work in the MS Word Open File dialogue box. All of this used to work when I was creating and printing .doc files, created with Word 2003 Pro. I currently have Word 2016 Pro. What is it about the file extension that determines multi-file printability? Can the same capability be made to happen for .docx files? TIA.

23 Comments

Question by

Basem Khawaja

2018-09-09Solved

start search menu

when I try to search for something that I know it is in a specific word document. That item does not show up in results . I search from start menu. Can someone please help me?

14 Comments

Question by

zachvaldez

2018-09-08Private

Linking to Office 365 using C#

I have an aspx page with s repeater on it using s hyperlink control or (Link Button).What I intend is to click the control and it would open a O365 word document which user can start to write.
Also when completing the document, can the document be saved in a sharepoint site?

0 Comments

How to check a paragraph that it contain both paragraph style and character style in it.

Sample document is attached herewith.

We have to check that paragraph style "ref" and character style is "Volume" exist in the document using VBA macro.

Thanks
CH05_CE.doc

3 Comments

LVL 1

Question by

LD16

2018-09-05SolvedPrivate

VBA Word: manage dotm file

Hello Experts,
I create a .dotm file %appdata%\Microsoft\Word\STARTUP in order to re-run macros.
However when I try to open the file and go the module in which are reported the sub procedure I have the following message:

This is not the case when it comes to excel. I can access to module of xlsb file and add or modify existing procedureS.

How should I proceed to add or modify procedure from dotm file in order to re-run macros for new files?
Thank you very much for your help

2 Comments

Question by

Adil Rasool

2018-09-05

MS Word custom ribbon and Macros

Hi,

What I am trying to achieve here is to create a word template file, which once moved to the "C:\Program Files\Microsoft Office\Office15\STARTUP" folder add a new tab/ group and icons which are assigned to the macros(which simply open document templates.

to this point I know how create a new tab/group and assign macro to it, also know using the organizer we can copy the macro to template and move it to the above folder.

I just don't know how to copy the ribbon settings in the template aswell.

Any help is appreciated.

Thank you.

Microsoft Word

0 Comments

First
Prev
1
2
3
4
5
6
7
Next
Last

Microsoft Word

28K

Solutions

Content

21K

Contributors

Microsoft Word

Related Topics

Microsoft Word

Related Topics