![]() ![]() Best to use the xl* constantsġ5) I can’t see any UI way to sort a pivot table column by values. Open is on RecentFile object, not Workbooks.ġ0) GetSetting raises error 5 if key is not found, rather than returning nothingġ2) GetSaveAsFilename on a Mac the filefilter is not workingġ3) CreatePivotTable does not allow xlPivotTableVersion10ġ4) Saveas FileFormat constants are 1 higher than Excel 2007. Need to specify Characters(1,100) or whateverĨ ) Workbooks.open Local:=true named argument not found Microsoft ADO Ext 2.8 for DDL and SecurityĦ) Application.FileDialog(msoFileDialogFolderPicker) not availableįileDialog does not exist, see Ron’s site for applescript equivalent.ħ) .Text = “.” -> argument not optional ![]() Microsoft ActiveX Data Objects 2.8 Library “If you omit all the arguments, this method simply toggles the display of the AutoFilter drop-down arrows in the specified range.” Actually have to use tofiltermode=false 1) DIR() returns error rather than null string, so trap itĢ) rg.Find Searchformat named argument not found Same for ReplaceFormat
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |