View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
achidsey achidsey is offline
external usenet poster
 
Posts: 100
Default CreateObject("Notepad") ?


As part of my code, I want to change the encoding of some .txt files from
Unicode to ANSI. Is there a direct way to do this in VBA.

If not, I want add code to create a Notepad session and then use the
SendKeys method to do this. How do I create a Notepad session in VBA.

I know I can start a program called Monarch through VBA using:

Set MonObj = CreateObject("Monarch32")

What's the equivalent for Notepad?

Thanks in advance,

Alan

--
achidsey