Using VBA Filesearch in Excel 2010?
I've started to explore upgrading my VBA code from Excel 2003 to Excel 2010 and keep finding lots of changes! My latest dilemma comes from the list of "Object Model Changes Since Microsoft Excel 2003" that I found in the Excel 2010 VBA help. If I try to use any of the objects listed as "hidden", I still get an error code.
Shouldn't I be able to still use the deprecated objects?
Any suggested workaround or reference to a master list of optional objects to use? I use a lot of these, such as:
- various chart properties
Thanks - John