Issue raised here…

http://www.openntf.org/projects/pmt.nsf/0/E5FDF681AE197EBF862576C7001330FF



BTW, some of your code properly determines the drive location of the Windows TEMP directory, which is goodness. But other parts (such as Sub SaveToFile where it attempts to write out the Excel worksheet) defaults to the C: drive, which – at least on my Windows 7 machine – cannot be written to, and it should always write to my TEMP folder on the other drive. So you'll need to check a few more places in your code to ensure that the C: (system) drive isn't defaulted to for output. … Cheers, Tony.