Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Pro VB 6
Password Reminder
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Pro VB 6 For advanced Visual Basic coders working in version 6 (not .NET). Beginning-level questions will be redirected to other forums, including Beginning VB 6.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Closed Thread
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old October 2nd, 2003, 10:02 AM
Authorized User
Join Date: Sep 2003
Location: , , .
Posts: 25
Thanks: 0
Thanked 1 Time in 1 Post
Default Can a VB6 ActiveX DLL reference a spreadsheet?


I am writing an ActiveX DLL with VB6, which is referenced by my Excel spreadsheet. i.e. my DLL has functions which I call from the VBA in the spreadsheet.

I am passing cell data from the spreadsheet as parameters when I call the DLL functions from the VBA. The DLL then manipulates that data and sends back the results to the spreadsheet VBA. The VBA then plugs the results into the appropriate cells.

This is the first time I have done this, and have a related question.

Instead of passing the cell data to the DLL functions, is there a way that a DLL function can "look at" the spreadsheet and get the cell data for itself? This would involve (I guess) the DLL function being able to reference the spreadsheet (workbook) in some way.

Is this possible? If so, how do I do it? Or is it a stupid question?

Hope you can help - all info is useful as I am new to this.

Many thanks.


Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing toolbar from ActiveX DLL in VB6 maxpotters Excel VBA 1 September 11th, 2005 08:04 AM
Referencing a spreadsheet from an ActiveX DLL James Diamond Excel VBA 2 January 23rd, 2004 07:21 AM
Creation of ActiveX DLL with VB6 james gold VB Components 2 December 28th, 2003 04:02 PM
Can an ActiveX DLL reference a spreadsheet? james gold Excel VBA 0 October 2nd, 2003 10:03 AM
Creation of ActiveX DLL with VB6 james gold Pro VB 6 2 September 10th, 2003 08:19 AM

All times are GMT -4. The time now is 01:43 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.