Search string for specific word

L

Lasse

Hi

Is there a VBA command to search a string for a specifik word?

I create a string with the printername and I need different things to happen
according to which default printer the user have selected.

/Lasse
 
M

macropod

Hi Lasse,

You could use the Instr function. For example, the following code tests returns 'True' if the active printer is the Adobe Acrobat
distiller:
Sub TestPrinter()
MsgBox InStr(Application.ActivePrinter, "Adobe") > 0
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
VBA Export to PDF 0
Descenders clipped 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
How to modify and updte specific styles for specific paragraphs across the document 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
VBA - exporting serial letters to single documents 0
MS ACCESS: SEARCH in a split form 0

Top