I've created a routine that drags live sales order info from our as400 server into an Excel spreadsheet.
I then have to select the Data > Export to Mappoint option when Excel loads.
I'd like to write a macro to automatically 'Export to Mappoint' when i open the spreadsheet.
Can anybody help? I'm more than happy to do the programming myself as i have a slight knowledge of VB but i just cant find enough references to get me going.