Bulk Download All Your Activities from TrimbleOutdoors

What you need:

1. TrimbleOutdoors My Trips page(s)


2. Google Chrome Browser


3. "Grab y'all links" Google Chrome Browser Extension - https://chrome.google.com/webstore/detail/ajjloplcjllkammemhenacfjcccockde


4. Text Editor - I like Notepad ++ - http://notepad-plus-plus.org/


5. Microsoft Word - I use Word 2010


6. Microsoft Excel - I use Excel 2010


7. User defined function in Excel to get hyperlink URLs - From http://www.contextures.com/excelhyperlinkfunction.html 

There's no built in function to extract the URL or email address from a hyperlink. You can create your own Excel function -- a User Defined Function (UDF) -- to extract the address.

Copy this code into a regular module in your workbook, then use the HLink function in that workbook, just like any other function. 

Function HLink(rng As Range) As String

'extract URL from hyperlink - posted by Rick Rothstein

 If rng(1).Hyperlinks.Count Then

     HLink = rng.Hyperlinks(1).Address

 End If

End Function

Watch the video for the steps:

[youtube http://www.youtube.com/watch?v=WKuqsKPYLdk?wmode=transparent]