nobb

I figure there is probably quite a few smart programmers on this forum, so I thought I would ask here.

So at my summer job, one of my duties is to create a VBA code that will read data from an Excel spreadsheet then export that to an XML document. Certain formatting such as borders and colors will have to be read then written in a certain way within the XML file. The purpose of the XML file is that the coding within the XML will be read by a proprietary program and converted into a spreadsheet that the program can recognize.

Now the problem is that I am a completely new at programming, so I basically have to learn everything from scratch. I have some basic experience making simple C++ programs, that's about it.

I'm just wondering if you guys might have some good advice, suggestions, examples, tips to help me get started with this project? Any bit would be of great help! I only have a few months left to do this...

Thanks guys.

MP3Car.com

 

almera

Here is an example code:
http://www.codeproject.com/KB/vbscript/xls2xml.aspx

__________________
----------------------------------------------------------------------

Bugbyte

I also recommend getting a book. I still use 'Excel Programming 2002 in VBA'. The actual code examples themselves are worth the price of the book.

Go down to Barnes and Nobles or whatever the local mega store is and buy one of these. If you have time, ask the company to buy you one you pick out on Amazon. If they won't buy it, consider it an investment in your education. If you pull this off, you'll get a nice letter of recommendation from them. Definitely worth the price of the book.

__________________
Want to:
-Find out about the iBug?
-Stop being a newbie? Take a look at the FAQ Emporium?
-Find out about carPC's in just 5 minutes? View the Car PC 101 video
-Help me kill my car PC
-Watch live video streams from my mobile PC? Check it out here.
-Where is the iBug?

nobb

I do have a book, but I think the tough part is having a certain task you want to perform, but not knowing where to look for a solution/function. There's so many functions, it's mind boggling. I was just hoping maybe there would be an easy internet resource somewhere to look everything up.

Crinos

It is... MSDN is a good place to start, and google is allways your best friend
Or find a forum dedicated to VBA.

HiJackZX1

What about Video Professor?

__________________
HiJack ZX1 CFSC
CAR PC ITEMS [35%]
INSTALL OF MULTI PC SYSTEM [35%]
BUG WORKOUT [0%]
INTERIOR MODS [45%]

HiJackZX1 Work Log
HiJackZX1 Website!

Please build up my REP.

MP3Car.com