Never mind. Turns out the InStr code will find the HTML snippet. You just have to be careful to limit the code being searched to something in HTML that will not be split across lines in the field being searched or InStr may not find it since it also evaluates Newline characters. Here is some...
Is there a way to search an Access (2010) rich text memo Form field with VBA code to find if the HTML tag for the red color, or any other color for that matter, is being applied somewhere in that rich text memo Form field and if it is not, then perform some VBA code? I want to use that code in...
PROBLEM SOLVED! - The issue actually has to do with having the preview pane on in Windows File Explorer. The preview pane creates a Winword process in Windows Task Manager (uses up about 50 MB of available memory) that persists without showing Windows as open on your taskbar as long as you have...
combo,
Although the app shows by putting your code just before the Quit and after the Doc close (and using a Msgbox right after setting to visible to pause the processing), the Word application didn't show anything but a non-Doc word screen with no questions being asked. Continuing by clicking...
When you use VBA "Set ... New" to create an instance of the Word or Excel Application (not sure about Powerpoint or others) you create an instance of both of those where the New keyword actually seems to place either a "Document1" or "Book1" hidden reference (number can change, incremented by...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.