Can anyone fix a small, irritating bug in my procedure?

[highlystrung]

Hi, I've created a series of sub-procedures to import data from an EXCEL file, re-structure the file and then create a pivot table. If I try and run the whole lot in one go (macro "MasterProcedure2"), it trips out in the pivot table procedure where it is trying to format the date row field (Please see below). If I run it in 2 stages ("MasterProcedure" followed by "CreatePivotResults") it works fine - sometimes I have to do it twice to get it past that bit of code. My best guess is that it's to do with the object variables I set in a prior procedure ("ImportData") but I can't figure out exactly what!

Trips out here:

Please Login or Register  to view this content.

2 files attached, "expenses" and "GetDataFromExcelFile_28th Nov 2012"

Many thanks for any help,

Neil

[highlystrung]

No takers?