The excel tag has no wiki summary.
0
votes
0answers
15 views
importing multiple images using VB macros in excel [migrated]
Firstly, i'm a design student and not a programmer, so am turning to forums such as this for help. As part of a project, I'm creating a prototype interface using excel. The excel document accepts ...
5
votes
1answer
140 views
Need advice for approach for a web-based app that loads excel worksheet but exposes only the charts
I'm looking for suggestions on the Visual Studio approach to take for a web application that is in the conceptual stage.
My environment has a lot of tools:
Windows Server 2008 R2 Standard 64bit
...
1
vote
2answers
60 views
Security Concerns with password storage in Scripting Languages (VBA)
The team I work with handles large amounts of consumer survey, and internal company metric data. Primarily the data is stored in a database, and we utilize various platforms and to work with that ...
8
votes
6answers
396 views
Software solution from the 2000's, should I attempt to patch or remake the whole thing?
I was sent out to discuss a system that a certain company is currently using and what should be done with it.
The company manufactures various carton displays. This system was developed to keep track ...
1
vote
4answers
247 views
How do I refer to the smallest possible non-zero value?
Back in my C programming days I thought there was a constant or function (I can't remember what it was called, let's call it SMALL) whose value was the smallest possible positive value. (Imagine the ...
5
votes
2answers
236 views
Alternatives to Project Euler for improving Excel ability
I've recently been enjoying using the mathematical problems listed at Project Euler to learn Python. My Excel ability is better than my Python, but I think I'd still benefit from the sort of inductive ...
2
votes
4answers
251 views
Questions over Excel programming
I have always heard about powerfull programming capabilities on Microsoft Excel (not VBA, Excel itself with all its formulas), but have never seen it.
Does it really got all that power on formulas ...
2
votes
1answer
101 views
How can I migrate from Excel VBA with ADO to C++ with OCCI?
I am employed as a developer, but the only application development tools I have available to me are Access and Excel (i.e., VBA). Fortunately, I have good access to our Oracle DB, but that took some ...
-1
votes
2answers
223 views
How to explain that full automation of a spreadsheets data sources isn't a good idea?
Have an Excel spreadsheet that summarizes various key metrics for the business. The source data for these metrics comes from various sources including other spreadsheets, and web/ERP systems.
A ...
3
votes
17answers
1k views
What is spreadsheet useful for?
I have been in computer business for 15 years in various roles (sysadmin, developer, researcher), and I have never encountered someone using excel for something more advanced than for formatting ...
