LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Accessing Excel from VB

the VB/Excel help files are all thats needed to expose the workbook/worksheet
objects that you need. Examples frequently have ADO alternatives although
they are treated as being 'clunky'. Of course if you actually mean VB and
not VBA as I have assumed then you may need to link differently to expose the
Excel objects.
Visual Basic for Aplications is the VB editor that comes with office tools.
Visual Basic is a seperate package that is not (by default) linked to the
Office objects.

In fact, (just thinking this through). goto the object browser in VB and
see if the Excel objects are available if not then link the appropriate
objects and away you go! Examples and help abundant in the standard help
files.

"Wayne Ware" wrote:

I am new to VB (experienced at VC & VC++) and am looking for a good,
complete example of how to access Excel spreadsheets directly from VB.
I have heard you can do it either through an ADODB connection or
through the Excel object library.

Can anyone provide complete examples of both for a novice that is
trying to learn quickly?

Thanks in advance.

Wayne Ware

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Accessing Excel pages using VB bob_mhc Excel Discussion (Misc queries) 1 July 16th 05 10:28 PM
Accessing Outlook from Excel Chaplain Doug Excel Discussion (Misc queries) 0 December 19th 04 11:39 PM
Accessing MS Project from Excel luvgreen Excel Programming 0 July 6th 04 09:00 PM
Accessing Word from Excel pikus Excel Programming 4 January 14th 04 07:41 PM
How to stop Excel from accessing the net [email protected] Excel Programming 1 December 29th 03 04:20 PM


All times are GMT +1. The time now is 05:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"