SureTrack/Excel: how do I retrieve data from ST
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
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.
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 ?)
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.
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