Connecting VB with Excel

[Monochron]

Originally Posted by logank013

In my computer programming class, we have been learning to program in Visual Basic. I'm not sure how much it is used in real life but I'm trying to connect a VB program to excel. I wrote the code based off of a video I found on youtube. I know very little about computer programming but you can only learn by failing and figuring it out. The road block I hit is not knowing what my Oledb provider is. How do I find my oledb provider? Thanks

Disclaimer: I'm not familiar with VB or Oledb.

First, are you hoping to actually "connect" your program to Excel? As in modify the Excel program and/or send messages to it? If so, just ignore this post.

If you are trying to import or create Excel files though I can reccomend the library EPPlus. It is a .net library that lets you create a "Spreadsheet" object in memory (or open a saved one), populate it fairly robustly, and save it to disk. There is alot a good deal of support for it online.

If that isn't what you were looking to do then, uh, sorry. Useless post