Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

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


(!)

vinotech's Avatar
vinotech vinotech is offline
Member with 32 posts.
THREAD STARTER
 
Join Date: Oct 2011
Experience: Intermediate
31-May-2012, 11:53 AM #1
VBA Code to open a XML Hyperlink and convert to Excel file
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
BPCS's Avatar
BPCS BPCS is offline
Member with 131 posts.
 
Join Date: May 2012
Location: Massachusetts
Experience: Advanced
31-May-2012, 03:59 PM #2
I'm a little confused can you post your xl sheet?
vinotech's Avatar
vinotech vinotech is offline
Member with 32 posts.
THREAD STARTER
 
Join Date: Oct 2011
Experience: Intermediate
01-Jun-2012, 12:33 PM #3
Thank yo
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
File Type: xlsx Sample File.xlsx (11.3 KB, 142 views)
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
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.


Tags
excel, macro

(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑

Content Relevant URLs by vBSEO 3.3.2