View Single Post
  #12   Spotlight this post!  
Unread 18-11-2015, 11:24
Monochron's Avatar
Monochron Monochron is offline
Engineering Mentor
AKA: Brian O'Sullivan
FRC #4561 (TerrorBytes)
Team Role: Engineer
 
Join Date: Feb 2007
Rookie Year: 2002
Location: Research Triangle Park, NC
Posts: 914
Monochron has a reputation beyond reputeMonochron has a reputation beyond reputeMonochron has a reputation beyond reputeMonochron has a reputation beyond reputeMonochron has a reputation beyond reputeMonochron has a reputation beyond reputeMonochron has a reputation beyond reputeMonochron has a reputation beyond reputeMonochron has a reputation beyond reputeMonochron has a reputation beyond reputeMonochron has a reputation beyond repute
Re: Connecting VB with Excel

Quote:
Originally Posted by logank013 View Post
Just out of curiousity, how different is the language from VB to VBA
I'm not too familiar with the specific differences, though I don't think they would be too large. I think in both these approaches you will have to use a data structure in your program to store all of your cells and data and whatnot. They you will have to save it to disk somewhere. Personally I think it would be easier to use the EPPlus library and work withing the VB framework that you already know. But, as I said, I'm not familiar with VBA so I don't know how different it is, or how create an Excel file works in it. You will have to use some googling to figure out which one looks best from your perspective.