| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 VB to Excel 2003 VB
Howdy
I've got a worksheet I created in Excel 2007, and saved as a .xls (Excel '97-2003) with a macro that uses the following line of code: ActiveWorkbook.Worksheets(combinedEMDataTypes).Aut oFilter.Sort.SortFields.Clear When I run the sheet in Excel 2003, it bungs out an error that states "Object doesn't support this property or method" I don't think this PC has been updated since it got built as it's supposed to be 'offline', so would an update fix it, or am I going to have to figure out another way of making my code work? Cheers peeps Dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
| Opening Excel 2003 file in Excel 2007: Links do not work | Excel Discussion (Misc queries) | |||
| Linked text boxes created in Excel 2007 are blank in Excel 2003? | Charts and Charting in Excel | |||
| Data Import to Excel Issue with Excel 2007 and Excel 2003 on same | Excel Discussion (Misc queries) | |||
| Excel 2007 xlsx files open as Read-Only in Excel 2003 after Compat | Excel Discussion (Misc queries) | |||
Threaded Mode
