Hi, I use the very simple way: the last line in the first macro simply
starts the second macro, by the line:

Application.Run "'ATCE020_ny.xls'!usafil"

ATCE020_ny.xls is the file where the second macro usafil is stored.

It works fine for me!


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements