>i am regularly transferring to excel from within my program, but recently i was asked to restrict the users from changing the data once it got transferred to excel.
>
>i cannot imagine how this can happen since once it gets transfrred to excel it is out of my hands.
>
>one idea which i had was to use excel viewer to transfer the data and show but i cannot figure out how to have both excel and excel viewer in the same computer and the second problem how to transfer the data so that it opens up in excel viewer.
>
>any other ideas are welcome.
Excel has the option to protect the spreadsheet. I am sure you can invoke this via Automation.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)