GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  QTP
Go To First  |  Previous Question  |  Next Question 
 QTP  |  Question 620 of 642    Print  
Copy a Worksheet
How to Copy a Worksheet to a New Spreadsheet using VBS


  
Total Answers and Comments: 1 Last Update: May 30, 2008     Asked by: MobinPeer 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
May 30, 2008 10:17:19   #1  
md_vinodh Member Since: April 2008   Contribution: 32    

RE: Copy a Worksheet
Do Export and Import where u want , kind of copy the excel sheet, please find the Syntax for export and import

DataTable.ExportSheet(filePath)
DataTable.Import ( FilePath)

 
Is this answer useful? Yes | No

 Related Questions

Hi,Lets say i generate QTP scripts and save the scripts in D:QTP1.Now on an other PC if i copy the scripts to say C:QTP2 folder i cannot see the reusable action nor can call any other action. Can some one explain me why this happens and a way in which i can make my scripts independent of location where it is stored.
Read Answers (5) | Asked by : Mahendra

How can i save result on text format so i can send that copy to team for viewing the resultsthanks in advance
Read Answers (2) | Asked by : priya123

Can we copy a single Object in a Per Action Object Repository to Shared Repository mode.If so then how ?
Read Answers (1) | Asked by : Satish

How do we copy or move an object from one hierarchy to another hierarchy of the object repository in Version 8.2?Please help asap ... very urgentthanks
View Question | Asked by : qtpqa

While recording the script to enetr a valuae in a textbox in a table in a web page , the text box was object was stored in the following hierarchy:Browser> Windows web page dialog->GlobalReinsurance Home->Formframe.Now when i try to add the Webtable in which the text box is present to the Object repository it is creating a new hierarchy as followsBrowser->global Reinsurance Home->Formframe_4 ->WebtableNow i want this Webtable object to be moved to the first mention hierarchy..How do i move this
View Question | Asked by : qtpqa

Hi, I want the script which access remote computer and copy specific folder from remote computer to local machine.Kindly help me..Regards,K.Prema.
Read Answers (1) | Asked by : meera

Latest Answer : hai,there is diff in these actions.we use this actions in modular framework. these are reusable.in call to existing action we canot make change or customize script as u wish.if u dont clear once u see call to existing action keep cursor and try to add ...
Read Answers (2) | Asked by : sree

How many actions we can create with in a test?When do we choose calling or Copy of action?What is meant by action?
Read Answers (2) | Asked by : vinay

1)How to change a custom object to standard object in QTP ?2)How to create a excel sheet & insert a value in it by using script?3)What is the difference between call to existing action & call to copy action?4)what 
Latest Answer : 1)How to change a custom object to standard object in QTP?---By using Virtual Object wizard we can map those objects which are not recognized by the tool to a standard object so that it will be identified by the tool.2)How to create a excel sheet & ...
Read Answers (4) | Asked by : M.Harish kumar

How to Copy a Worksheet to a New Spreadsheet using VBS 
Latest Answer : Do Export and Import where u want , kind of copy the excel sheet, please find the Syntax for export and import DataTable.ExportSheet(filePath)DataTable.Import ( FilePath) ...


 Sponsored Links

 
Related Articles

Tech Tip: Learn about Locks

One of the popular features of the J2SE 5.0 libraries is the addition of concurrency utilities. Locking is one of the areas improved by the concurrency utilities. Learn more in this tech tip.
 

Configuring a VIA Rhine-Based NIC on the Solaris 10 OS (Community Tech Tip)

This reader-submitted Tech Tip shows how to configure a VIA Rhine chipset-based network interface card, using the Solaris 10 OS for x86 platforms.
 

Configuring the Audio Driver for an AC97 Audio Controller (Community Tech Tip)

In this reader-submitted Tip, learn how to configure a VT8233/VT8235 VIA chipset-based built-in audio device, using the Solaris 10 OS for x86 platforms.
 

Community-Submitted Tech Tip: A CD-Free Installer for the Solaris OS

A BigAdmin reader suggests a method for installing the Solaris OS that is similar to network-type installation, but doesn't require burning the boot CD.
 

A One Dollar Project Using the Solaris Containers Feature (Community Tech Tip)

A BigAdmin reader shows how to configure a workstation running the Solaris 10 OS with two zones: one with an Oracle 10g database and the other with the Apache Tomcat 5.5.4 application server.
 

Populating an Excel 2003 Worksheet with Multiple Related Records from a Windows Form

Learn to display Microsoft Windows Forms from an Excel 2003 workbook, display related records, and write that information into formatted worksheets.
 

5th day rally, tech stocks shine (India Infoline)

The northbound journey continued in the market as the Sensex touched an intra-day high of above 8700 mark in a highly volatile market.
 

High Tech Industry Leaders Will Discuss Strategies for Driving ... - PR Newswire (press release)

High Tech Industry Leaders Will Discuss Strategies for Driving ...PR Newswire (press release), NY - Sep 26, 2005... Participants include Vivek Paul, IT strategist and former CEO of Wipro Technologies, and Kailash Joshi, the global business executive responsible for IBM's ...
 

INFO-TECH OUTSOURCING (The Hindu)

SPRINGER Science and Business Media plans to expand its India operations through its two subsidiaries ? a BPO and a publishing group that produces reprints of specialised books. As part of its long-term plan to make India one of its key ...
 

On the Agenda: Find, Keep High-tech Talent

High-tech talent may soon be in short supply again. The buzz at the recent Society for Information Management symposium in Boston was about the challenges employers are facing in recruiting and retaining technology workers....
 

Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape