Previous | Next | Sheffield
Topic: Running Microsoft excel macro within a MMax progrm
Conf: Sheffield, Msg: 4986
From: Tim Attig (tattig@rocketmail.com)
Date: 9/4/2003 03:09 PM

I have created a macro in Excel that when a certain spreadsheet is opened, the macro creates a new copy of the existing spreadsheet, opens the needed csv files, copy's them and pastes them into the created excel spread sheet, then closes the csv files, saves the spreadsheet, prints it, then closes the spread sheet.

My question is: Can this macro or spreadsheet containing a macro be linked to the end of a Measure Max program? This way the operator only has to run the mmax program and when it's done, the excel macro takes over the job of copying and pasting the csv file into a spreadsheet. Any feedback would be greatly appreciated.

Tim