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 FileSystemObject to open text files that contains instructions and sample code that will probably set you on your path. HTH.
Hi Morfs,
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.
—
Juan Lanus
Discuss This Question: 3  Replies
I would like to import whole data from "wordpad" files to excel.
I can able to open my file in wordpad but unable to copy & paste in the required excel sheet.
Please help me.
I don't know if VB can easily link to various Windows APIs as easily as C# can. If it can, there are APIs to get handles for any open windows. Once handles are known, it's possible to send any keys to the windows. So copy/paste would be possible.