-
Apr 17th, 2007, 11:19 AM
#1
Thread Starter
Lively Member
Advantages & Disadvantages of MS Excel? [URGENT]
There have been a few Spreadsheet programs written in VB, such as this one, but before there needs to be another, can someone tell me, in their own opinion, what they think are some advantages and disadvantages to Microsoft Excel, any version i dont mind.
Thanx.
Last edited by AceOfSpades; Apr 17th, 2007 at 11:43 AM.
-
Apr 17th, 2007, 12:07 PM
#2
Re: Advantages & Disadvantages of MS Excel? [URGENT]
Question rather belongs to a General dev forum...
Anyway, I'd say the advantages are:
- Microsoft Excel is widely used so there is huge users community
- exposes fully programmable object model
- easy to automate
- patches/bug fixes are free
- excellent reputation
- etc, etc, etc...
edit:
another advantage - MS Excel is an excellent reporting tool
Last edited by RhinoBull; Apr 17th, 2007 at 12:19 PM.
-
Apr 17th, 2007, 12:11 PM
#3
Thread Starter
Lively Member
Re: Advantages & Disadvantages of MS Excel? [URGENT]
Thanx man, anyone else...i need as many Advantages and Disadvantages as possible.
Thanx.
-
Apr 17th, 2007, 12:23 PM
#4
Lively Member
Re: Advantages & Disadvantages of MS Excel? [URGENT]
Disadvantage...
Can't export directly to PDF.
Advantage...
Easy to synchronize with PDA/Pocket Excel.
-
Apr 17th, 2007, 12:35 PM
#5
Re: Advantages & Disadvantages of MS Excel? [URGENT]
Originally Posted by Arty2000
Disadvantage...
Can't export directly to PDF...
Well, if PDF converter is installed then you would "print" directly to that "printer".
But I agree - it could nice to have one of "Save As" parameters of pdf type.
-
Apr 17th, 2007, 12:37 PM
#6
Re: Advantages & Disadvantages of MS Excel? [URGENT]
-
Apr 17th, 2007, 12:57 PM
#7
Re: Advantages & Disadvantages of MS Excel? [URGENT]
Although I personally like EXCEL very much I'm going to stretch a bit and tell you what I feel are it's disadvantages. So RB - you don't need to debate with me about what I'm saying
I find it very frustrating to deal with printing a spreadsheet that is too wide for the paper - granted it can be done but not in a very intuitive way. Setting PRINT AREA's and FIT TO PAPER are not easily accessible.
I find that although it's very liberal in how it deals with datatypes of columns - it can truly make a mess of data.
Cutting, pasting, inserting and removing rows or columns could be stronger in the way that formula's might be stretched to include these new rows or columns. I find that it's painful now if you need to perform tasks like this in a complex spreadsheet.
It is such a huge and complex product - has so much functionality - that to become an expert in it's use is nearly a full time job. That's both an advantage and disadvantage.
-
Apr 17th, 2007, 02:43 PM
#8
Re: Advantages & Disadvantages of MS Excel? [URGENT]
If you are looking to write your own then you can throw in features that you want but will lack the functionality of all that Excel has to offer.
Why not just write an Excel AddIn so you can tweak Excel the way you want and yet retain all the functionality of Excel and yet have your features "built in".
VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum.
Microsoft MVP 2006-2011
Office Development FAQ (C#, VB.NET, VB 6, VBA)
Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
If a post has helped you then Please Rate it!
• Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|