Results 1 to 6 of 6

Thread: Need to learn Excel VBA ASAP! Suggestions, tips, advice, examples...

  1. #1
    FLAC
    Join Date
    Jun 2006
    Location
    Calgary, Alberta
    Posts
    1,237
    Blog Entries
    1

    Need to learn Excel VBA ASAP! Suggestions, tips, advice, examples...

    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.

  2. #2
    Constant Bitrate almera's Avatar
    Join Date
    Aug 2004
    Posts
    195
    ----------------------------------------------------------------------

  3. #3
    Admin. Linux loser.
    Auto Apps:loading...
    Bugbyte's Avatar
    Join Date
    Sep 2004
    Location
    Corning, NY
    Posts
    7,364
    Blog Entries
    2
    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.
    Quote Originally Posted by ghettocruzer View Post
    I was gung ho on building a PC [until] just recently. However, between my new phone having internet and GPS and all...and this kit...Im starting to have trouble justfiying it haha.
    Want to:
    -Find out about the new iBug iPad install?
    -Find out about carPC's in just 5 minutes? View the Car PC 101 video

  4. #4
    FLAC
    Join Date
    Jun 2006
    Location
    Calgary, Alberta
    Posts
    1,237
    Blog Entries
    1
    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.

  5. #5
    Maximum Bitrate Crinos's Avatar
    Join Date
    Mar 2009
    Location
    Kristiansand, Norway
    Posts
    489
    Quote Originally Posted by nobb View Post
    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.

  6. #6
    Who am I? HiJackZX1's Avatar
    Join Date
    Jul 2007
    Location
    Miami
    Posts
    6,603
    What about Video Professor?
    Nirwana Project, the Android/Win 7 hybrid system!

    1X Ainol Novo Flame Tab
    4X MK808b
    3x Perixx Touchpads
    3x 7 inch Screens
    1X 7 inch motorized Screen
    1x Win 7 PC

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •