There are two ways to do that. 1. Import that sheet into a datatable 2. Export back with rename
DataTable.ImportSheet "C:\Test.xls",1,1 DataTable.ExportSheet "C:\Test1.xls",1 You can apply sheet names and action name instead of '1' 2. Create an excel object and save it with different.. you can google and you will find lots of references .. On Tuesday, October 1, 2013 1:34:43 PM UTC-4, surabhi wrote: > > hi all, > > Can anyone suggest or have any code that will open the existing Excel > sheet "EXCEL1"; create a duplicate sheet of this and do a save as "Excel2"? > it is little urgent. > > Thanks > -- -- 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.
