Other programs running macro

General questions about using TextPad

Moderators: AmigoJack, bbadmin, helios, MudGuard

Post Reply
chrbjo
Posts: 1
Joined: Wed Sep 10, 2003 1:19 pm

Other programs running macro

Post by chrbjo »

Hi,

I just started using textpad and I am wondering if it is possible to have an external application running a macro created in texpad? If possible please give a hint where I can read more about this.

Thanks
User avatar
Bob Hansen
Posts: 1516
Joined: Sun Mar 02, 2003 8:15 pm
Location: Salem, NH
Contact:

Post by Bob Hansen »

I use Macro Scheduler to integrate TextPad and TextPad macros into other processes.

Summary: Data in Q&A databases are updated with data from QuickBooks.

Summary of Steps:
1. I use Macro Scheduler to perform all these steps, scheduled off hours, no intervention needed:
2. Start Access which opens and exports a text file of data where Access is linked to Quickbooks.
3. TextPad is then opened up and loads the exported Access file.
4. A TextPad macro is called to parse and format the data from Access into a format to be imported by Q&A. The TextPad macro does the parsing and reformatting and saves the file under another name.
5. The MS macro then closes TextPad,
6. Q&A is opened which imports the file saved by TextPad, then Q&A closes.
7. Macro Scheduler macro is done.

========================
More info about Macro Scheduler is available at:
http://www.mjtnet.com/index.htm?ref=rmh ... rg_2644641

This integrates TextPad macros, but does not use them externally alone.
I don't think that you can create a macro in TextPad and use the macro by itself in another application however. Like making and Search and Replace macro and using it in Notepad vs. TextPad? Don't know how that could be done.

Hope this helps...................good luck,
Bob
Post Reply