Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 06-12-2009, 08:07 AM
Eduardo Eduardo is offline Macro or Function to know wether a string is included in a text Windows XP Macro or Function to know wether a string is included in a text Office XP
Novice
Macro or Function to know wether a string is included in a text
 
Join Date: Jun 2009
Posts: 3
Eduardo is on a distinguished road
Default

Quote:
Originally Posted by Eduardo View Post
Hello!!

I need to gather information from standard commercial reports, which include standard information, like "number of employees", or "issued capital".

Not all the information is available in every commercial report, so I need a macro / function to search wether "number of employees" (for instance) is a string included in the current commercial report.

Depending of the result I would run other instructions.

Thanks in advance
Thanks Bird!!

Currently, my macro searchs the string and, if the string is found, execute the following instructions.

The problem appears in case the string is not found, because the macro ALSO EXECUTE THE FOLLOWING INSTRUCTIONS.

That`s because I need a way to make a difference between both cases (when the search is successfull and when it is not).

I though about preparing a function or a variable to store the value TRUE / FALSE, depending on the result of the search (successfull or not successfull). My idea is to use such variable / function within an IF instruction, executing a different group of instructions depending on the success of the search.

I don't know how to build such variable / function. That's my problem.

Thanks any way
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro or Function to know wether a string is included in a text Help! for using an appropriate function/Macro in Excel pawan2paw Excel 1 06-04-2009 12:28 PM
Extract from String using Wildcard whousedmy Word 0 05-21-2009 01:35 AM
Templates: automatic text generation from Rich Text content control Chickenmunga Word 0 10-01-2008 11:16 AM
Macro or Function to know wether a string is included in a text Need help on what function to use??? Primeraman Excel 1 06-13-2006 10:16 AM
Help with Combination function sanasath Excel 0 12-13-2005 07:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:54 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft