TempfnameList = Application. TempfnameList = Select_File_Or_Files_Mac() Authoring Power Query queries With this update, you can also create and manage Power Query queries in your workbook using VBA. However I also found that Application.GetOpenFilename does not work on the Mac, so I did some googling and came up with this function as a workaround on the Mac: #If Mac Then Click the Data tab on the ribbon > Connections > select the desired connection > and click Change File Path button to update it. FName = Application.GetSaveAsFilename(fileFilter:=filterString, InitialFileName:=myInitialFileName) I find that I am able to use Application.GetSaveAsFileName on both PC and Mac without issue.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |