Foster Solutions (FSI)
The Solution is in the Process
As nice as Excel 2007 is, and much of Office 2007 in general, Microsoft made some annoying decisions with developer access in VBA. Charts are now Excel objects and their data are based on worksheets. This is pretty nice overall, but Microsoft does not allow access to the sheet data when pasted into Word or …
Automating complex Excel reports using corporate data (JP Morgan Chase).
Sometimes you want to list the column letters. You could just use the CHAR function, but when you get past Z and move on to AB and beyond, that system breaks down. Here is a function to use to return the column letter(s) to place in a module. In Excel 2007 it will automatically pop …