+ Reply to Thread
Results 1 to 1 of 1

Vba to get values from XML and paste it in excel.

  1. #1
    Registered User
    Join Date
    05-21-2014
    Posts
    19

    Arrow Vba to get values from XML and paste it in excel.

    hi all,

    I am new to macro vba. Help me to solve below query

    I am having a xml file. Get a xml file by clicking on a button. i want the specific values from that xml and paste it in the excel file using vba.

    In that xml file, there will be so many scripts and the corresponding transaction names with the value of 90percent.
    I need to get the script names and the corresponding transaction names with 90percent values.
    I have attached my sample xml file.
    I have to get the output in excel in the format below.

    ----------- SCRIPT NAME - Script1_29042014.bdf/VUser-Profile1 ----------------
    Transaction Name 90Percentile

    17_Recentwork 0.267590953
    T01_Launch 0.461530000
    T02_Click_Login 0.906243333

    ----------- SCRIPT NAME - Help_29042014.bdf/VUser-Profile1 ----------------
    Transaction Name 90Percentile

    Help_T01_Launch 0.452333333
    Help_T02_Login 0.811000000
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 05-14-2014, 12:52 AM
  2. [SOLVED] Excel 2010 - Paste Values with Paste Transpose at the same time
    By phillyfilly in forum Excel General
    Replies: 3
    Last Post: 11-05-2013, 04:23 AM
  3. Excel allow Copy and Paste Values only
    By kaseyleigh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-30-2013, 08:41 AM
  4. Replies: 1
    Last Post: 12-05-2012, 11:37 AM
  5. [SOLVED] Excel 2002 - Can only paste values, wont let me paste special
    By MK_Chopper_P in forum Excel General
    Replies: 2
    Last Post: 07-12-2012, 02:22 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1