can you try putting below statement after creation of excel object MsXl.DisplayAlerts = False
Please use a SaveAs to save the file which was opened by you MsXl.ActiveWorkbook.SaveAs C<filename> Put below code at the end MsXl.Workbooks.Close MsXl.[Quit] On Thu, Oct 10, 2013 at 2:02 AM, Omprakash P <[email protected]> wrote: > But again it 's Saving as read only unable to delete the file by manual . > > > On Wednesday, October 9, 2013 3:24:15 PM UTC+5:30, Omprakash P wrote: > >> Hi, >> >> I wrote code to insert data in Cells Through QTP >> After Saving the document it is asking like already File Exist you want >> to replace it like that.. >> After Saving the file it saved as read only. >> I need like this >> 1.After Saving it should not ask as file already exists like that >> 2.It Should be open at that time should not show as read only like that. >> >> I wrote bellow code >> ShtPath=Datatable.GetSheet("**Global").GetParameter(1).**ValueByRow(1) >> '' >> Set MsXl=CreateObject("Excel.**Application") >> Set Mswk=MsXl.Workbooks.Open(**ShtPath) >> Set MsRes=Mswk.Worksheets("**Results") >> MsRes.Cells(2,1)="Login Form " >> dateval=TimeValue(Now) >> MsRes.Cells(2,3)=dateval >> >> Mswk.Save >> >> Thanking you >> Om Prakash >> > -- > -- > You received this message because you are subscribed to the Google > "QTP - HP Quick Test Professional - Automated Software Testing" > group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/MercuryQTP?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "QTP - HP Quick Test Professional - Automated Software Testing" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- Regards, Ganesh Muralidharan 'God Never Forgets' -- -- You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en --- You received this message because you are subscribed to the Google Groups "QTP - HP Quick Test Professional - Automated Software Testing" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
