I don’t know if VBA has specific hooks for Notepad, but Notepad docs are just plain text, which is fairly easy to retrieve in VBA. Microsoft has a page on using <a href=”http://msdn.microsoft.com/en-us/library/czxefwt8(VS.85).aspx”>FileSystemObject to open text files</a> that contains instructions and sample code that will probably set you on your path. HTH.
Same as Yuval I don’t know if Notepad exports an object model. May be you can find it in the references of your VB environment, together with ADO and the like.
But if you know the name of the file being edited then you can use the VB “sendkeys” command to make Notepad select all the text and copy it in the clipboard, for example.
To do sendkeys you typically need to know the text in the window’s bar, for example “thefile.txt – Notepad” (open a fil ein Notepad and take note of the content in the title bar).
Notice that the keys you send to the program are language-dependent. For example to select the complete content in an English Windows the command is control-a and in Spanish it’s control-e.
Also note that there could be more than one window with the same title.
Moreover, remember thet VB has a control, a rich text editor, with more or less the same functionality as Notemap, and depending on your app you might host the text edition instead of spawning a Notepad. It it opens bacause the user double-clicks a spacial file type then associate that file type so it will open your app.