>>>>We are getting the OLE error code .... Out of present range only on Windows 7 machine.
>>>>I am running xp with no problem. users with Windows 7 getting that error while populating excel.
>>>>
>>>>I am just not sure what the different between xp and windows 7 to cause such an error.
>>>>or maybe it is just coincidence and the problem is not related.
>>>>
>>>>any suggestion???
>>>
>>>What is the code where you get this error?
>>
>>it is on a user machine i don't know exactly where. but the program doing 1000s of this statement (just an example)
>>XLSheet.cells(row_num, col_num).VALUE = data1
>
>Is this something that happens every time they try to write to excel? If so, I'd look at where the Excel file is - Security in Win7 makes places like the Program Files folder tree readonly unless you specifically allow access.

thanks guys, I am not sure what was the problem but I added new changes and everything is working fine now.