I do similar little programs to help some of my co-workers. What I do is
write a small program that will go and get an Excel file (list) and import it
into the HelperProgram, which then manipulates it however the user wants, and
saves it out to wherever they want by whatever filename (with datecode) they
want. Next time it can be simply run again with a new list, or can be
automated to run against a "list of lists".

Vaya con Dios,
Chuck, CABGx3



"Kevin" wrote:

Hi, this is actually a question from a friend that I couldn't answer. She
works at a school with a proprietary program that does attendance. Several
times each day she exports a list to excel, but needs most of the columns
deleted and one added. I made her a macro to do this and it works fine. The
problem is, after the initial run, the workbook containing the macro is
minimized and she then exports another list, but the macro won't run again
unless she reopens the workbook containing the macro. She also said there is
no personal.xls listing when looking under macros. I'm thinking this may be
the problem. Is there a way we can call up the macro from the other workbook
in a convenient way? The other program opens a new instance of excel each
time you export a list, also...hope I explained correctly. Thanks for any
help, -Kevin