I use the 'Export CSV' feature on the Activities Page to download my Bike Rides. I upload this CSV into my Excel Tracker automatically.
The automatic VBA routine picks out the fields I need from the CSV file. e.g. Date, Ride Distance, Aver Speed, etc.etc.
Has worked fine for years. However from time to time the data field position format changes form time to time. i.e. Reverting from one format to the original and the reverting back after another few months.
I now have two routines handling both formats but I only find out it has changed when my upload goes wrong. Am I doing something wrong? How can I avoid this?
