I have some script that I have copied from textpad and pasted into excel. I need to update the script incrementally where it says "samp1" below and I need to change the select statement in that script as well. I have all of the field names pasted in one column in sheet2 of my excel workbook and the script is pasted on sheet1. See example below:
samp1.sql=select * from "the first name in cell a1 on sheet2"
samp2.sql=select * from "the first name in cell a2 on sheet2"
samp3.sql=select * from "the first name in cell a3 on sheet2"
Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity)
There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel.
Part 1 of this series discussed basic error handling code using VBA.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…