xml excel

  1. 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...
  2. 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>...
  3. 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...
  4. 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...
  5. 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...
  6. 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 . :)...
  7. 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...
  8. 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...

Some videos you may like

This Week's Hot Topics