Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

SureTrack/Excel: how do I retrieve data from ST

4 replies [Last post]
James Cross
User offline. Last seen 16 years 42 weeks ago. Offline
Joined: 1 Dec 2002
Posts: 4
Groups: None
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?

Replies

Brennan Westworth
User offline. Last seen 2 years 19 weeks ago. Offline
Joined: 23 Feb 2003
Posts: 151
Groups: None
A feature in suretrak that I have found to be quite handy for extracting information is the pivot table wizard.

It is not an automated process but is quite mechanical and easy to run once you have set up the spreadsheet to process the information.

Steven Oliver
User offline. Last seen 6 years 43 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 313
Groups: None
Surely, once you have updated your SureTrak data, you must copy that to the clipboard and paste, thus renewing the clipboard data.

This is difficult to do in a macro (I did once manage to use the Softbridge scripts for this type of thing, but it was jolly hard work !)

I would suggest doing a manual copy and paste, dont let the machines do everything otherwise someday someone may write a macro to do away with the planner (or am I just being paranoid ?)
James Cross
User offline. Last seen 16 years 42 weeks ago. Offline
Joined: 1 Dec 2002
Posts: 4
Groups: None
Yes I have tried to copy and paste the data from Suretrak to Excel and that is where the problem lies - When I copy the data from Suretrak it holds it in the clipboard, and then pastes it into Excel upon request. So when I update the data in Suretrak and run the macro to update the Excel data it takes the old data from the clipboard (not the new data in Suretrak) and pastes it into Excel, which is why I need to somehow override the clipboard.
P3 Scheduler
User offline. Last seen 15 years 7 weeks ago. Offline
Joined: 16 Feb 2002
Posts: 18
Groups: GPC Malaysia
Cant you just "copy and paste" ? I remember I have done that from P3 to Excel.

However make sure that the necessary columns in SureTrak appear visible (i.e their column width > 0). Then just select all the rows for all activities and copy. Then immediate switch to Excel and paste.

Best regards,
CS Ong