Archive for Monday, June 30th, 2008
Get Open or Save-As Filename
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
GetOpenFilename and GetSaveAsFilename are useful dialogs to use within Excel VBA procedures when your procedure needs to know the filename of a file to open or save. I have encapsulated each into functions that add to their functionality, and make then simpler to use in my procedures.
Note that both GetXxxxFilename functions return file names. They [...]
Posted: Monday, June 30th, 2008 under VBA.
Comments: 1
What Goes into the Price of Gas?
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
In Data Visualizations Related to Gas Prices, Tony Rose of Support Analytics Consulting shows a series of visualizations he’s culled from the web, all related to gasoline prices. One infographic stuck out, partly for its overuse of chart junk, and partly for Tony’s interpretation. Here is the original chart, which Tony took from www.thebiblog.com, followed [...]
Posted: Monday, June 30th, 2008 under Charting Principles.
Comments: 7


