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
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