>>>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.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________