Hello Dear Two ways you can import your XML Data in your Workbook
1. Manually Importing XML Data 2. Programmatically Importing XML Data Now how to……. 1. Manually Importing XML Data: 1. Start Excel and then click Open on the File menu. 2. In the Files of type list, select XML files. 3. Select the XML file you want to open and then click Open. 4. If the file has multiple XSL style sheets, you are prompted to select one of the style sheets. Select a style sheet if you want to apply a style sheet. Or, click Cancel to not select a style sheet. 2. Programmatically Importing XML Data: ' <http://Myserver/Myfolder/xml filename.xml> represents the Web server ' location and the name of the XML file you want to save. You can also ' specify a folder on your hard disk rather than a URL. ' ' If the XML file references more than one style sheet, ' use the StyleSheets parameter to specify one or more style ' sheets. If you want to apply only one referenced style sheet, ' specify the index number of that sheet reference in the document. ' If you want to apply multiple style sheets, enter all ' the index numbers as members of an array, similar to this: ' ' Array(1, 2) ' ' In this case, the first and second style sheets are referenced in ' the XML file. ' Workbooks.OpenXML "<http://Myserver/Myfolder/xml filename.xml>", _ <style sheet> Hope it Will Help Happy To Help :) Prashant Tripathi On Fri, Apr 9, 2010 at 1:06 AM, OldDog <mikef2...@comcast.net> wrote: > Hi, > > I recorded a macro in Excell 2007 to import an xml file. > As I wnet through the steps manualy everything workeed fine. > > When i try to run the macro I get an error. > > Here is the macro I recorded: > > Sub xml2() > ' > ' xml2 Macro > ' > > ' > Range("A1").Select > ActiveWorkbook.XmlMaps("SecScan_Map").Import URL:= _ > "C:\Documents and Settings\My Documents\Scripts\xml > \MSGWBESIADSM10.xml" > > End Sub > > And here is the error: > > Rub-time error '9': > > Subscript out of range. > > What do I need to do to fix this? > > TIA; > > OldDog > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > > To unsubscribe, reply using "remove me" as the subject. > -- Thanks Regards Shyam Software Engineer '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
