Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Introduction to VB and Excel
Hi newsgroup
My boss gave me the following assignment. Please make an interface between GAMS and EXCEL. This interface should have a lot of functionality and be able to visualise data. What is the easiest way to accomplish this? I thought of using EXCEL and VB to make an application that had the feel of being a standalone program and use components/objects from EXCEL. My question to you is: What book should i buy for reference/introduction ? ;-) Thank's in advance Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Introduction to VB and Excel
On Tue, 3 Feb 2004 10:27:24 +0100, "Mark" wrote:
My boss gave me the following assignment. Please make an interface between GAMS and EXCEL. This interface should have a lot of functionality and be able to visualise data. Your boss is a real precise kinda person. Although I suppose s/he could have just said "Gimmie something and make it do stuff"... 8^ What is the easiest way to accomplish this? I thought of using EXCEL and VB to make an application that had the feel of being a standalone program and use components/objects from EXCEL. I'm not sure what GAMS is, but if it supports ODBC links then it shouldn't be TOO hard (for certain values of "too") to use Excel as an interface to it. Hey, if I could manage that with Oracle Financials, then... My question to you is: What book should i buy for reference/introduction ? ;-) This isn't a bad one if its predecessors are any guide. (Sorry John, I haven't seen the current edition yet): http://j-walk.com/ss/books/xlbook25.htm Don't be put off by the title if you're just starting with VBA; you'll find that it gives you a good amount of groundwork as well. --------------------------------------------------------- Hank Scorpio scorpionet who hates spam is at iprimus.com.au (You know what to do.) * Please keep all replies in this Newsgroup. Thanks! * |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Introduction to VB and Excel
Mark,
Unless you are a more than reasonably experienced programmer, with a good understanding of object models and Excel (if not VBA), and depending upon the timescales, then I would suggest that this is a poisoned assignment. To learn VBA, Excel, Excel object model, inter-program communication, et al, is not a trivial task, and will take months to develop to any sensible level of competency as the limited spec you give suggests is required. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Mark" wrote in message ... Hi newsgroup My boss gave me the following assignment. Please make an interface between GAMS and EXCEL. This interface should have a lot of functionality and be able to visualise data. What is the easiest way to accomplish this? I thought of using EXCEL and VB to make an application that had the feel of being a standalone program and use components/objects from EXCEL. My question to you is: What book should i buy for reference/introduction ? ;-) Thank's in advance Mark |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Introduction to VB and Excel
"Hank Scorpio" wrote in message ... On Tue, 3 Feb 2004 10:27:24 +0100, "Mark" wrote: My boss gave me the following assignment. Please make an interface between GAMS and EXCEL. This interface should have a lot of functionality and be able to visualise data. Your boss is a real precise kinda person. Although I suppose s/he could have just said "Gimmie something and make it do stuff"... 8^ What is the easiest way to accomplish this? I thought of using EXCEL and VB to make an application that had the feel of being a standalone program and use components/objects from EXCEL. I'm not sure what GAMS is, but if it supports ODBC links then it shouldn't be TOO hard (for certain values of "too") to use Excel as an interface to it. Hey, if I could manage that with Oracle Financials, then... My question to you is: What book should i buy for reference/introduction ? ;-) This isn't a bad one if its predecessors are any guide. (Sorry John, I haven't seen the current edition yet): http://j-walk.com/ss/books/xlbook25.htm Don't be put off by the title if you're just starting with VBA; you'll find that it gives you a good amount of groundwork as well. --------------------------------------------------------- Hank Scorpio scorpionet who hates spam is at iprimus.com.au (You know what to do.) * Please keep all replies in this Newsgroup. Thanks! * Thanks a lot! Regards Mark |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Introduction to VB and Excel
"Bob Phillips" wrote in message ... Mark, Unless you are a more than reasonably experienced programmer, with a good understanding of object models and Excel (if not VBA), and depending upon the timescales, then I would suggest that this is a poisoned assignment. To learn VBA, Excel, Excel object model, inter-program communication, et al, is not a trivial task, and will take months to develop to any sensible level of competency as the limited spec you give suggests is required. -- HTH Bob Phillips Thanks for the comments! You are absolutely right. Fortunately I have a solid background in C/C++, java etc. On top of this I have some user experiance with EXCEL. Finally the only interfacing with GAMS is through flat files. Still, i do not intend to underestimate the size of this assignment. Regards MArk |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Introduction to VB and Excel
"Mark" wrote in message ... Hi newsgroup My boss gave me the following assignment. Please make an interface between GAMS and EXCEL. This interface should have a lot of functionality and be able to visualise data. What is the easiest way to accomplish this? I thought of using EXCEL and VB to make an application that had the feel of being a standalone program and use components/objects from EXCEL. My question to you is: What book should i buy for reference/introduction ? ;-) You may want to examine the possibility of using the Excel Spreadsheet component in the .Net environment http://msdn.microsoft.com/library/de...Components.asp http://msdn.microsoft.com/library/de...eetcontrol.asp http://vbnetadvisor.com/doc/13323 http://www.microsoft.com/office/prev...rm/webcomp.asp Alternatively some useful URLS for the VB/VBA route are http://support.microsoft.com/default...NoWebContent=1 http://www.codeproject.com/com/excelfeed.asp http://www.cpearson.com/excel/resources.htm http://support.microsoft.com/default...h;EN-US;xl2003 Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i remove an introduction notice on excel 2003? | Excel Discussion (Misc queries) | |||
fill columns by introduction of data | Excel Worksheet Functions | |||
describe introduction to spreadsheets | New Users to Excel | |||
Introduction | New Users to Excel | |||
Introduction to excel programmin | Excel Programming |