There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
access audio avg avg 8 bios blue screen boot bsod computer connection cpu crash css dell desktop dma driver drivers dvd email error excel explorer firefox firefox 3 freeze gimp graphics hard drive hardware hijackthis hjt install internet internet explorer itunes keyboard laptop macro malware monitor motherboard network networking outlook outlook 2003 outlook 2007 outlook express pio problem problems router seo server slow sound sp3 spyware trojan usb video virtumonde virus vista vundo windows windows vista windows xp winxp wireless
Business Applications
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Software & Hardware > Business Applications >
Excel to XML File


HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free! Click here to join today! We highly recommend that you print a copy of our Guide for New Members. Enjoy!

 
Thread Tools
gamecockfan's Avatar
Computer Specs
Senior Member with 1,168 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
12-Jun-2008, 12:50 PM #1
Question Excel to XML File
Does anyone know how to convert an Excel file to a XML file?
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 6,342 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
12-Jun-2008, 01:17 PM #2
Anything wrong with the Save As version?
gamecockfan's Avatar
Computer Specs
Senior Member with 1,168 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
12-Jun-2008, 01:19 PM #3
I need the XML file in a certain format/schema. The 'Save As' does not allow me to do that format/schema.
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 6,342 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
12-Jun-2008, 01:49 PM #4
I am not sure that the VBA version allows that either.
Have you looked at the SaveAs in the VBA Editor Help?
it show XML as a FileFormat in the expression
expression.SaveAs(FileName, FileFormat, Password, WriteResPassword, ReadOnlyRecommended, CreateBackup, AccessMode, ConflictResolution, AddToMru, TextCodepage, TextVisualLayout, Local)
gamecockfan's Avatar
Computer Specs
Senior Member with 1,168 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
12-Jun-2008, 01:51 PM #5
No, I have not looked at that. Would it help if I attached a file with the format I need?
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 6,342 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
12-Jun-2008, 01:57 PM #6
Not for me as Excel is not my strong point and I have never used XML, you could post it and hope Zack, Bomb, Rollin or one of the other Excel regulars comes along.
jimr381's Avatar
Distinguished Member with 3,524 posts.
 
Join Date: Jul 2007
Location: 1313 Mockingbird Lane
Experience: 1 Child, so not much
12-Jun-2008, 02:00 PM #7
So you do not have an XSD file setup already? XSD are schema or structure files. Think of it as the shell of the database. XSL are the style of the output.
gamecockfan's Avatar
Computer Specs
Senior Member with 1,168 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
12-Jun-2008, 02:00 PM #8
Sounds good. Thanks for the suggestions.
gamecockfan's Avatar
Computer Specs
Senior Member with 1,168 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
12-Jun-2008, 02:00 PM #9
Yes, I do have a XSD file.
jimr381's Avatar
Distinguished Member with 3,524 posts.
 
Join Date: Jul 2007
Location: 1313 Mockingbird Lane
Experience: 1 Child, so not much
12-Jun-2008, 02:01 PM #10
Please check out the previous post.
jimr381's Avatar
Distinguished Member with 3,524 posts.
 
Join Date: Jul 2007
Location: 1313 Mockingbird Lane
Experience: 1 Child, so not much
12-Jun-2008, 02:02 PM #11
OK do you know how to attach the XSD file to the Excel file to get it it's structure to save as?
jimr381's Avatar
Distinguished Member with 3,524 posts.
 
Join Date: Jul 2007
Location: 1313 Mockingbird Lane
Experience: 1 Child, so not much
12-Jun-2008, 02:06 PM #12
OK check this out. Like most applications I know a little bit about it, slightly enough to be deadly with it. Go to "Data">>"XML">>"XML Source" from the menu bar. Click on the "XML" maps button and then click "Add." Switch the file type up to XSD files and it should load a map for you. Then basically you assign data from your spreadsheet to the map.
__________________
"Take what you learn and make a difference with it."
___________________________________________

"Oh, goody!"
___________________________________________
The magic number is: 28192 for Zukirin Shikimirika****eari
gamecockfan's Avatar
Computer Specs
Senior Member with 1,168 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
12-Jun-2008, 02:07 PM #13
Let me give it a go. Thanks.
gamecockfan's Avatar
Computer Specs
Senior Member with 1,168 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
12-Jun-2008, 02:08 PM #14
How do you assign the data to the map?
gamecockfan's Avatar
Computer Specs
Senior Member with 1,168 posts.
 
Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Always Learning!
12-Jun-2008, 02:10 PM #15
I believe I have figured out how to assign the data. Thank you all for the help and suggestions.
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are Off
Refbacks are Off

You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 05:25 PM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.