Extracted a few hundred quotes from several books.  Many are Theoretical Definitions.  

Need to review them to try to extract some ideas of my own.

Best way for me is to scan through them, adding comments and highlighting key phrases and definitions.

Sample file attached.

Easiest application for me to achieve the editing portion of this work is Word.

Allows me a RANGE of definable styles, and sidebar comments.

Only problem is pagination.  Each extraction of text is just a few sentences, at best a paragraph long.  I’ve re-sized the pages to make them notecard-like.  

Trouble is, there’s no way to get them to paginate like a deck of cards.  What I mean is, frozen in one spot, with the succeeding pages and preceding pages just fulling the same area on the screen.

I’ve tried several work arounds - got some good ideas here: https://www.experts-exchange.com/questions/29158467/Word-2016-Reading-View-Workaround-to-Enable-Editing.html

Even trying ALL of these, eventually, the pages start getting out of phase, and you have page breaks in the middle of the screen.

One WAS close!  Print Preview Edit mode: it does the pagination perfectly, single stable window.  But, you can’t…add comments nor style.  Both of which are crucial as I, hopefully! :D, discover some new ideas within these existing ones.

So, here was my thinking - is there any way to write a Macro that will take either existing Page Down / Page Up keys and program them to always render the next …

I often copy a web page to the clipboard, then paste it into ms word for further processing.
One particular website often contains many empty text boxes as seen here ee-ms-word-text-box-deletion.docx.

MS Word treats the boxes as Fields, so I wrote the following code to delete these boxes.

Sub DeleteFields()
    ' REPLACES ALL TEXTBOXES WITH VALUE
    Dim rng As Range, sText As String

    For Each rng In ActiveDocument.StoryRanges
        With rng.Fields
            While .Count > 0
                .Item(1).Select
                
                ' sText = .text  ' tried a few variations like .code.text etc but could not find the magic properties to use.
                
                .Item(1).Delete
                
                ' Selection.TypeText sText
            Wend
        End With
    Next
End Sub

Select all Open in new window

I would like to modify the code so that it deletes the empty text boxes and replaces  them with the inner text.





i use the following code that deletes all of these delete

I have the following code in VBA to return information from an Access Table.

Private Function DBQuery_GetItemSequenceNumber(Optional strParameter As String, Optional strFilter As String) As Long
Dim cQuery As New ADODB.Command
Dim pParam As ADODB.Parameter
Dim rResultG As ADODB.Recordset
    
    With cQuery
        .ActiveConnection = cn
        .CommandType = adCmdStoredProc
        .CommandText = "qItemsMatch"
        
        If strParameter <> "" And strFilter <> "" Then
            If Mid(strFilter, Len(strFilter)) = vbLf Then strFilter = Left$(strFilter, Len(strFilter) - 1)
            If Mid(strFilter, Len(strFilter)) = vbCr Then strFilter = Left$(strFilter, Len(strFilter) - 1)
            strFilter = Trim$(strFilter)
            strFilter = Left$(strFilter, 70)
            Set pParam = .CreateParameter("ParaDetail", adChar, adParamInput, Len(strFilter), strFilter)
            .Parameters.Append pParam
        End If

    End With
    
    Set rResultG = cQuery.Execute
    
    If Not rResultG.EOF Then
        DBQuery_GetItemSequenceNumber = CLng(rResultG("Sequence"))
    End If
        
    Set cQuery = Nothing
    
End Function

Select all Open in new window

If I run the query manually, then it works. However, when I pass the content via VBA, there are not results returned. I guess I am passing something the wrong way in the code but can anyone tell me what it should be, please?

Many thanks.

Hello,
I have a word document where I want to insert a picture using merge field.
The image is coming fine, however I want to control the properties of image, height & width.

The image is being put in word using a software, from web forms.
Can someone tell me how to set properties of image?

Regards,
A

I'm trying to copy text to the clipboard from the command line. If I try something simple like:

ECHO test | CLIP

it works fine and puts the word test in the clipboard. My problem is that I have a special character (specifically an ampersand) in the text I want to copy and it makes the clip utility choke:

ECHO http://wwwapps.ups.com/WebTracking/track?track=yes&trackNums=1ZV300F20358346597 | CLIP

If I try the same text without the ampersand, it works fine so I know it's the ampersand that is causing the problem.

I tried using quotation marks like this:

ECHO "http://wwwapps.ups.com/WebTracking/track?track=yes&trackNums=1ZV300F20358346597" | CLIP

That gets rid of the error but the quotation marks get copied to the clipboard, too.

Any ideas?

Thanks in advance.

Aren't out of the box Styles in Word (2016) like

Heading 1
Heading 2
Heading 3

auto-updating in terms of font size?  They show themselves to be "Based on Normal"  But, I updated the Normal text size to 18.  Then, started using Heading 1 - it was just 16.  And, Heading 2 just 13.

I even went further and selected both of these with a check box "Auto Updating".

How can I get my Headings 1 ~ x default styles to update themselves in terms of Font Size in Word?

Thanks!

OT

We are having a strange issue when we try to add a network printer to a Windows 10 1903 machine. We are adding a shared printer from a 2008 R2 print server, it does not seem to matter what print driver is on the share. When we double click on it it does add it since you can print from Word and Notepad, but it does not show up in "Devices and Printers" or "Printers & Scanners"

We noticed this on our customized image, so we tried hand loading a 1903 machine without any other software and still the same issue. We also hand loaded a 1709 desktop and on there, everything worked as is should. It seems the problem is only occurring on 1903

Has anyone else ran into this?

Thanks,

Hi, I have just noticed that when I try to make Firefox smaller by clicking on the center (square) type icon on the upper right, it just kind of re positions the full screen but does not make it smaller.  I tried it on Chrome and it worked just fine as well as Excel and Word.  I want to have an excel document take up the left half of the screen while I look stuff up in Firefox on the right side of the screen.  I've never run into this before and would appreciate your help.
Thanks

I am trying to search a document for numbers that could be anything from 1 (or 1.) to 999.999.999.999.999. Is there any way that I can do this, say using wildcards, without needing to use several passes?

Thank you.

Making Collapsible Regions in Word Mac 2019

I can not find how to do this simple task. So many other versions of Word...

I need to configure regions and give titles.

Thanks

Does anyone know if the Azure Information Protection labels work on the MAC OSX version of Word, Excel and Outlook?  We have Microsoft Business 365 and I'm trying to see if our mac users can utilize the security encryption features.

Hello,

I am copying over pages of OneNote (version 2016) to Word 2010 to prepare an extended document.  I have noticed that when copying over, the indents/bullets are off (not all the times, but most).  Can an expert help on how to properly copying OneNote pages to a word document as precise as possible preserving the OneNote bullets and indents locations.

Good day,
We have a VM host that runs two server machines.  The first is the DC/FS and it works great.  The second machine is a terminal server.  It constantly is freezing on the users and it is getting frustrating.  Here is some info:

Host machine is running Server 2016 Standard.  Its specs are:

HPE Proliant DL380 G9
Xeon E5-2620 v3
32GB RAM
RAID 10 for the virtual disks

Server is stable, no issues.

The host machine allocates a large portion of RAM to the DC and the TS.  The DC currently has 8GB and 8 virtual processors.  The TS has 10GB RAM, and also 8 virtual processors.  Originally I had the TS with less RAM and processors, but in trying to fix the freezing issue, I increased the resources.  I plan on bringing them back down.

The TS has only 3 users signing in.  They use the same domain account to log in to the server.  The TS is configured to allow the same user to log in multiple times.  It is light usage.  The TS exists to run only one program.  While using that program, the users may open Word or Adobe, but not much of anything else.  About 4 or 5 times a day, the server just stops responding to that user.  The other users logged in do not experience the same.  It will just spin and spin.  The remote connection never breaks.  Frustrated, they just click the x on the top blue ribbon, and re-log back in.  Then its totally normal until it freezes again.  

During the freeze, the internet is working normally, the others users aren't affected.  A VPN …