Solved

Extracting all Msgbox lines from the project/projectgroup

Posted on 2003-11-28
3
243 Views
Last Modified: 2012-05-04
Hello,

I have a sizable project/project group (with many forms,modules,usercontrols)....What I need to do is extract all the Msgbox statements from all the source componenets of this project/projectgroup and write to a notepad file.

How can I do this?

Thanks
Kamur
0
Comment
Question by:kamur
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 9

Accepted Solution

by:
dancebert earned 100 total points
ID: 9838909
Copy all the source code files into a single directory

Use the FileSystemObject to open a file called Results.txt

For each file in the directory:
    Use the FileSystemObject to open the file
    For each line in the file:
        If InStr("Msgbox") then
            Output this line to Results.txt, followed by a vbCrLf
        End if
    Next
Next
0
 
LVL 48

Expert Comment

by:AlexFM
ID: 9839205
Use "Find in files" functions available in VC++.
0
 

Author Comment

by:kamur
ID: 9840605
thanks dancebert. that was easy, i was thinking i would have to search in binary files also. regards.
0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
JSON Response and request in VB6 application 11 1,063
VB 6 error 5 in windows 10 but not in XP 7 72
IF ELSE Statement in Excel Macro VBA 16 103
RUNRMTCMD from AS/400 13 130
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question