Wednesday 20 November 2013

IIS Error- Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)).


For this fallow the fallowing steps-

 Enable the ASP.NET authentication for default website (in IIS) then create Desktop folder at C:\Windows\System32\config\systemprofile\Desktop.

step1 :  Go to run type dcomcnfg 
Step2:   Click >Component services >Computes >My Computer>Dcom config> and select microsoft Excel Application> 
Step3:   Right Click on Microsoft Excel Application>Properties>Security Tab
Step4-Under-Launch and activation permission->Customise->Edit->Add--type-(IIS_IUSRS) 
-> ok -> Allow Permission-Local Lounch and Local Activation
Step5- Repeate Step4 for Under Access Permission

Reference--http://www.youtube.com/watch?v=ijfb3E_7t3o

IIS-Error Resolve--Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space. • To make more memory available, close workbooks or programs you no longer need. • To free disk space, delete files you no longer need from the disk you are saving to.


For this fallow the fallowing steps-
step1 :  Go to run type dcomcnfg 
Step2:   Click >Component services >Computes >My Computer>Dcom config> and select micro soft Excel Application> 
Step3:   Right Click on Microsoft Excel Application>Properties>Give Asp.net Permissions 
Step 4: Select Identity table >Select interactive user >select ok

Friday 15 November 2013

Restrict Ajax Calender future and past date using javascript

<script type="text/ecmascript">

    function checkDates(sender, args) {
       // alert(sender._selectedDate + "    enter    " + new Date());
        if (sender._selectedDate > new Date()) {
            alert('Date must be less than Today');
            sender._selectedDate = new Date();
            // set the date back to the current date
            sender._textbox.set_Value(sender._selectedDate.format(sender._format))
        }
    }
</script >

//HTML
 <asp:TextBox runat="server"  ID="dtForm"  Enabled="False" ></asp:TextBox>

<asp:CalendarExtender ID="CalendarExtender1" runat="server" PopupButtonID="cal_Surveyor"
TargetControlID="dtForm" OnClientDateSelectionChanged="checkDates"  Enabled="True" Format="dd/MM/yyyy"></asp:CalendarExtender>

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...