One approach would be to use automation:

http://support.microsoft.com/support...aqVBOffice.asp
Frequently Asked Questions about Microsoft Office Automation Using Visual
Basic


http://support.microsoft.com/support...fdevinapps.asp
Programming Office from Within Office


http://support.microsoft.com/?id=167223
Microsoft Office 97 Automation Help File Available on MSL

--
Regards,
Tom Ogilvy




"QuietMan" wrote:

Creating a print control file and printing reports from excel, power point
acrobat
was wondering if there was a way to priting the non excel reports using vba
written in excel
--
Helping Is always a good thing