[vinotech]

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]

I'm a little confused can you post your xl sheet?

[vinotech]

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