View Single Post
  #9   Spotlight this post!  
Unread 17-11-2015, 07:57
techhelpbb's Avatar
techhelpbb techhelpbb is offline
Registered User
FRC #0011 (MORT - Team 11)
Team Role: Mentor
 
Join Date: Nov 2010
Rookie Year: 1997
Location: New Jersey
Posts: 1,624
techhelpbb has a reputation beyond reputetechhelpbb has a reputation beyond reputetechhelpbb has a reputation beyond reputetechhelpbb has a reputation beyond reputetechhelpbb has a reputation beyond reputetechhelpbb has a reputation beyond reputetechhelpbb has a reputation beyond reputetechhelpbb has a reputation beyond reputetechhelpbb has a reputation beyond reputetechhelpbb has a reputation beyond reputetechhelpbb has a reputation beyond repute
Re: Connecting VB with Excel

There's a pretty good example of OLE from an older page at Microsoft:

https://support.microsoft.com/en-us/kb/242243

With VB.NET (VisualBASIC Express) you should probably try this which basically wraps the OLE functionality with ADO:

https://msdn.microsoft.com/en-us/library/ms971514.aspx

The long and (maybe not so) fascinating backstory of ODBC->OLE->ADO:

https://msdn.microsoft.com/en-us/library/ms810287.aspx

.........

BASIC was the language I learned 3rd after assembly language and Forth.
If you really like BASIC I recommend looking at some of these:

PureBASIC's extensive library - $100 and upgrades for life

Write PureBASIC get JavaScript for web applications

Write BASIC get JAVA for mobile devices

DarkBASIC is oriented towards game design work

A very QuickBASIC (TM) like language for console applications
QuickBASIC was the predecessor of VisualBASIC for DOS and VisualBASIC for Windows.

A BASICStamp(TM) like language targeting Microchip PIC microcontrollers

A BASIC language targeting AVR microcontrollers

Yet another BASIC language targeting 8015, ARM, AVR, FT90x & PIC microcontrollers

What the heck is the FT90x you ask:
FT90x

There are many others. These are just a few I own and use from time to time.

Last edited by techhelpbb : 17-11-2015 at 15:39.