The reasons i am not using SSIS is that i could not find a way to auto fit the columns (one of the requirements).

Still the same error i am afraid.

The folder was created fine and the service account user was down as the owner.

The original folder that i was using had full control...

No dice.

I have the service account set as the domain user with limited rights. I then set up a job that calls the procedure in question and set the...

Hi again.

I didnt manage to get a response from anyone at simple talk. I have narrowed the problem down to security rights.

The account that we use as...

I will do that. Thanks again.

Thanks again guys. I have already found an article pointing to the user rights. I have added the SQL service user into the security group for that server...

Thanks for the reply.

I have changed the path from 'C:\severname\test\ExcelExport.xls' to '\\Servername\Test\ExcelExport.xls' and still the same issue. I can access that from both the server and the local machine....

Your Dead on the money there. Thats what i am working on now. Will post in a bit with how its done.