We help IT Professionals succeed at work.

Can we import data from more than 1 excel sheets into the QTP at run time ?

agcps
agcps asked
on
425 Views
Last Modified: 2008-10-20
Can we import data from more than 1 excel sheets into the QTP at run time ?
Comment
Watch Question

ExcelGuideConsultant

Commented:
I guess that would be possible, but I am not really sure what QTP is. I am for sure you can open up multiple excel files in vbs and then import them in a loop. If this would not work, then you could create one excel file from the multiple excel files and import that specific file.

Author

Commented:
Yeah Thanks for the suggestion. Can u please help me in one more thing so that i can implement the idea you have suggested

1) I have to select the data in excel in a used range
       Like : If i have used the excel sheet from A1 to D10 the i should be able to select only the area A1 to D10

I dont want to use ExcelSheet.Range("A1:D10").select

As the data keeps on changing and i can keep the values static for selecting the range in excel.

Can u help me in finding the way to select the used range from an excel.


Consultant
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks a lot for that syntax... thats working.


ExcelGuideConsultant

Commented:
strange, first it is solved and then it is not? User doesnt even ask further....

Author

Commented:
Hi,

The main question did not get solved so could not accept your previous solution.

On your request i have accepted the previous solution for my second query and closing this question.

Thanks for the help buddy.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.