Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is Excel VBA best for me?
I am a Unix systems programmer with 20 years of
experience writing programs in C (not C++). Now I am retired and searching for a programming environment primarily to write simulations for financial analysis. I expect to integrate the simulations into Excel spreadsheets. My question is: what are my alternatives, and what do you think I would be happiest with, based on my background? Excel VBA seems like an "obvious choice", based on those requirements. But I wonder: will I be happy with the performance and programming language? Also I wonder: do I want to use VB by itself? Is that even an option? Alternatively, is it easy to use C/C++ on Windows and import the data into Excel? I would welcome feedback from people ideally with experience with both Excel VBA and other programming environments, notably Unix/Linux and C/C++, who can offer some comparative data. Also, pointers to specific objective magazine articles on the subject would be helpful. TIA. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is Excel VBA best for me?
If you are mainly looking to add new worksheet functions to Excel and you
need high performance, you should consider using Excel's C API. It is a little daunting at first, but as you are at home with C/C++ the only issues will be the Excel interface. Memory management is also critically important. I have written a book on the subject and there are plenty of sources on the internet - just do a search on Excel XLL for example. It is an old interface and does not support adirect access to all of the Execl objects, methods, porperties and events that, say, VBA does, but it will be supported in the next release of Excel (version 12). Regards Steve Dalton " wrote in message ... I am a Unix systems programmer with 20 years of experience writing programs in C (not C++). Now I am retired and searching for a programming environment primarily to write simulations for financial analysis. I expect to integrate the simulations into Excel spreadsheets. My question is: what are my alternatives, and what do you think I would be happiest with, based on my background? Excel VBA seems like an "obvious choice", based on those requirements. But I wonder: will I be happy with the performance and programming language? Also I wonder: do I want to use VB by itself? Is that even an option? Alternatively, is it easy to use C/C++ on Windows and import the data into Excel? I would welcome feedback from people ideally with experience with both Excel VBA and other programming environments, notably Unix/Linux and C/C++, who can offer some comparative data. Also, pointers to specific objective magazine articles on the subject would be helpful. TIA. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is Excel VBA best for me?
You might also want to look at the .Net environment, MS are really pushing
that and as I understand VB.Net and C# should not be totally alien to you. In these environments, with Excel 2003 On, you should be able to do anything that you want with the Excel object model, so manipulating workbooks will not be a problem. -- HTH Bob Phillips (remove nothere from email address if mailing direct) " wrote in message ... I am a Unix systems programmer with 20 years of experience writing programs in C (not C++). Now I am retired and searching for a programming environment primarily to write simulations for financial analysis. I expect to integrate the simulations into Excel spreadsheets. My question is: what are my alternatives, and what do you think I would be happiest with, based on my background? Excel VBA seems like an "obvious choice", based on those requirements. But I wonder: will I be happy with the performance and programming language? Also I wonder: do I want to use VB by itself? Is that even an option? Alternatively, is it easy to use C/C++ on Windows and import the data into Excel? I would welcome feedback from people ideally with experience with both Excel VBA and other programming environments, notably Unix/Linux and C/C++, who can offer some comparative data. Also, pointers to specific objective magazine articles on the subject would be helpful. TIA. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is Excel VBA best for me?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|