xml excel

  1. D

    XML Source RTF file in Excel to Text

    I am designing an Excel Report that will generate a scope of work for that project. Currently using XML Sources to bring in the data to Excel but the Scope of work is an RTF file only generates the file name. I am trying to code a macro that will take an XML Source that is an RTF file and...
  2. S

    Importing XML to Excel - number of characters

    when I am importing XML into excel, does it import all the characters on the XML file? Or does it only import a limited number (ex:255)?
    • smak
    • Thread
    • import xml number of characters xml excel
    • Replies: 1
    • Forum: Excel Questions
  3. A

    Excel custom ribbon disappears when running macro

    I have a custom ribbon in Excel with macros assigned to it. One set of macros does just sheet/column formatting, sort data etc. Normal Excel stuff. Those all works. Then I have two specific macros that removes the custom ribbon completely when they execute. Well, after the executed the Custom...
    • avcape
    • Thread
    • custom ribbon customui ribbon vba xml excel
    • Replies: 0
    • Forum: Excel Questions
  4. M

    Edit XMLs in Excel

    I have 82 XML files each named with a 3- or 4-letter code; each XML contains a field (or tag? I'm new to XML) called OBJECTIVE followed by text and a field called STRATEGY followed by text. ex) ABC.xml contains CODE ="ABC" OBJECTIVE [The objective is to win.] /OBJECTIVE INVESTMENTSTRATEGY...
  5. B

    New to APIs Question

    I've been searching the boards, but still can't seem to find an answer to why this doesn't work. The authentication works, but when I then try to query the part number I get - "<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Draft//EN"><HTML> <HEAD> <TITLE>Error 500--Internal Server Error</TITLE>...
  6. M

    Importing XML Data from Web - Trouble Automating URL Paste

    Hello, Mr. Excel! Working in Excel 2010... I'm building a template that automates XML data import from the internet. First step: Users will enter in a code specific to each project. This code combines via the &" "trick" to an address that is constant for all programs. For example, if "123" is...
    • mbeyer
    • Thread
    • importing data from web paste url copy xml excel
    • Replies: 0
    • Forum: Excel Questions
  7. R

    Excel/VBA Question

    I'm not sure if this is even possible, or if VBA is the appropriate way to go about solving this, but any insights would be appreciated. I have data in a spreadsheet with enrollment ids, names etc. I am currently copying the enrollment id from the cell, inserting into this URL...
  8. J

    Activate windows of files stored in arrays, but getting subscript out of range error??

    I'm trying to write a copy and paste program that lets the user select which xml files to merge and then in sequence opens up the xml file selected second and paste it into the first selected file (top file in final completed file), opens the xml file selected third and paste it into the xml...
    • Jerryh91
    • Thread
    • array copy & paste vba subscript out of range type mismatch xml excel
    • Replies: 2
    • Forum: Excel Questions
  9. A

    map xml node from parent node

    Hi, I'm trying to write a macro to map the xml folder elements on different worksheets, But the problem is i have to map individual columns against the xml schema elements, I need a macro that could check the worksheet name and map the particular node to that sheet at one go... please help . :)...
  10. B

    Add XMLNS attribute to an xml file

    Hi!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I need to build a macro that creates a xml file, having information taken from the excel file and from a database. The fact is that i have an example that shows me how the final file should...
  11. P

    Excel editing as an XML

    Dear all, I have an Excel which was generated from a PL SQL procedure as an XML spread sheet. Now I want to add an IMAGE to that Excel which is actually an XML spread sheet. I can add manually an image to that excel and can save it as .xls, .xlsx or binary form. But please let me know how can I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top