Mac and cheese always sounds good, right? How to make a panko topping for mac and cheese.

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.

The YEARFRAC function may return an incorrect result when using the US (NASD) 30/360 basis, and the start_date is the last day in February. Remarks Excel stores dates as sequential serial numbers so they can be used in calculations.

Can anyone please advise? Gianna, you cannot use DIR like that in VBA-EXCEL 2011. 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.