Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

creating compiled addins with cell references

Status
Not open for further replies.

popper

Programmer
Dec 19, 2002
103
AU
Hi

I have VBA code behind an Excel spreadsheet that does database queries (mostly DAO but some ADO) and also places and pulls values from cell locations around an Excel spreadsheet.

The problem is that the program can run for minutes on end if the spreadsheet is large.

My question is:
Is it possible to compile VBA, produce something like a compiled XLA (addin) or a DLL perhaps and have it called from a macro initiated routine in the spreadsheet? Or do I have to have this written in C++ or some other language I do not know?

I would appreciate any help available.

With thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top