1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

VBA Code to open a XML Hyperlink and convert to Excel file

Discussion in 'Business Applications' started by vinotech, May 31, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. vinotech

    vinotech Thread Starter

    Joined:
    Oct 21, 2011
    Messages:
    32
    Hi Guys,

    I need a help with excel macro's.

    I have a excel file with a set of hyperlink(to open a XML file). I need the data's in all the hyperlink (.XML file) in an excel format.
    Could you please help me out? Is this possible to do with VBA macro?

    Please advice.

    Thank You
     
  2. BPCS

    BPCS

    Joined:
    May 26, 2012
    Messages:
    131
    I'm a little confused can you post your xl sheet?
     
  3. vinotech

    vinotech Thread Starter

    Joined:
    Oct 21, 2011
    Messages:
    32
    Hi BPCS,
    Thanks for your reply
    Please find attached the sample excel file i have created.

    The sheet 1 have the list of hyperlinks(.XML File).
    All i need is the .XML File in the hyperlink to convert as a excel one and list the data in the Sheet 2.
    See the excel file attached for your reference.
    Please let me know, if i am not clear. Once again thank you very much for lookng in to this

    Thank You
     

    Attached Files:

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1055288