Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Question about Hard Return Removal
use VBA's Replace$ function ... NewString$ = Replace$(DataInStr$,vbCrLf," ") NewString$ will contain DataInStr with all the CrLF pairs replaced with a single space. David- Iray
- Post #4
- Forum: Visual Basic (Classic)
-
Use of Progressbar
When you are in a loop and need to update the GUI, you need to periodcally yield control via the DoEvents call. Just be sure to make your sub or function handle the potential of re-enterancy. For example, you push a button on the form to start this process. Inside the button you disable it...- Iray
- Post #2
- Forum: Visual Basic (Classic)
-
Class - Initialize & Terminate
I've noticed when placing code in the initialize and terminate events, these should be used for creating and/or destroying objects, setting default values. A seperate sub or function should be used to complete initialization of objects. If not, you run the risk of an automation time out. Just...- Iray
- Post #6
- Forum: Visual Basic (Classic)
