Excel - Need help working with XML data from another data source.
Asked By Brian Beckers
08-Jan-10 01:06 PM
What I need to do:
I need to have people fill out a form and send me the data, then I need to
be able to open the data and print it in a readable format. (sounds simple
right?)
Problem:
I have to work with a "fill in the blank" PDF form created in Acrobat 8 Pro,
which e-mails me the data in XML format. When I try to open the file in
Excel, I get the message "The specified XML source does not refer to a
schema." I click the OK, and get something very un-readable.
I have tried the option to "Use the XML Source task pane", and successfully
created a nice looking printable form this way. However, I do not want to have
to re-create this everytime I open up one of these XML formatted files that
get sent to me.
Am I missing something here?
Is there a better way to do what I need to acomplish?
Can I setup some kind of XML map that I can use to read these files as I get
them?
I am starting to pull out my hair, and that is not good since there is not much
left...
Excel
(1)
Macro
(1)
Acrobat
(1)
MSXML
(1)
XML
(1)
Tim Williams replied to Brian Beckers
Can you record a macro while openeing on of the files ?
Does that then work on other files ?
You could program using the MSXML components nd get at the data that way if
all else fails.
Tim
Win7 VirtualStore Weirdness with Excel 2002 and earlier Excel I thought I'd share a weird experience I had today in case it saves installer for it - - which registers it as an add-in for all installed versions of Excel - - and tested it. Fine in Windows 2000 in all installed versions of Excel. Boot to Windows XP, fine there too. Boot to Windows 7. Fine in Excel 2010, 2007, and 2003. But Excel 2002 and 2000 were still loading the old version of the add-in. I uninstalled the add-in, made sure it was gone, and reinstalled it. Same problem in Excel 2002 and earlier; still works fine in Excel 2003 and later. I opened the VB editor in Excel 2003 and in Excel 2002
Pb de recalcul Excel Bonjour, J'ai un problème de recalcul de ma feuille excel. J'importe une colonne qui se retrouve en texte 0000 0000 0000 0000 FFF0 7FFF cela soit automatique ? Merci d'avance à ceux qui se pencheront sur mon cas. Caroual Excel - French Discussions WorksheetFunction (1) AddIns (1) Worksheets (1) Excel 2007 (1) Macro (1) Proc (1) LEFT (1) VBA (1) Bonsoir Dans la doc sur HEXBIN, ils ne 426a74cc@news.free.fr. . . Bonjour, J'ai un probl?me de recalcul de ma feuille excel. J'importe une colonne qui se retrouve en texte 0000 0000 0000 0000 FFF0 7FFF et un texte" Next ce que tu peux d = E9clencher = E0 l'aide d'une macro qui se charge de l'imp = ort = 20 avant, de fa = E7on que les deux micros. Je l'ai testée chez moi. Elle ne fonctionnait pas, j'ai coché la macro complémentaire Utilitaires d'analyses VBA. et elle a marché, à part le problème de recalcul
Removing Command Button Excel Hello all, I have a code that creates a command button when the Excel file opens. The following is the code that I use: Set nBar = CommandBars("Standard") nBar nCon = nBar.Controls.Add(Type: = msoControlButton, Temporary: = True) With nCon .BeginGroup = True .Style = msoButtonCaption .Caption = "Macro" .OnAction = "RunMacro" End With What I would like to do is to remove the above command button "Macro" when the Excel file closes. I have tried to use the following code, and it did not work Application.CommandBars("Standard").Controls("Macro").Delete Please help. Thanks. Excel Programming Discussions Office (1) Error (1) Excel (1) Worksheet (1) Workbook (1) Module (1) Macro (1) SaveChanges (1) Try identifying the control
32 bit DLL with 64 bit Excel 2010 Excel We have an app which creates large Excel workbooks. For example, one workbook has 1, 000 worksheets. In other cases there are fewer worksheets but the Excel file can be 80 MB or larger. Since this sometimes crashes Excel 2007 and 2003, I am considering using 64 bit Excel 2010. Would 64-bit Excel be more reliable with workbooks this size than 32-bit Excel? Is 32-bit Excel 2010 any more (or less) reliable with large workbooks than Excel
Contatore Excel Ciao, sto cercando di fare in modo che all'apertura di un file venga scritta che contenga le date di apertura. Qualcuno ha uno script gi = E0 fatto? tks Sandro Excel - Italian Discussions ThisWorkbook.Worksheets Foglio1 With sh (1) Nothing End Sub Modifica Foglio1 (1) Worksheets (1) Excel 2010 (1) Excel 2007 (1) Macro (1) Date (1) VBA (1) = 3D = 3D = 3D = 3D = 3D = 3D = 3D = 3D = 3D = 3D le cose *fatte bene*. Questo nel modulo di codice di ThisWorkbook (o Questa_Cartella_Di_Lavoro se utilizzi Excel 2010): Private Sub Workbook_Open() Dim sh As Worksheet Set sh = ThisWorkbook.Worksheets("Foglio1") With sh il nome del foglio, no? Altrimenti, 'ndo cojo cojo(che i romani mi scusino). Ed Excel 2007 e 2010 hanno oltre un milione di righe, non 65536. - -- -- -- -- -- -- -- -- -- -- -- -- -- Mauro Gamberini Microsoft MVP - Excel http: / / www.riolab.org / http: / / www.maurogsc.eu / On 21 Dic, 14:13, "Mauro Gamberini