>I need to automate an excel spreadsheet from VFP9, basically the program will open up the spreadshet and fill in some information. I know it's simple with earlier versions of excel, how about with 2010? it uses the xlsx extension.
>
>Thanks!
My old macros for Excel 2003 work in Excel 2010. The potential problems are the other way; that is, if you use new features in Excel 2010 - or new commands, by saving macros in Excel 2010 - some parts may be incompatible with earlier versions. For example, I had problems with colors: Excel 2010 supports rgb() colors, while the older version only uses a 56-color palette (and colors are selected by a number from 1-56). However, once I used the old commands, they continue working in Excel 2010.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
