Re: Ex****t to spreadsheet error, help please

That is where I would check also.

I know it is not impossible that directory names have an underscore as
part of the name, but it seems a bit unusual.
Also there is usually a colon just to the right of the drive letter.

Perhaps  "C\datastream\ex****t_data\Property" & "_" & UsrName & ".xls"

should be  "C:\datastream\ex****t data\Property " &  UsrName & ".xls"

The first thing I would do is check the colon
after that check about spaces instead of underscores.

Ron