<div>
If my module already has Declare statements at the top, am I correct that I have to add everything above the &quot;Function ClipBoard_SetData(MyString<wbr /> As String)&quot; line to the previous Declare Statements?<br />
<br />
I suppose it would easier and clearer to just create a new module?<br />
<br />

</div>


If my module already has Declare statements at the top, am I correct that I have to add everything above the "Function ClipBoard_SetData(MyString As String)" line to the previous Declare Statements?

I suppose it would easier and clearer to just create a new module?



<div>
Yes, easier to create a new module.
</div>


<div>
<div class="content wysiwyg-content">
I need VBA code to put into Outlook that will be called and will count the number of emails in the particular Exchange folder that is open and put the count in string format onto the windows clipboard. &nbsp;The calling program (which has no VBA access) will read the text string from the clipboard and continue in a loop. &nbsp;<br />
The VBA function or sub routine is run by my program by simulating Alt-F8 in Outlook and &quot;typing in&quot; the name of the function or subroutine. &nbsp;<br />
I grabbed and tweaked code but it doesn't work. &nbsp;I have very little knowledge of VBA or VB.<br />

</div>
</div>


I need VBA code to put into Outlook that will be called and will count the number of emails in the particular Exchange folder that is open and put the count in string format onto the windows clipboard.  The calling program (which has no VBA access) will read the text string from the clipboard and continue in a loop.  
The VBA function or sub routine is run by my program by simulating Alt-F8 in Outlook and "typing in" the name of the function or subroutine.  
I grabbed and tweaked code but it doesn't work.  I have very little knowledge of VBA or VB.


Count emails in an open folder

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taker, journal, and web browser.