Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the 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
Showing results 1 to 25 of 25
Search took 0.01 seconds.
Search: Posts Made By: james gold
Forum: Excel VBA October 2nd, 2003, 10:03 AM
Replies: 0
Views: 1,962
Posted By james gold
Can an ActiveX DLL reference a spreadsheet?

Hi,

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...
Forum: Pro VB 6 October 2nd, 2003, 10:02 AM
Replies: 0
Views: 1,841
Posted By james gold
Can a VB6 ActiveX DLL reference a spreadsheet?

Hi,

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...
Forum: Beginning VB 6 September 18th, 2003, 10:26 AM
Replies: 3
Views: 2,111
Posted By james gold
Yehuda, I am quite sure it's possible to...

Yehuda,

I am quite sure it's possible to program VB6 in a non-object-oriented way!

What I am after is the basics of syntax and structure for creating classes/properties etc.

James
Forum: VB How-To September 18th, 2003, 07:00 AM
Replies: 2
Views: 8,161
Posted By james gold
Object oriented programming with VB6

Hi,

I am using VB6, and want to find some good web site tutorials/tips on object oriented programming with VB6 (not VB.NET).

I am having trouble tracking any down.

Alternatively can you...
Forum: Pro VB 6 September 18th, 2003, 06:59 AM
Replies: 3
Views: 2,714
Posted By james gold
Object oriented programming with VB6

Hi,

I am using VB6, and want to find some good web site tutorials/tips on object oriented programming with VB6 (not VB.NET).

I am having trouble tracking any down.

Alternatively can you...
Forum: Beginning VB 6 September 18th, 2003, 06:59 AM
Replies: 3
Views: 2,111
Posted By james gold
Object oriented programming with VB6

Hi,

I am using VB6, and want to find some good web site tutorials/tips on object oriented programming with VB6 (not VB.NET).

I am having trouble tracking any down.

Alternatively can you...
Forum: Pro VB 6 September 10th, 2003, 11:03 AM
Replies: 6
Views: 1,951
Posted By james gold
Great. Thanks, Owain. Do you know is there...

Great. Thanks, Owain.

Do you know is there is a utility that would automate that process for them?

If so, where do I get it? Or, do I need to write it? If so, how? (!)

Thanks.

James
Forum: Pro VB 6 September 10th, 2003, 10:57 AM
Replies: 6
Views: 1,951
Posted By james gold
Distribution of ActiveX DLL

Hi,

I am writing an ActiveX DLL to be used from with a spreadsheet.

I want to distribute the DLL to customers (along with the spreadsheet) so that when they open the spreadsheet, it references...
Forum: Excel VBA September 10th, 2003, 10:41 AM
Replies: 1
Views: 1,703
Posted By james gold
Sorry, my mistake - this is trivial. From...

Sorry, my mistake - this is trivial.

From the VB Editor, select Tools -> References.
Forum: Excel VBA September 10th, 2003, 10:14 AM
Replies: 1
Views: 1,703
Posted By james gold
Referencing an ActiveX DLL from Excel

Hi,

I have written an ActiveX DLL with VB6, and now I want to reference it from an Excel 2002 spreadsheet, so that the procedures it contains can be called from the spreadsheet.

Please can you...
Forum: Pro VB 6 September 10th, 2003, 08:19 AM
Replies: 2
Views: 7,243
Posted By james gold
owain, Well, what can I say? A fantastic,...

owain,

Well, what can I say? A fantastic, straightforward answer that has solved it for me.

THANKS!!!

I was expecting a nasty afternoon of hacking around in the registry - I am so glad it is...
Forum: VB Components September 10th, 2003, 07:34 AM
Replies: 2
Views: 13,736
Posted By james gold
Creation of ActiveX DLL with VB6

Hi,

I am creating an ActiveX DLL in VB6.

The DLL itself is a simple function - nothing wrong with it.

When I compile the DLL, it seems like the DLL is created, but I get an error message...
Forum: Pro VB 6 September 10th, 2003, 07:32 AM
Replies: 2
Views: 7,243
Posted By james gold
Creation of ActiveX DLL with VB6

Hi,

I am creating an ActiveX DLL in VB6.

The DLL itself is a simple function - nothing wrong with it.

When I compile the DLL, it seems like the DLL is created, but I get an error message...
Forum: Pro VB.NET 2002/2003 September 8th, 2003, 10:32 AM
Replies: 4
Views: 9,172
Posted By james gold
Thanks, Peter. Am I right in thinking that...

Thanks, Peter.

Am I right in thinking that Excel 2002 is a COM-based application? i.e. to write a bespoke class for it (outside of VBA) I must write a COM object (DLL)?

Or... am I making things...
Forum: VB Components September 8th, 2003, 09:44 AM
Replies: 0
Views: 1,840
Posted By james gold
Can you write an ActiveX DLL with VB.NET?

Hi,

I need to write an ActiveX DLL for use in an Excel spreadsheet.

Question:

Can I write an ActiveX DLL using "Visual Basic .NET Standard Edition"?

I am new to .NET so am not sure if the...
Forum: VB.NET September 8th, 2003, 09:42 AM
Replies: 1
Views: 1,448
Posted By james gold
Can you write an ActiveX DLL with VB.NET?

Hi,

I need to write an ActiveX DLL for use in an Excel spreadsheet.

Question:

Can I write an ActiveX DLL using "Visual Basic .NET Standard Edition"?

I am new to .NET so am not sure if the...
Forum: Pro VB.NET 2002/2003 September 8th, 2003, 09:39 AM
Replies: 4
Views: 9,172
Posted By james gold
Can you write an ActiveX DLL with VB.NET?

Hi,

I need to write an ActiveX DLL for use in an Excel spreadsheet.

Question:

Can I write an ActiveX DLL using "Visual Basic .NET Standard Edition"?

I am new to .NET so am not sure if the...
Forum: Excel VBA September 5th, 2003, 09:24 AM
Replies: 12
Views: 9,583
Posted By james gold
Seems like you can... In VB.NET, an ActiveX DLL...

Seems like you can... In VB.NET, an ActiveX DLL is now refered to as a Class Library.

More info at:
...
Forum: Excel VBA September 5th, 2003, 06:52 AM
Replies: 12
Views: 9,583
Posted By james gold
Thanks Phil. That's fine. One further...

Thanks Phil.

That's fine.

One further queation: I am going to write the ActiveX DLL with Visual Basic. Do you know if the Visual Basic .NET Standard Edition enables me to do this? (Obviously,...
Forum: VB.NET 2002/2003 Basics September 5th, 2003, 05:25 AM
Replies: 0
Views: 1,308
Posted By james gold
Can you write an ActiveX DLL with VB.NET?

Hi,

I need to write an ActiveX DLL for use in an Excel spreadsheet.

Question:

Can I write an ActiveX DLL using "Visual Basic .NET Standard Edition"?

I am new to .NET so am not sure if the...
Forum: Beginning VB 6 September 5th, 2003, 04:14 AM
Replies: 3
Views: 1,346
Posted By james gold
Speed of VB for number-crunching

Hi,

I am considering writing an ActiveX DLL with Visual Basic.

The DLL will perform about 5 million numeric calculations (mostly simple summations) using a small set of input data.

My...
Forum: Excel VBA September 4th, 2003, 11:33 AM
Replies: 12
Views: 9,583
Posted By james gold
Thanks, Phil. I assume you mean that a user...

Thanks, Phil.

I assume you mean that a user has to install the AciveX object on their PC, which means they can then call the class methods from a few lines of VBA code within the spreadsheet. Is...
Forum: Excel VBA September 4th, 2003, 10:06 AM
Replies: 12
Views: 9,583
Posted By james gold
Thanks. Yes - I suspect that an add-in may...

Thanks.

Yes - I suspect that an add-in may not be secure for us and that we really need to write a compiled product.

You mention ActiveX objects - please can someone advise how I go about...
Forum: Excel VBA September 4th, 2003, 09:36 AM
Replies: 12
Views: 9,583
Posted By james gold
OK - thanks. I can see (from some more...

OK - thanks.

I can see (from some more reading) that I can write as "add-in" and password protect it.

Next question: How secure is the protection? Are there ways of hacking around the...
Forum: Excel VBA September 4th, 2003, 08:58 AM
Replies: 12
Views: 9,583
Posted By james gold
How to hide VBA code

Hi,

I need to create a spreadsheet that contains a set of special functions for manipulating data. Obviously this can be done with VBA. However, it is vital that users of the spreadsheet are...
Showing results 1 to 25 of 25

 


All times are GMT -4. The time now is 11:46 PM.


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