General information
Category:
COM/DCOM and OLE Automation
>>>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only