Thanks for the awesome code.

Everything seems to be working fine.

The excel sheet opens and requests to overwrite file when closing (amended code to SaveAs) but when i view the excel spreadsheet there is no data transfering over to it.

Unsure of the problem......Please help.