Alex dbase

sem problemas meu fera@Basole , segue em anexo os arquivos excel xml.xlsx xmls.xml

@Basole é um xml de nota fiscal eletrônica, geralmente o intervalo é um um pouco maior A: EB, queria que lesse todos os xml e colocasse nesse intervalo de células.. tenho varios assim, segue exemplo de xml: <?xml version="1.0" encoding="UTF-8"?><nfeProc xmlns="http://www.portalfiscal.inf.br/nfe" versao="3.10"><NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe versao="3.10" Id="NFe35160353617676000195550020001284721003008273"><ide><cUF>35</cUF><cNF>00300827</cNF><natOp>VENDA teste de xml</natOp><indPag>1</indPag><mod>55</mod><serie>2</serie><nNF>128472</nNF><dhEmi>2016-03-31T11:53:00-03:00</dhEmi><tpNF>1</tpNF><idDest>1</idDest><cMunFG>3518800</cMunFG><tpImp>2</tpImp><tpEmis>1</tpEmis><cDV>3</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>1</indFinal><indPres>9</indPres><procEmi>0</procEmi><verProc>952016.02291</verProc></ide><emit><CNPJ>53617676000195</CNPJ><xNome>REIS OFFICE PRODUCTS COMERCIAL LTDA</xNome><enderEmit><xLgr>nome do cliente</xLgr><nro>3154</nro><xBairro>VILA AUGUSTA</xBairro><cMun>3518800</cMun><xMun>GUARULHOS</xMun><UF>SP</UF><CEP>07024170</CEP><cPais>1058</cPais><xPais>BRASIL</xPais><fone>1124422600</fone></enderEmit><IE>336175480112</IE><CRT>3</CRT></emit><dest><CNPJ>01579809000182</CNPJ><xNome>HAKO DISTRIBUIDORA LTDA</xNome><enderDest><xLgr>R TAQUARAL</xLgr><nro>400</nro><xBairro>JARDIM ITAPECERICA</xBairro><cMun>3522208</cMun><xMun>ITAPECERICA DA SERRA</xMun><UF>SP</UF><CEP>06853400</CEP><cPais>1058</cPais><xPais>BRASIL</xPais><fone>1155172721</fone></enderDest><indIEDest>1</indIEDest><IE>370074780117</IE><email>[email protected]</email></dest><det nItem="1"><prod><cProd>DK1201</cProd><cEAN>0125026116396</cEAN><xProd>ETIQ END padrão 400 ETIQ 29MM X 90MM QL500 550</xProd><NCM>48219000</NCM><CFOP>5102</CFOP><uCom>UN</uCom><qCom>15.0000</qCom><vUnCom>41.5</vUnCom><vProd>622.50</vProd><cEANTrib>0125026116396</cEANTrib><uTrib>UN</uTrib><qTrib>15.0000</qTrib><vUnTrib>41.5</vUnTrib><indTot>1</indTot></prod><imposto><vTotTrib>228.77</vTotTrib><ICMS><ICMS00><orig>2</orig><CST>00</CST><modBC>3</modBC><vBC>622.50</vBC><pICMS>18.00</pICMS><vICMS>112.05</vICMS></ICMS00></ICMS><IPI><cEnq>999</cEnq><IPITrib><CST>99</CST><vBC>0.00</vBC><pIPI>0.00</pIPI><vIPI>0.00</vIPI></IPITrib></IPI><PIS><PISAliq><CST>01</CST><vBC>622.50</vBC><pPIS>1.65</pPIS><vPIS>10.27</vPIS></PISAliq></PIS><COFINS><COFINSAliq><CST>01</CST><vBC>622.50</vBC><pCOFINS>7.60</pCOFINS><vCOFINS>47.31</vCOFINS></COFINSAliq></COFINS></imposto><infAdProd>CARGA TRIBUT. APROXIMADA: R$ 228,77 , SENDO:FED.: R$154,07 EST.: R$74,70 - FONTE:IBPT</infAdProd></det><total><ICMSTot><vBC>622.50</vBC><vICMS>112.05</vICMS><vICMSDeson>0.00</vICMSDeson><vBCST>0.00</vBCST><vST>0.00</vST><vProd>622.50</vProd><vFrete>0.00</vFrete><vSeg>0.00</vSeg><vDesc>0.00</vDesc><vII>0.00</vII><vIPI>0.00</vIPI><vPIS>10.27</vPIS><vCOFINS>47.31</vCOFINS><vOutro>0.00</vOutro><vNF>622.50</vNF><vTotTrib>228.77</vTotTrib></ICMSTot></total><transp><modFrete>0</modFrete><transporta><CNPJ>04251822000104</CNPJ><xNome>EMPR BRASILEIRA DE CORREIOS E TELEGRAFOS</xNome><IE>ISENTO</IE><xEnder>RUA CAVADAS 691 VILA ENDRES</xEnder><xMun>GUARULHOS</xMun><UF>SP</UF></transporta><vol><qVol>1</qVol><pesoL>3.975</pesoL><pesoB>3.975</pesoB></vol></transp><cobr><fat><nFat>128472</nFat><vOrig>622.50</vOrig><vLiq>622.50</vLiq></fat><dup><nDup>128472-01/RM</nDup><dVenc>2016-04-07</dVenc><vDup>622.50</vDup></dup></cobr><infAdic><infAdFisco>CARGA TRIBUT. APROXIMADA: R$ 228,77 , SENDO:FED.: R$154,07 EST.: R$74,70 - FONTE:IBPT - - TROCA E DEVOLUCAO SOMENTE MEDIANTE RMA AUTORIZADO PELO CAC. - VALRO DECLARADO R$622,50</infAdFisco></infAdic></infNFe><Signature xmlns="http://www.w3.org/2000/09/xmldsig#"><SignedInfo><CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315" /><SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1" /><Reference URI="#NFe35160353617676000195550020001284721003008273"><Transforms><Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature" /><Transform Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n-20010315" /></Transforms><DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" /><DigestValue>qaHAQ6pYfip38+XJR24qRBWWYiI=</DigestValue></Reference></SignedInfo><SignatureValue>F35jX6jbHGDhP+7B9hjE9ozkTj0piXmn/58Foc5EhjDjFjzD7dWBzKKhJsQZHtuVh5/V9dt9Yt6mzhtkGL3KBWryotsFJsqa4oGTBK95lc4psJl8NRYHjSvdLJL4MoAtGA2Xe35Y+FHkLNir7UXgTc8xdmCuOV5TUdx/zccgRGMFCif4IfD/ASpNYTJV4KINZ1e3QFrA9H7Eu6ems9rlcURZKrinyIpwY2sXwcM6bRmIsVWHVolnyDyKhV4Xq110xa0KJCikolNry+uYI/BhznWNi1xX6l99ZA7yoDHBOLuorCp1E+kYinRX9F7+dnpC4pT3ZznqZRvkBqcUOpOuiA==</SignatureValue><KeyInfo><X509Data><X509Certificate>MIIH2DCCBcCgAwIBAgIIEcr0VmEqtKQwDQYJKoZIhvcNAQELBQAwTDELMAkGA1UEBhMCQlIxEzARBgNVBAoTCklDUC1CcmFzaWwxKDAmBgNVBAMTH1NFUkFTQSBDZXJ0aWZpY2Fkb3JhIERpZ2l0YWwgdjIwHhcNMTMwNTIxMTUwMDAwWhcNMTYwNTIwMTUwMDAwWjCB7jELMAkGA1UEBhMCQlIxEzARBgNVBAoTCklDUC1CcmFzaWwxFDASBgNVBAsTCyhFTSBCUkFOQ08pMRgwFgYDVQQLEw8wMDAwMDEwMDQyMTQ4MTUxFDASBgNVBAsTCyhFTSBCUkFOQ08pMRQwEgYDVQQLEwsoRU0gQlJBTkNPKTEUMBIGA1UECxMLKEVNIEJSQU5DTykxFDASBgNVBAsTCyhFTSBCUkFOQ08pMRQwEgYDVQQLEwsoRU0gQlJBTkNPKTEsMCoGA1UEAxMjUkVJUyBPRkZJQ0UgUFJPRFVDVFMgQ09NRVJDSUFMIExUREEwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQCdWODSWRulexf9Y+VRsV3OYoehyHDcJGMeN/HIB/A7YPS988LAMvCNI1h+WfPRPkkiZSHVhZFTTPeorxqQJlgTuQmfiF+4qKb8SXA4j84Qgko0FEjptix9DCL7mSoEadgyT/+/Z9OQ5la81aUm1vLmKuEtNLl6Ef6XrUTiLvWz71Gk5mc2D/n4A68py7K5RW/RiPNC7mKQ1w2QHv47TMlUrHhb+YfwTX1//pOHWWeH925ltQk5FKlbeA5q9LLuR4RGnW/uWyCw2wgXiDjozc6H4mRbf1oNc/duLGgUCqDtbPrg3dsNJnXm5e4IOEgEqz/OscZ8k4Xh/gPht+YZbBT5AgMBAAGjggMZMIIDFTCBlwYIKwYBBQUHAQEEgYowgYcwRwYIKwYBBQUHMAKGO2h0dHA6Ly93d3cuY2VydGlmaWNhZG9kaWdpdGFsLmNvbS5ici9jYWRlaWFzL3NlcmFzYWNkdjIucDdiMDwGCCsGAQUFBzABhjBodHRwOi8vb2NzcC5jZXJ0aWZpY2Fkb2RpZ2l0YWwuY29tLmJyL3NlcmFzYWNkdjIwHwYDVR0jBBgwFoAUmuCDENcmm+m62oKygc45GtOHcIYwcQYDVR0gBGowaDBmBgZgTAECAwMwXDBaBggrBgEFBQcCARZOaHR0cDovL3B1YmxpY2FjYW8uY2VydGlmaWNhZG9kaWdpdGFsLmNvbS5ici9yZXBvc2l0b3Jpby9kcGMvZGVjbGFyYWNhby1zY2QucGRmMIHwBgNVHR8EgegwgeUwSaBHoEWGQ2h0dHA6Ly93d3cuY2VydGlmaWNhZG9kaWdpdGFsLmNvbS5ici9yZXBvc2l0b3Jpby9sY3Ivc2VyYXNhY2R2Mi5jcmwwQ6BBoD+GPWh0dHA6Ly9sY3IuY2VydGlmaWNhZG9zLmNvbS5ici9yZXBvc2l0b3Jpby9sY3Ivc2VyYXNhY2R2Mi5jcmwwU6BRoE+GTWh0dHA6Ly9yZXBvc2l0b3Jpby5pY3BicmFzaWwuZ292LmJyL2xjci9TZXJhc2EvcmVwb3NpdG9yaW8vbGNyL3NlcmFzYWNkdjIuY3JsMA4GA1UdDwEB/wQEAwIF4DAdBgNVHSUEFjAUBggrBgEFBQcDAgYIKwYBBQUHAwQwgcIGA1UdEQSBujCBt4EkRkFUVVJBTUVOVE8uTUFUUklaQFJFSVNPRkZJQ0UuQ09NLkJSoD4GBWBMAQMEoDUTMzI3MTIxOTgwMjg3NDI0NTg4NzAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMKAbBgVgTAEDAqASExBSQUZBRUwgTUVMTyBSRUlToBkGBWBMAQMDoBATDjUzNjE3Njc2MDAwMTk1oBcGBWBMAQMHoA4TDDAwMDAwMDAwMDAwMDANBgkqhkiG9w0BAQsFAAOCAgEAHwNZcFsrIOslxq4hJrAopc+GnWU62iTQQUX6/aM3Cn/4kOe7m8zfzRDO1Trvs3OY/OWkXJ7qxR28fNfKU84sJ8jvgCnXJQU+MVWqSQZVdNftj6g3p9ahFg7zgXMuC57+BTgUuYwxIGi1pWDg10JRCWhvX6ZSxMr+ltmesoU3D50/T7hEfmpMDKteAt1iIGxmuYjim0d6JoUopTpQHgA1C8QvKEGVtWepYtf8MELCOzZNzMuJJs/7CPFb8fxkDA/TEcAh4SJjH3yIDhnq4JLAQFWCj/x7vkuwphAl0q6fr2OpTPe2wwf6syfIzckGiWl0M+xTO3vf8hKxwLCOG06dfeS9tOjVzcyqSXM18AVINGbbrHC1d/yUreSU0ljCwbvwrAkoNz2x58/eGslkUYWO6Fb4Q8R9s15mWTX1VDXAlHTHFiSRV2cykHuAZujnGC8hL34bTe+Rim48EnePjPruIxcyuQmtefhenGgcqVZFfEjR+dm6KHCuFtb14r77d7chmSZt8K6IOY3ttVk5QEdf9nIBonZg5OPkAwsEMOjppNvIsFZN/d8rVwYAxaLvNBw2ylU/XIhzj1hdoHrjBOhjE6rwq5ikSPtl0FHOzP8tHis46PWq0jatmvAyL7y6MkSX/ghRpKTqCRqi72Ss4q/QF03bKVNxjrJQSPN5HAHLUjc=</X509Certificate></X509Data></KeyInfo></Signature></NFe><protNFe versao="3.10"><infProt Id="ID135160195837761"><tpAmb>1</tpAmb><verAplic>SP_NFE_PL_008h2</verAplic><chNFe>35160353617676000195550020001284721003008273</chNFe><dhRecbto>2016-03-31T14:43:33-03:00</dhRecbto><nProt>135160195837761</nProt><digVal>qaHAQ6pYfip38+XJR24qRBWWYiI=</digVal><cStat>100</cStat><xMotivo>Autorizado o uso da NF-e</xMotivo></infProt></protNFe></nfeProc>

Boa tarde pessoal, preciso criar uma macro no excel pra ler arquivos xml tenho um diretório no disco C:\ notas que tem 35 xml preciso pegar esses xml que estão nesse diretório jogar na planilha ] preciso que importe todos xml na mesma planilha, pois são todos da mesma configuração tentei alguns comandos e não deu certo...por favor me ajudem