I have used external data queries in Excel with much success. When I have need to schedule this or trigger it automatically, I have used an ActiveX task, or...