Hope we can help.
How are you adding the pushpins now? You will need to filter by date. What would be nice is if VB6 you show the available dates in the excell file so you can choose which date to export to excel.
You used your code to export one date range. Now you need to save the map.
http://msdn.microsoft.com/library/de...ZOMMSaveAs.asp
Now you need to open a new map.
http://msdn.microsoft.com/library/de...pplication.asp