Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel - External data web query

Status
Not open for further replies.

crystalreps

Programmer
Apr 13, 2003
7
0
0
GB
I was looking for some help with importing external data on Excel 2002. I am importing data from a 3rd party website with fields that change regularly. I need to know which fields have changed, so I can see them at a glance. I can find no funcionality in Excel to do this. The only thing I have tried so far is to have two workbooks open, one importing every minute and one every 5 minutes and comparing the two. However there appears to be some fault with this as although it picks up the changes it doesn't reset them after the 5 minute workbook updates.

Anyone got a simpler solution please?

Many Thanks

GK
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top