Thread: Connecting VB with Excel
View Single Post
  #7   Spotlight this post!  
Unread 16-11-2015, 23:23
DaveL DaveL is offline
Registered User
FRC #2976
  
Join Date: Jan 2013
Location: WA
Posts: 174
DaveL is a jewel in the roughDaveL is a jewel in the roughDaveL is a jewel in the roughDaveL is a jewel in the rough
Re: Connecting VB with Excel
In my experience, exporting small data sets to an excel file is frequently done to allow end users to quickly view, sort and display their data.

As data becomes easier to collect and cheaper to store, new ways will be found to help end users organize and display data. Tableau, a FIRST sponsor is one of the companies leading this data display evolution. They have a program that does this and they offer free licenses in the KoP. Many teams find it helpful for organizing scouting data.

You can also use Excel to accept user input and store the data in a VB file. This was more critical in early 2000 when HTML form tools were limited and there was more paper to digital interactions. More frequently forms are created in HTML with JavaScript entry validation and then sent to a server for storage.