FlyerTalk Forums - View Single Post - Moving "View My Miles" to Excel worksheet
Old Jun 13, 2002 | 10:33 am
  #1  
Brandy
 
Join Date: May 2000
Location: Dallas, Texas, USA
Programs: AA EXP, 3.1 Million AA Miles, Hilton Diamond, *wood Gold
Posts: 245
Moving "View My Miles" to Excel worksheet

For the last 18 months, I have been doing "Cut and Paste" from aa.com to an Excel worksheet. Takes about 20 minutes each month to do the cleanup and restructure needed to work in a rolling summary sheet and into a month only sheet. Has worked well, until now.

With the advent of the NEW (???) and IMPROVED (???) aa.com, the work load has gone up. Sometimes the numbers do not have a working value. I have tried reformating the data, but the worksheet for some reason does nor recognize any values. I have to go in and manually rekey the data in each cell for the worksheet to "see" the values.

Have talked with other Excel experts and they are stumped. Something has changed and none of us can figure it out.

Anyone else encountered this?

Thanks!

Also has aa.com fixed the 50 line limitation in the e-summaries? Previously, we had to do multiple file "cut-n-pastes" DURING a busy month to avoid loosing online AA FF data. Anyone know for sure if this BUG (AA Feature !!) has been fixed?

Thanks again.

[This message has been edited by Brandy (edited 06-13-2002).]
Brandy is offline