LinkBack URL
About LinkBacks
Reply With QuoteHere is an example code:
http://www.codeproject.com/KB/vbscript/xls2xml.aspx
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.
Here is an example code:
http://www.codeproject.com/KB/vbscript/xls2xml.aspx
----------------------------------------------------------------------
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:Originally Posted by ghettocruzer
-Find out about the new iBug iPad install?
-Find out about carPC's in just 5 minutes? View the Car PC 101 video
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.
It is... MSDN is a good place to start, and google is allways your best friend
Or find a forum dedicated to VBA.
What about Video Professor?
HiJackZX1 w/ The Tobiathin Core PC system!
ZOTAC GF9300-G-E
INTEL E8200
4 Gigs
OCZ Vertex 2 SSD
OPUS 320
1 Lilliput, 1 MTSVO-SC K301, 4 VM70 screens, 1 Eonon 19in
Starting Raspberry Pi multizone project.
Posting Permissions
Bookmarks