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



      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...





















      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!!!