suggestions for project with lots of code

geek4h

New Member
Joined
Feb 13, 2005
Messages
1
I would like some suggestions.
* This is an internal application in which the data files are small
* But the VB code portion is relative large
* Users will be emailing the data around and I don't want to have 5M files when I can get by with 50K files
* Suggestions on the best way to seperate the code from the data

For example: But all the code in an add-in, DLL, or COM? What would be best one do work with?
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

zilpher

Active Member
Joined
Mar 27, 2003
Messages
442
I'd be intrigued to know how you differentiate DLL and COM in this respect.

At the sake of security, an addin is the simplest way to achieve what you are looking to do. It is no more or less secure than having the code in your workbook but is easier to manage because you maintain one version of the code, if you need to change it you simply release a new version to everyone and don't have to worry about there being any workbooks that need the new code applied.

If you want better security, an ActiveX dll written in Office Developer or VS is an option. This is of course a COM object and as such is 'compiled' and inherently more secure.

The other option is a database application, assuming Excel is just acting as a data repository, removing the need for your users to email workbooks to each other.

You could do it either with some client software written in a language of your choice, or a browser based application. You'd be looking at a combination of:

Client/Server:
VB/C++/Your Choice
MySQL/MSDE/SQLServer/Oracle/you name it

Browser Based:
SQLServer/IIS/ASP (.net if you fancy it)
MSDE/IIS/ASP (.net if you fancy it)
MySQL/Apache/PHP
Probably a myriad of others....

My personal preference would be MySQL/Apache/PHP for several reasons:

Centralised code, no distribution problem
OpenSource/low cost
Cross platform Support (run it on a windows or *nix host)

HTH
 

Watch MrExcel Video

Forum statistics

Threads
1,122,190
Messages
5,594,761
Members
413,931
Latest member
acrato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top