I have a user who when he runs a report that exports to excel it does populate the excel sheet but does not enter any values. If I or anyone else runs this report it produces values. Even if I run it as his id it works but as soon as we run it on his computer it doesn’t work. He uses excel 2000 but everything else looks correct. I have tried replacing and re-installing his lotus environment but nothing helps. Has anyone seen this happen before
Thanks in advance for any assistance
Subject: Problem with Export to Excel - Nil Values
What happens when you turn on the debugger at his workstation and run the code?
Subject: RE: Problem with Export to Excel - Nil Values
i have taken over there pc but all looks ok. So strange because I can install their environment and their id on my pc or any other and it works but if they run it on their pc it just produces a blank spreadsheet short of the titles. I have replaced the spreadsheet, the lotus environment and re-installed lotus but still the same result. I belive it is either Excel version or security of excel version.,
Subject: Problem with Export to Excel - Nil Values
Hi,it must be the version problem. i run on the same problem.
after creating the excel object, just give excelobject.visible=true
and run the agent automatically excel sheet open and data will added to excel sheet.
ok, thanks
Subject: RE: Problem with Export to Excel - Nil Values
the excel sheet does open it just has nil values in any of the rows I am calling on dynamically. If I am just adding the date to the date cell its fine - its when I start adding rows and populating them that it just acts like there are no rows to add. Running it anywhere else - even with his id works fine