Microsoft Word

28K

Solutions

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.

Share tech news, updates, or what's on your mind.

Sign up to Post

Structure of the Query
I would like to pass multiple parameters, from Word VBA, when prompted to [EnterCriteria] in the above query. For example, I might want results from all the departments listed in the database, or I may want only results for 'Engineering' and 'Development' ("Engineering" or "Development"). Is that possible or will I have to put the SQL query into my VBA code and pass the parameters that way?

Many thanks for your help.
0
I'm wondering if someone can come up with a formula solution for the following:

I have a table where I import my bank transactions. I want to use formulas in an adjacent column to check for keywords (which are located in a separate table) in those transactions and then replace them with those keywords (so I can then further act on those result by categorising them etc.).

For example, a transaction to Amazon might look like this: Amazon Marketplace 0065468, or like this: Amazon Mktplc 0066 etc. The keyword here is obviously Amazon. I have a separate table with 2 columns: Column 1 is the keyword to find, column 2 is the value to replace that keyword with. They are identical: I want Excel to check if the entire text string imported by the bank has the word Amazon, and if it does then replace it in the next column with the word Amazon.

The key problem here is obviously that I need the formula to check 1 text string against multiple keywords. I've tried many combinations of Index, Search and Substitute formulas but none seem to work.

I should note that I have achieved this result with a very long IFS formula, where for each keyword I add another ISNUMBER(SEARCH("Keyword", "Replace with keyword")) part to the formula, but this means I have to manually keep editing the never ending formula for each new keyword. As above, I am looking for a more efficient and streamlined way of doing this by way of a lookup table with the keywords.

I attach here a sample …
0
Hi Experts

I have a reasonable amount of experience in customising the Ribbon using the CustomUI editor and using VBA to dynamically populate menus. However, I just cannot seem to get my head around what I need to do to add a new Menu to an existing custom Tab using VBA.

I want to have a blank, already created Tab - I have already done that in the Custom UI editor.

I want to programmatically add new menu items to that Tab using VBA.

It would be useful to be able to know how to add a Tab programmatically as well but that is not essential.

Many thanks in advance for your help.
0
From vba in Microsoft Access, how can I open a form saved in a word .docm document and set a textbox on the form to a value?

So far I have:

    Dim objwrd As New Word.Application
    Dim doc As Word.Document
   
    Set objwrd = CreateObject("Word.Application")
    objwrd.Visible = True
    Set doc = objwrd.Documents.Open(FileName:="C:\Users\db1\Documents\Test.docm", Visible:=True)

I know if I'm running code contained in the Word document I can do something like this

Dim frm As New UserForm1
frm.Show

But this code is automation code running in Microsoft Access and I don't see a forms collection in the Document object.
0
Hello,
When you go to page "eliesgrill.com"  you will see the below show up before the page.  Any suggestions how to remove this, and what it is?

Notice: The called constructor method for WP_Widget in cleanretina_custom_tag_widget is deprecated since version 4.3.0! Use

__construct()

instead. in /home/mediterranean1/public_html/wp-includes/functions.php on line 4404

Notice: The called constructor method for WP_Widget in cleanretina_Widget_Adsense_Ad is deprecated since version 4.3.0! Use

__construct()

instead. in /home/mediterranean1/public_html/wp-includes/functions.php on line 4404

Notice: The called constructor method for WP_Widget in cleanretina_Widget_ad_block is deprecated since version 4.3.0! Use

__construct()

instead. in /home/mediterranean1/public_html/wp-includes/functions.php on line 4404
0
I notice in Office 365 online, that if you have a word document open, you can switch to desktop easily.  However, is this possible the other way?  While I have the desktop Word app open, can I switch to viewing it in the web browser from the app?
0
Hi we have a Word document in which there are a lot words highlighted with color green. We can copy each of them and then move them to another site manually. but we are think if there is a way we can pick them up with Macros function and then move these words to another file? so that would be much more efficient. Thank you
0
Hi there is a Word document in which there are a lot words highlighted with yellow or other color. Do we have a way to pick all of them up with one action or two and to move them to another location in the document? Thank you
0
In my Word VBA toolbars, I use the concept of a "Content Library," where the users sets a location on their local machine or network file share, where all of the resource files such as templates and graphics, for the toolbar are stored.  Once the content library is set, the file path is stored in the user registry where it can be loaded back in and used in future Word sessions without having to be re-set.  A typical content library location might be "G:\My Department\Tools\Content Library"

One of my users for some reason is unable to connect using a drive letter designation, so they asked if they can use an IP Address.  I don't know enough about networking to understand the equivalency between an IP Address and a drive letter network file share.  I suppose if we could determine that "G:\My Department" is equivalent to 999.44.333.11, he could set his content library to something like "\\999.44.333.11\Tools\Content Library."  Would that work?

Any pointers would be appreciated.  Thanks!
0
Hello,

How can you paste a list of hyperlinks from a spreadsheet or table into a Word document and lose the table but retain the hyperlinks?

For example, suppose you have a list of 5 hyperlinks in Excel. How can you paste that list into Word so that the links still function (as links) but are in a simple list rather than a table?

I see several paste options which remove the table but they also remove formatting (including the hyperlink function) and simply leave you with the text.

Thanks
0
I have developed a Global Template in Microsoft Word, a .dotm that sits in the user's AppData\…\Word\STARTUP folder, so it gets loaded every time the user launches MS Word.  The .dotm creates a custom tab in the Word ribbon menu, a toolbar containing numerous automation macro buttons.

I need to do certain checks each time they use the global template, such as making sure they have the latest version, etc.  I am currently triggering these checks by way of the RibbonOnLoad event.  Problem is the ribbon loads when the user first launches the Word application.  

I would rather trigger these checks only when the user switches to my custom tab. Is there a Word VBA Event that fires when the user changes to a certain ribbon menu tab?

My research suggests there is no such event.  But I want to make sure.  If not, is there a workaround to create this same functionality, so I don't have to call the checks at the beginning of every single macro?

Thanks!
0
I create a text box in word.  I insert the page number.   I then copy that text box, complete with the page number, to a new page.  The new page shows the old page number, not the new one.  How can I create a text box with a variable page number that will show the page number whereever I copy/paste that text box?
0
As part of a larger VBA project in Word (2016) , I want to present the user with a list of entries (say five columns and multiple lines) with data from an Access database.  This will be displayed in a WORD VBA User Form.  

I can populate the table fine and I can re save the entries to the database. What I need to know is how I can make the table/list editable so that  the user can correct or change the entries before the whole list is re saved (using a Save Command Button on the UserForm)

What I am doing is reading a temporary database table and displaying it and then re-saving it to the permanent table.

List boxes themselves do not appear to be editable in Word VBA?  How else can I achieve the same thing?
0
Most of the 'mistakes" i make in spelling in Word ae just typos.

RAther than having Word show me that I made a typo, and asking me to go back and correct each one, is there any way to turn on auto-corect and have it uder-line the words it FIXED.  So that I can say, "Yep!  THats right!"  And I just carry on with my work.

Thanks!

OT
0
A client inadvertently deleted a file from his Recent files list in Word 2016. When he went to retrieve it from the Recycle Bin, the file was not there. I poked around his computer certain he'd made a mistake, but couldn't find the file.

 I ran a test on his computer, and sure enough, deleting a file from Word's Recent files list deleted the file without putting it in the Recycle Bin.

I ran the same test on my own computer with the same results. Deleting a file from Word 2016's Recent files list deletes the file without putting it in the Recycle bin.

Both computer are Windows 10 and both copies of Word are from the desktop product, not Office 365 version.

I was really surprised by this behavior, and wonder if this is the new norm.

????

Happy New Year to all!
Mark
0
When opening any Office 365 application all I see is a white screen.  Program is there as I can approximate where the X is and close the program.  Tried repairing and uninstalling and reinstalling.  No use.  
I recently upgraded from WIN7 to WIN10 and had some display issues when opening Word documents. I was able to use Office for a few weeks but had random display issues with Office files (Word, Excel, etc.)   Tried repairing and reinstalling -  
Narrowed issue down to not being able to see images in the documents.  Made a few changes in Display section in Word.  Now all I get is a white screen.  I see the menu bars at all.
0
I would like to create a local classified website for Japanese community in Dublin Ohio.
It is a small community and I would like to build with Word Press Classima or any other theme.
How much does it cost monthly or yearly approximately?
0
Is there a way to have Word, Excel show the directory at the top of the page so that I know where the document is stored on the computer using Windows 10? Thanks
0
Hi,

I am trying to repeat a value of one I enter in other 2 location (see attachment) - just enter it once and have her repeat.  How can I do this?
ValueRepeatOtherPlaceDoc.docx
0
Hi,

My boss bought a Chromebook for his son and asked me to set it up. I thought it was going to be a breeze. But..........

I created a gmail account for his son and then installed Word (he bought a license yesterday.) When Word opens, I enter MS account info. As EEs can see, it shows OneDrive is connected, but on the top right corner still shows "sign in".

Once I click on top right "sign in" and enter email, I got this "cannot add another OneDrive account"

Any ideas? thanksAnnotation-2019-12-20-184441.pngDSC_0001.JPG
0
A user is trying to replicate his company letterhead in Word. The header/stationery part is no problem. However, we'd like margins for the header to be narrower than for the body of the letter.  I tried selecting the header, changing the margin, then doing the same thing (manually) for the body of the document. Didn't take. What am I doing wrong? How do I do it right, to keep the letterhead portion in the header with one margin, and the body of the letter with a separate one? Thanks.
0
Do you have the steps in creating a Return Address Label in Word 2013?
For example, the Return address name is
John Smith
1234 Bayside drive
Jupiter, NO 44444

How would I set this up? the label code is #8167
0
Publisher cannot be verified, word 2016.   How do I remove this.
I am creating a task sequence in MDT, and when I install an office add-in, and startup Excel/Word for the first time.   I get:  Microsoft Office Customization Installer > Publisher cannot be verified.  

How can I remove this when Word/Excel starts up.  

Thanks Certificate
0
Hi Experts,

I have a list of required fields, and trying to construct a SQL statement out of it as follows.

ListOfFields.
[input#InsertRecordVisit_Date.cbFormTextField, input#InsertRecordClient_Last_Name.cbFormTextField, input#InsertRecordClient_First_Name.cbFormTextField, input#InsertRecordDate_Of_Birth.cbFormTextField, select#InsertRecordShift_From_Hour.cbFormSelect, select#InsertRecordShift_From_Minute.cbFormSelect, select#InsertRecordShift_From_AMPM.cbFormSelect, select#InsertRecordShift_To_Hour.cbFormSelect, select#InsertRecordShift_To_Minute.cbFormSelect, select#InsertRecordShift_To_AMPM.cbFormSelect, textarea#InsertRecordPurpose_Of_Visit_Goal.cbFormTextArea, input#InsertRecordTemp.cbFormTextField, input#InsertRecordPulse.cbFormTextField, input#InsertRecordRR.cbFormTextField, input#InsertRecordBP.cbFormTextField, input#InsertRecordO2_Saturation.cbFormTextField, input#InsertRecordO2_In_Use0, input#InsertRecordO2_In_Use1, input#InsertRecordRespiratory_Lung_Sounds.cbFormTextField, input#InsertRecordRespiratory_Breathing_Pattern.cbFormTextField, input#InsertRecordBipap0, input#InsertRecordBipap1, input#InsertRecordCpap0, input#InsertRecordCpap1, input#InsertRecordTrach0, input#InsertRecordTrach1, input#InsertRecordVent0, input#InsertRecordVent1, input#InsertRecordCardiovascular_Skin_Color.cbFormTextField, input#InsertRecordSkin_Temp.cbFormTextField, select#InsertRecordCardiovascular_Edema.cbFormSelect, input#InsertRecordNeuro_Alert0, 

Open in new window

0
Dear Experts:

I managed to extract 2-character acronyms (number + letter), such as 3D, 4D, 4K etc. with the following search expression (wildcards checked)

<[0-9]{1}[A-Z]{1}

The search works just fine for the above expressions.


I also would like to be able to extract these kinds of acronyms along with accompanying terms (with or without hyphen) such as ...

3D animations
4D-printing
4K applications
4K-applications

How is the above search term to be extended to accomodate my requirements.

Help is much appreciated. Thank you very much in advance.

Regards, Andreas
0

Microsoft Word

28K

Solutions

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.