MoreQuery for Mac 2.1

Bug fixes:

• Removed the MISSING reference.
• Fixed typos in the code.

Thanks to @Jon Peltier and @leratosiame for reporting the bugs.

New Feature:

• It is now possible to import files from the subfolders.

The Folder.Files function doesn't work correctly on Mac and fails to return the correct path information for nested folders. As a result, in previous versions, importing files from subfolders of the selected folder was not an option. However, in this new version, the Folder.Content function is being used instead. With the help of a custom function, files in the subfolders are now imported recursively.

The 'From Folder' menu item has two options, as shown below, allowing you to choose whether to import only the files in the selected folder or also include the files in the subfolders recursively.

Updates:

• The list object's connection property is now being created by using an actual workbook connection object. This also allows creating connection-only queries properly.
• Minor bug fixes.

New Features:

• The Import Data dialog
  
  
• From Existing Connection
  
  
• Connection-only query

Notes:

• Uninstall the previous version before installing the new version.