I am trying to create a macro that copies data from a Suretrak file and pastes it into an Excel spreadsheet - the aim being that everytime the Suretrack file is updated I can run the macro from Excel to automatically copy and paste the new data from Suretrack into Excel (thus updating the Excel data)
However the macro is taking the data from the clipboard - and so when Suretrak data is updated it still copies and pastes the old data in clipboard. How do I get around this - Ive gotten as far as looking into Microsoft Query and ODBC drivers - am I on the right track?
However the macro is taking the data from the clipboard - and so when Suretrak data is updated it still copies and pastes the old data in clipboard. How do I get around this - Ive gotten as far as looking into Microsoft Query and ODBC drivers - am I on the right track?