Este fórum está sendo desativado

[BrunoLuiel]

Olá amigos! Por gentileza, uma ideia... Estou em busca de um relatório que me ajude a conferir várias notas de uma vez. Pretendo fazer com que seja importado de algumas tags específicas de vários arquivos XMLs de uma vez (todos arquivos XMLs de uma referida pasta). Fiz um rascunho da ideia que está abaixo. Também estou enviando 2 XMLs que foi de onde fiz a simulação (deixei o XML descrito abaixo).

Toda a ajuda é bem vinda, seja um vídeo onde posso encontrar formas de fazer essa importação selecionada ou algum VBA que posso usar para essas importações.

------------------------------------------------------------------



--------------------------------------------------------------------

XML1:

<nfeProc versao="4.00" xmlns="http://www.portalfiscal.inf.br/nfe"><NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe51200800988303000750550100000175361101742627" versao="4.00"><ide><cUF>51</cUF><cNF>10174262</cNF><natOp>TRANSFERENCIA DE PRODUCAO DO ESTABELECIMENTO</natOp><mod>55</mod><serie>10</serie><nNF>17536</nNF><dhEmi>2020-08-06T08:49:42-04:00</dhEmi><dhSaiEnt>2020-08-06T08:49:42-04:00</dhSaiEnt><tpNF>1</tpNF><idDest>2</idDest><cMunFG>5103403</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>7</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>1</indPres><procEmi>0</procEmi><verProc>NF-e Albatroz 4.00</verProc></ide><emit><CNPJ>00988303000750</CNPJ><xNome>REAL E CIA LTDA - FILIAL CUIABA CD</xNome><enderEmit><xLgr>RUA K PAVLH IV</xLgr><nro>1398</nro><xBairro>DISTRITO INDUSTRIAL</xBairro><cMun>5103403</cMun><xMun>CUIABA</xMun><UF>MT</UF><CEP>78098370</CEP><cPais>1058</cPais><xPais>BRASIL</xPais><fone>6530529000</fone></enderEmit><IE>134225821</IE><CRT>3</CRT></emit><dest><CNPJ>00988303000679</CNPJ><xNome>REAL E CIA LTDA - JI-PARANA</xNome><enderDest><xLgr>AV TRANSCONTINENTAL</xLgr><nro>0</nro><xBairro>FLORIDA</xBairro><cMun>1100122</cMun><xMun>JI PARANA</xMun><UF>RO</UF><CEP>76914650</CEP><cPais>1058</cPais><xPais>BRASIL</xPais><fone>6934240101</fone></enderDest><indIEDest>1</indIEDest><IE>00000001761528</IE><email>realh@realh.com.br</email></dest><autXML><CPF>05411739870</CPF></autXML><autXML><CPF>39548376920</CPF></autXML><det nItem="1"><prod><cProd>13430602</cProd><cEAN>SEM GTIN</cEAN><xProd>COMBO 20 - 30 KG</xProd><NCM>23099090</NCM><CFOP>6151</CFOP><uCom>SC</uCom><qCom>15.0000</qCom><vUnCom>17.3253333333</vUnCom><vProd>259.88</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>SC</uTrib><qTrib>15.0000</qTrib><vUnTrib>17.3253333333</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="2"><prod><cProd>13430601</cProd><cEAN>SEM GTIN</cEAN><xProd>COMBO 30 - 30 KG</xProd><NCM>23099090</NCM><CFOP>6151</CFOP><uCom>SC</uCom><qCom>50.0000</qCom><vUnCom>18.7204000000</vUnCom><vProd>936.02</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>SC</uTrib><qTrib>50.0000</qTrib><vUnTrib>18.7204000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="3"><prod><cProd>10100021001</cProd><cEAN>7898963775515</cEAN><xProd>SUPL MIN REAL H LEITE - 30 KG</xProd><NCM>23099090</NCM><CFOP>6151</CFOP><uCom>SC</uCom><qCom>120.0000</qCom><vUnCom>34.2785000000</vUnCom><vProd>4113.42</vProd><cEANTrib>7898963775515</cEANTrib><uTrib>SC</uTrib><qTrib>120.0000</qTrib><vUnTrib>34.2785000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="4"><prod><cProd>11215338</cProd><cEAN>7898664000060</cEAN><xProd>HOMEOBOVIS PARASIT 100 (INCOR REAL H LEITE)</xProd><NCM>30044990</NCM><CFOP>6152</CFOP><uCom>UTL</uCom><qCom>120.0000</qCom><vUnCom>1.7000000000</vUnCom><vProd>204.00</vProd><cEANTrib>7898664000060</cEANTrib><uTrib>UTL</uTrib><qTrib>120.0000</qTrib><vUnTrib>1.7000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="5"><prod><cProd>13418682</cProd><cEAN>7898963775102</cEAN><xProd>RACAOMAX EQUINO PELETIZADA - 30 KG</xProd><NCM>23099090</NCM><CFOP>6151</CFOP><uCom>SC</uCom><qCom>1.0000</qCom><vUnCom>22.2500000000</vUnCom><vProd>22.25</vProd><cEANTrib>7898963775102</cEANTrib><uTrib>SC</uTrib><qTrib>1.0000</qTrib><vUnTrib>22.2500000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="6"><prod><cProd>10100018001</cProd><cEAN>7898963775485</cEAN><xProd>SUPL MIN REAL H 800 - 30 KG</xProd><NCM>23099090</NCM><CFOP>6151</CFOP><uCom>SC</uCom><qCom>55.0000</qCom><vUnCom>35.9025454545</vUnCom><vProd>1974.64</vProd><cEANTrib>7898963775485</cEANTrib><uTrib>SC</uTrib><qTrib>55.0000</qTrib><vUnTrib>35.9025454545</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="7"><prod><cProd>11215336</cProd><cEAN>7898664000060</cEAN><xProd>HOMEOBOVIS PARASIT 100 (INCOR REAL H 800)</xProd><NCM>30044990</NCM><CFOP>6152</CFOP><uCom>UTL</uCom><qCom>55.0000</qCom><vUnCom>1.7000000000</vUnCom><vProd>93.50</vProd><cEANTrib>7898664000060</cEANTrib><uTrib>UTL</uTrib><qTrib>55.0000</qTrib><vUnTrib>1.7000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="8"><prod><cProd>10100046001</cProd><cEAN>7898963775508</cEAN><xProd>SUPL MINERAL REAL H OVINO-30 KG</xProd><NCM>23099090</NCM><CFOP>6151</CFOP><uCom>SC</uCom><qCom>10.0000</qCom><vUnCom>30.9480000000</vUnCom><vProd>309.48</vProd><cEANTrib>7898963775508</cEANTrib><uTrib>SC</uTrib><qTrib>10.0000</qTrib><vUnTrib>30.9480000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="9"><prod><cProd>10400015001</cProd><cEAN>7898963775010</cEAN><xProd>UREMAX 150 - 30 KG</xProd><NCM>23099090</NCM><CFOP>6151</CFOP><uCom>SC</uCom><qCom>69.0000</qCom><vUnCom>20.2323188406</vUnCom><vProd>1396.03</vProd><cEANTrib>7898963775010</cEANTrib><uTrib>SC</uTrib><qTrib>69.0000</qTrib><vUnTrib>20.2323188406</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="10"><prod><cProd>13413086</cProd><cEAN>7898963775034</cEAN><xProd>UREMAX LEITE - 30 KG</xProd><NCM>23099090</NCM><CFOP>6151</CFOP><uCom>SC</uCom><qCom>5.0000</qCom><vUnCom>32.3520000000</vUnCom><vProd>161.76</vProd><cEANTrib>7898963775034</cEANTrib><uTrib>SC</uTrib><qTrib>5.0000</qTrib><vUnTrib>32.3520000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="11"><prod><cProd>10900010001</cProd><cEAN>7898963775799</cEAN><xProd>SUPL MIN LACTOMAX - 30 KG</xProd><NCM>23099090</NCM><CFOP>6151</CFOP><uCom>SC</uCom><qCom>293.0000</qCom><vUnCom>32.3064846416</vUnCom><vProd>9465.80</vProd><cEANTrib>7898963775799</cEANTrib><uTrib>SC</uTrib><qTrib>293.0000</qTrib><vUnTrib>32.3064846416</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="12"><prod><cProd>21215318</cProd><cEAN>7898664000060</cEAN><xProd>HOMEOBOVIS PARASIT 100 (INCOR LACTOMAX)</xProd><NCM>30044990</NCM><CFOP>6152</CFOP><uCom>UTL</uCom><qCom>293.0000</qCom><vUnCom>1.7000000000</vUnCom><vProd>498.10</vProd><cEANTrib>7898664000060</cEANTrib><uTrib>UTL</uTrib><qTrib>293.0000</qTrib><vUnTrib>1.7000000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</vICMS><vICMSDeson>0.00</vICMSDeson><vFCP>0.00</vFCP><vBCST>0.00</vBCST><vST>0.00</vST><vFCPST>0.00</vFCPST><vFCPSTRet>0.00</vFCPSTRet><vProd>19434.88</vProd><vFrete>0.00</vFrete><vSeg>0.00</vSeg><vDesc>0.00</vDesc><vII>0.00</vII><vIPI>0.00</vIPI><vIPIDevol>0.00</vIPIDevol><vPIS>0.00</vPIS><vCOFINS>0.00</vCOFINS><vOutro>0.00</vOutro><vNF>19434.88</vNF></ICMSTot></total><transp><modFrete>0</modFrete><transporta><CPF>39548376920</CPF><xNome>CLEZIO KUKER</xNome><xEnder>RUA ANGELO ZONIN</xEnder><xMun>CASCAVEL</xMun><UF>PR</UF></transporta><vol><qVol>618</qVol><esp>SC</esp><marca>REAL H</marca><nVol>618</nVol><pesoL>18540.000</pesoL><pesoB>18540.000</pesoB></vol></transp><pag><detPag><tPag>90</tPag><vPag>0.00</vPag></detPag></pag><infAdic><infAdFisco>TRANSFERENCIA DE MERCADORIAS</infAdFisco><infCpl>DADOS SIS: Nr.TRANSACAO:10174262 - TIPO:07 - DATA:06/08/2020 - OPERADOR:5137 - OBS SISTEMA:Contribuinte dispensado do ICMS nas operacoes de transferencia conforme Liminar no 1009499-18.2017.8.11.0000</infCpl></infAdic></infNFe><Signature xmlns="http://www.w3.org/2000/09/xmldsig#"><Si ... tionMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n- ... tureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><Reference URI="#NFe51200800988303000750550100000175361101742627"><Transforms><Transform Algorithm="http://www.w3.org/2000/09/xmldsig#envel ... <Transform Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n- ... gestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" ... e><protNFe versao="4.00"><infProt><tpAmb>1</tpAmb><verAplic>MT_A2RL-4.00</verAplic><chNFe>51200800988303000750550100000175361101742627</chNFe><dhRecbto>2020-08-06T09:10:00-04:00</dhRecbto><nProt>151200044938097</nProt><digVal>JLlZZek6xqLbXDXcAa+Y5Qg6fnE=</digVal><cStat>100</cStat><xMotivo>Autorizado o uso da NF-e</xMotivo></infProt></protNFe></nfeProc>

----------------------------------------------------------------------------
XML2

<nfeProc versao="4.00" xmlns="http://www.portalfiscal.inf.br/nfe"><NFe xmlns="http://www.portalfiscal.inf.br/nfe"><infNFe Id="NFe51200800988303000750550100000175171101734866" versao="4.00"><ide><cUF>51</cUF><cNF>10173486</cNF><natOp>TRANSFERENCIA DE PRODUCAO DO ESTABELECIMENTO</natOp><mod>55</mod><serie>10</serie><nNF>17517</nNF><dhEmi>2020-08-03T15:08:29-04:00</dhEmi><dhSaiEnt>2020-08-03T15:08:29-04:00</dhSaiEnt><tpNF>1</tpNF><idDest>2</idDest><cMunFG>5103403</cMunFG><tpImp>1</tpImp><tpEmis>1</tpEmis><cDV>6</cDV><tpAmb>1</tpAmb><finNFe>1</finNFe><indFinal>0</indFinal><indPres>1</indPres><procEmi>0</procEmi><verProc>NF-e Albatroz 4.00</verProc></ide><emit><CNPJ>00988303000750</CNPJ><xNome>REAL E CIA LTDA - FILIAL CUIABA CD</xNome><enderEmit><xLgr>RUA K PAVLH IV</xLgr><nro>1398</nro><xBairro>DISTRITO INDUSTRIAL</xBairro><cMun>5103403</cMun><xMun>CUIABA</xMun><UF>MT</UF><CEP>78098370</CEP><cPais>1058</cPais><xPais>BRASIL</xPais><fone>6530529000</fone></enderEmit><IE>134225821</IE><CRT>3</CRT></emit><dest><CNPJ>00988303000679</CNPJ><xNome>REAL E CIA LTDA - JI-PARANA</xNome><enderDest><xLgr>AV TRANSCONTINENTAL</xLgr><nro>0</nro><xBairro>FLORIDA</xBairro><cMun>1100122</cMun><xMun>JI PARANA</xMun><UF>RO</UF><CEP>76914650</CEP><cPais>1058</cPais><xPais>BRASIL</xPais><fone>6934240101</fone></enderDest><indIEDest>1</indIEDest><IE>00000001761528</IE><email>realh@realh.com.br</email></dest><autXML><CPF>05411739870</CPF></autXML><autXML><CPF>99446383900</CPF></autXML><det nItem="1"><prod><cProd>10339</cProd><cEAN>7898963775782</cEAN><xProd>SUPL MIN CRIAMAX - 30 KG</xProd><NCM>23099090</NCM><CFOP>6151</CFOP><uCom>SC</uCom><qCom>50.0000</qCom><vUnCom>31.9446000000</vUnCom><vProd>1597.23</vProd><cEANTrib>7898963775782</cEANTrib><uTrib>SC</uTrib><qTrib>50.0000</qTrib><vUnTrib>31.9446000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="2"><prod><cProd>13420658</cProd><cEAN>7898963775065</cEAN><xProd>ENGORDA H 32 PASTO-30 KG</xProd><NCM>23099090</NCM><CFOP>6151</CFOP><uCom>SC</uCom><qCom>130.0000</qCom><vUnCom>33.1503076923</vUnCom><vProd>4309.54</vProd><cEANTrib>7898963775065</cEANTrib><uTrib>SC</uTrib><qTrib>130.0000</qTrib><vUnTrib>33.1503076923</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="3"><prod><cProd>10900010001</cProd><cEAN>7898963775799</cEAN><xProd>SUPL MIN LACTOMAX - 30 KG</xProd><NCM>23099090</NCM><CFOP>6151</CFOP><uCom>SC</uCom><qCom>20.0000</qCom><vUnCom>32.3065000000</vUnCom><vProd>646.13</vProd><cEANTrib>7898963775799</cEANTrib><uTrib>SC</uTrib><qTrib>20.0000</qTrib><vUnTrib>32.3065000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="4"><prod><cProd>13430587</cProd><cEAN>SEM GTIN</cEAN><xProd>NUCLEO MINERAL 130 - 25 KG</xProd><NCM>23099090</NCM><CFOP>6151</CFOP><uCom>SC</uCom><qCom>30.0000</qCom><vUnCom>40.4046666667</vUnCom><vProd>1212.14</vProd><cEANTrib>SEM GTIN</cEANTrib><uTrib>SC</uTrib><qTrib>30.0000</qTrib><vUnTrib>40.4046666667</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="5"><prod><cProd>10900001001</cProd><cEAN>7898963775645</cEAN><xProd>RACAO PRO-RUMENMAX - 30 KG</xProd><NCM>23099090</NCM><CFOP>6151</CFOP><uCom>SC</uCom><qCom>100.0000</qCom><vUnCom>23.0628000000</vUnCom><vProd>2306.28</vProd><cEANTrib>7898963775645</cEANTrib><uTrib>SC</uTrib><qTrib>100.0000</qTrib><vUnTrib>23.0628000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="6"><prod><cProd>10100017001</cProd><cEAN>7898963775461</cEAN><xProd>SUPL MIN REAL H 650 - 30 KG</xProd><NCM>23099090</NCM><CFOP>6151</CFOP><uCom>SC</uCom><qCom>120.0000</qCom><vUnCom>31.0650833333</vUnCom><vProd>3727.81</vProd><cEANTrib>7898963775461</cEANTrib><uTrib>SC</uTrib><qTrib>120.0000</qTrib><vUnTrib>31.0650833333</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="7"><prod><cProd>10100018001</cProd><cEAN>7898963775485</cEAN><xProd>SUPL MIN REAL H 800 - 30 KG</xProd><NCM>23099090</NCM><CFOP>6151</CFOP><uCom>SC</uCom><qCom>150.0000</qCom><vUnCom>35.9026000000</vUnCom><vProd>5385.39</vProd><cEANTrib>7898963775485</cEANTrib><uTrib>SC</uTrib><qTrib>150.0000</qTrib><vUnTrib>35.9026000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="8"><prod><cProd>10100021001</cProd><cEAN>7898963775515</cEAN><xProd>SUPL MIN REAL H LEITE - 30 KG</xProd><NCM>23099090</NCM><CFOP>6151</CFOP><uCom>SC</uCom><qCom>277.0000</qCom><vUnCom>36.0258844765</vUnCom><vProd>9979.17</vProd><cEANTrib>7898963775515</cEANTrib><uTrib>SC</uTrib><qTrib>277.0000</qTrib><vUnTrib>36.0258844765</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="9"><prod><cProd>13418711</cProd><cEAN>7898963775553</cEAN><xProd>SUPL MIN REBANHO 40 - 30 KG</xProd><NCM>23099090</NCM><CFOP>6151</CFOP><uCom>SC</uCom><qCom>50.0000</qCom><vUnCom>21.2828000000</vUnCom><vProd>1064.14</vProd><cEANTrib>7898963775553</cEANTrib><uTrib>SC</uTrib><qTrib>50.0000</qTrib><vUnTrib>21.2828000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="10"><prod><cProd>13418713</cProd><cEAN>7898963775577</cEAN><xProd>SUPL MIN REBANHO 65 - 30 KG</xProd><NCM>23099090</NCM><CFOP>6151</CFOP><uCom>SC</uCom><qCom>90.0000</qCom><vUnCom>29.3285555556</vUnCom><vProd>2639.57</vProd><cEANTrib>7898963775577</cEANTrib><uTrib>SC</uTrib><qTrib>90.0000</qTrib><vUnTrib>29.3285555556</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="11"><prod><cProd>10900003001</cProd><cEAN>7898963775669</cEAN><xProd>SUPL MIN PROTEICO RECRIMAX - 30 KG</xProd><NCM>23099090</NCM><CFOP>6151</CFOP><uCom>SC</uCom><qCom>55.0000</qCom><vUnCom>22.4060000000</vUnCom><vProd>1232.33</vProd><cEANTrib>7898963775669</cEANTrib><uTrib>SC</uTrib><qTrib>55.0000</qTrib><vUnTrib>22.4060000000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><det nItem="12"><prod><cProd>10100045001</cProd><cEAN>7898963775522</cEAN><xProd>SUPL MIN REAL H VITALEITE - 30 KG</xProd><NCM>23099090</NCM><CFOP>6151</CFOP><uCom>SC</uCom><qCom>40.0000</qCom><vUnCom>35.2472500000</vUnCom><vProd>1409.89</vProd><cEANTrib>7898963775522</cEANTrib><uTrib>SC</uTrib><qTrib>40.0000</qTrib><vUnTrib>35.2472500000</vUnTrib><indTot>1</indTot></prod><imposto><ICMS><ICMS40><orig>0</orig><CST>41</CST></ICMS40></ICMS><IPI><cEnq>999</cEnq><IPINT><CST>53</CST></IPINT></IPI><PIS><PISNT><CST>08</CST></PISNT></PIS><COFINS><COFINSNT><CST>08</CST></COFINSNT></COFINS></imposto></det><total><ICMSTot><vBC>0.00</vBC><vICMS>0.00</vICMS><vICMSDeson>0.00</vICMSDeson><vFCP>0.00</vFCP><vBCST>0.00</vBCST><vST>0.00</vST><vFCPST>0.00</vFCPST><vFCPSTRet>0.00</vFCPSTRet><vProd>35509.62</vProd><vFrete>0.00</vFrete><vSeg>0.00</vSeg><vDesc>0.00</vDesc><vII>0.00</vII><vIPI>0.00</vIPI><vIPIDevol>0.00</vIPIDevol><vPIS>0.00</vPIS><vCOFINS>0.00</vCOFINS><vOutro>0.00</vOutro><vNF>35509.62</vNF></ICMSTot></total><transp><modFrete>0</modFrete><transporta><CPF>99446383900</CPF><xNome>LEANDRO JONAS MERGEN</xNome><xEnder>RUA DOM GERALDO SIGAUD</xEnder><xMun>MISSAL</xMun><UF>PR</UF></transporta><vol><qVol>1112</qVol><esp>SC</esp><marca>REAL H</marca><nVol>1112</nVol><pesoL>33210.000</pesoL><pesoB>33210.000</pesoB></vol></transp><pag><detPag><tPag>90</tPag><vPag>0.00</vPag></detPag></pag><infAdic><infAdFisco>TRANSFERENCIA DE MERCADORIAS</infAdFisco><infCpl>DADOS SIS: Nr.TRANSACAO:10173486 - TIPO:07 - DATA:03/08/2020 - OPERADOR:5137 - OBS SISTEMA:Contribuinte dispensado do ICMS nas operacoes de transferencia conforme Liminar no 1009499-18.2017.8.11.0000</infCpl></infAdic></infNFe><Signature xmlns="http://www.w3.org/2000/09/xmldsig#"><Si ... tionMethod Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n- ... tureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><Reference URI="#NFe51200800988303000750550100000175171101734866"><Transforms><Transform Algorithm="http://www.w3.org/2000/09/xmldsig#envel ... <Transform Algorithm="http://www.w3.org/TR/2001/REC-xml-c14n- ... gestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1" ... e><protNFe versao="4.00"><infProt><tpAmb>1</tpAmb><verAplic>MT_A2RL-4.00</verAplic><chNFe>51200800988303000750550100000175171101734866</chNFe><dhRecbto>2020-08-03T15:09:03-04:00</dhRecbto><nProt>151200044213951</nProt><digVal>HnQbOF4NEgGL7gGZCa3nuxzgFMU=</digVal><cStat>100</cStat><xMotivo>Autorizado o uso da NF-e</xMotivo></infProt></protNFe></nfeProc>

[AlbertoBraga]

Olá
A planilha anexa deve atender ou um caminho para a solução:
1- A planilha de importação anexa e todos os XML devem estar na mesma pasta
2- Na planilha de importação na aba "Lista_Arq_XML" relacione todos os arquivos a importar dados - Coluna A
3- Rode a macro
4- Os dados importados estarão na aba "Dados_Imp_Arq_XML"
Conferir e completar os os dados importados, base o cabeçalhos dos arquivos XML
É isso
Até

[AlbertoBraga]

Olá
Isto pode ajudar, copiei os arquivos XML do tópico e gravei no formato XML com o nome de 10203040.xml e 50607080.xml respectivamente, eles foram abertos temporariamente pelo comando do macro de importação, os dados escolhidos copiados, em seguida apagados.
Foram abertos como estão gravados na planilha anexa.
Considerei que todos os arquivos XML tem o mesmo formato, caso não seja, eles devem ser tratados especificamente
considerando as "tags" e/ou o numero das colunas dos dados a serem importados.
Até