Hey all, wondering if you can help with a small problem I am having. I am copying some data from a FoxPro table into an excel sheet. I have a macro in PERSONAL.XLS that will conditionally format the rows based on a specific value in one of the columns. It works fine if I select macros and run it manually. What I want to do is have the macro run automatically when the user opens the excel sheet. I tried putting the code in the Auto_Open() procedure of the sheet in question, the problem is when I copy the data from FoxPro to the Excel sheet, it overwrites the entire file and the macro is lost. Is there a way to automatically run the macro in PERSONAL when Excel opens? Tried Auto_Open() in PERSONAL but this does not work.....I think I read somewhere that it's because it is a hidden file. Or does anyone know how to simply append to the Excel doc from FoxPro instead of overwriting it....that would actually be better.
Cheers,
Noogles