Running Textpad from Excel

[colandy]

Hi all,

I have been trawling the net in an attempt to find an anwser to the following with no luck, any help would be appreciated:

I have a textpad macro that I need to run, within textpad on a file. Howvere, I need to do this via Excel 2003 VBA. I am able to open textpad from within excel using shell but am unable to use the SendKeys command to send textpad the cammand to run the Macro and then close.

Basically the Macro strips all spaces from the file, text from all lines, adds a line to the top and saves the file to a specific location.

The reason I need to automate this is that the resulting file is saved as a csv, I then run a sql query and import the result to excel.

The only problem I have as stated is getting textpad to accept the Sendkeys from Excel vba.

Many thanks in advance.........

[Leith Ross]

Hello colandy,

Welcome to the Forum!

I am not familiar with TextPad other than it is a third party text editor for plain text. SendKeys is not a reliable method of communication between programs. You may be able to use the Windows API instead. However, if TextPad isn't designed for COM (Component Object Module) compliance then it doesn't matter. A program must be COM compliant to respond to either method.