Tuesday, 22 November 2011

Why is it the simplest things...

... stop clearly good code from working?!

Whilst trying to write a VBA piece to export a chart from Excel as a PNG with a colleague today, we spent AGES trying to get a very simple section to work (specify the file name and open the 'Save As' dialogue). After what felt like an eternity we discovered that taking the .extension off from the file name string solved the problem! Now I thought that was pretty dumb, everyone else agree?!

No comments: