1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Need a Good VBA Resource

Discussion in 'General Programming Chat' started by Steezy, Apr 20, 2012.

  1. Steezy

    Steezy Newbie

    Joined:
    Mar 9, 2012
    Messages:
    16
    Likes Received:
    1
    I have a huge csv of data(product import list from a supplier) that I need to work some data magic on and I decided to tackle the problem with VBA in Excel, since doing it in any other way would be a pain in the ass and possibly take too long. I've never worked with VBA, but so far it seems pretty damn simple and I've been able to get the basics down in about half an hour.

    Anyone have a good resource site for VBA? I'm basically looking for a cheatsheet/reference site that has all the most essential or most common VBA functions/commands. Googled around for a bit, but nothing good came of it, I've just been Googling every command or function that I realize I need.
     
  2. stratzvyda

    stratzvyda Newbie

    Joined:
    Apr 27, 2012
    Messages:
    13
    Likes Received:
    2
    The dummies website has a decent cheat sheet for VBA. If you're familiar with another language though it's very easy to modify by just reading it in as a file as a CSV(comma separated value) file is just that, a bunch of a data delimited by commas, just read it in and parse the commas and when you're finished mutating it just push it back the same way.