Using Textpad from Excel

colandy · Post by **colandy** » Thu Sep 24, 2009 9:05 pm

Hi all,

I need to open a textpad document from within Excel and send commands to textpad from excel once open. Basically I have a txt document and I need to runa textpad macro then close textpad, all from within Excel.

I was trying to use shell to open Textpad and the document in question, which is fine and then the SendKeys command from Excel to run the Macro via shortcut keys using Sendkeys and then close textpad again usinf sendkeys, all from excel.

I am experiencing issue using the Sendkeys as Textpad appears to ignore most keys and I certainly can't close the app.

Anyone have any suggestions or an alternate method ?

Thanks in advance

Bob Hansen · Post by **Bob Hansen** » Fri Sep 25, 2009 12:14 am

I use Macro Scheduler for tasks like that. The macros in Macro Scheduler can call a TextPad macro or perform the TextPad keystrokes itself. And the macros can be edited.

Info available here: http://www.mjtnet.com/macro_scheduler_pro.htm

TextPad and Macro Scheduler are my two "cannot live without" tools.