You have a macro called FleetMatics stored somewhere. Call it with a command line similar to that in my previous message (which assumed it was in the global personal workbook). You can record a macro running the macro to get the part of the command line in quotes.
You cannot simply insert Excel code into the Outlook macro. It is not compatible. You should however be able to run it from Excel using the command line above.
Without access to the Master workbook it is all a bit vague, but looking at it, I would have thought that you should add the command line either immediately after the line
Code:
Set xlSheet = xlWb.sheets(1)
if you want it to prepare the sheet to take the CSV data, or immediately before the line :
Code:
xlWb.Close SaveChanges:=True
to process the sheet after the data is added.
Just make sure yolu have a backup copy of your Master workbook.