Thanks for that. I know about the second answer you gave but I am trying to avoid excel opening because this is all happening in the background so we can email the sheets to clients. I need to setup the stypes/coulours/fonts etc as well so i have found a way to write my data to the xml within the excel sheet and then zip it back up to become an xlsx file. Works like a charm.
