Lowell (8/25/2014)
correct me if i'm wrong, but I thought noone can write to a file on the root of the C drive unless they are running elevated, admin priviledges:so C:\CambridgePubs.xlsx would fail, but
C:\Data\CambridgePubs.xlsx would probably be ok, assuming path/file exists and all that stuff.
True. But it doesn't work even if I change the path to D drive.
Sorry for the late reply, was on a work trip and didnt get time for this.
Any other ideas guys?