9 Replies Latest reply: Sep 8, 2009 1:09 AM by stwxy75 RSS

    REload when the QV File opens, Export to Excel and close again

      Hi

       

      I have Microsoft scheduler happily opening my Qv document every 15 minutes

      All I want now is a macro to to reload the data, export a table from one of the sheets into excel , and then close down the file

      I am using QV9, and I guess I create the macro in "Tools > Edit Module"

      Something like...

       

       

       

       

       

       

       

       

       

       

       

       



       

       

      sub

       

       

      msgbox

       

       

      End sub

      "pause" CopySendToExcel

       

       





      But I cannot seem to link this to the document properties event trigger "on open"

      This of course is only a portion of the problem as I still want to reload when I open the data before I export to excel!

       

       

      Help please!!!