I read few sources and found that Excel for Mac 2016 requires to call GetSaveAsFilename dialog with initial filename with manual confirmation to do it, so I modified my code like this: #If Mac Then But in Mac I cant make this part to work, no files created in result: ThisWorkbook.Path & Application.PathSeparator & sheetname & ".csv", _ I already created a new workbook (ActiveWorkbook) with data copied from the main workbook and fully worked Windows part of code. I want to export sheets to CSV and save them into the same directory where workbook stored. I'm experienced VBA developer but have no enough experience in Mac to complete my very simple project.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |