May 14, 2015  When I make a column or row group, the group has the '-' sign, but when I click it nothing happens -- it does not collapse. Am I missing something? This thread is locked.

Hi I am trying to list all the files in a subdirectory of where the Excel workbook is residing in. For some reason, the code cannot execute beyond the Dir function. Can anyone please advise? Gianna, you cannot use DIR like that in VBA-EXCEL 2011. Best free photo editing software for mac. I mean the wildcards are not supported. You have to use MACID for this purpose.

See this code sample ( TRIED AND TESTED) Sub Sample() MyDir = ActiveWorkbook.Path strPath = MyDir & ':' strFile = Dir(strPath, MacID('TEXT')) 'Loop through each file in the folder Do While Len(strFile) > 0 If Right(strFile, 3) = 'csv' Then Debug.Print strFile End If strFile = Dir Loop End Sub See this link for more details on MACID Topic: MacID Function Link: EDIT: In case that link ever dies which I doubt, here is an extract. MacID Function Used on the Macintosh to convert a 4-character constant to a value that may be used by Dir, Kill, Shell, and AppActivate. Syntax MacID(constant) The required constant argument consists of 4 characters used to specify a resource type, file type, application signature, or Apple Event, for example, TEXT, OBIN, 'XLS5' for Excel files ('XLS8' for Excel 97), Microsoft Word uses 'W6BN' ('W8BN' for Word 97), and so on. Remarks MacID is used with Dir and Kill to specify a Macintosh file type.

Since the Macintosh does not support * and? As wildcards, you can use a four-character constant instead to identify groups of files. For example, the following statement returns TEXT type files from the current folder: Dir('SomePath', MacID('TEXT')) MacID is used with Shell and AppActivate to specify an application using the application's unique signature.