there is an excel file with VBA macros that is accessing data from the server, Now it works on some workstations and generating the following error on certain PC

 "error 1004

error converting data type varchar to datetime"

I checked the date formats and everything is ok

anyone with an idea