References include Visual Basic for Applications, Microsoft Excel 14.0 Object Library, Microsoft Forms 2.0 Object Library, Microsoft Office 14.0 Object Library and Microsoft Visual Basic for Applications Extensibility 5.3. I have tried it both ways and neither worked. I read somewhere else that Mac uses a period instead of a forward slash. I have tried the code below but it fails at SourceFile=Dir(myDir & ".*.xls) From there I will copy the first four columns into another file and continue on with the my processing. The macro selector lists every macro in every open workbook that.2 answers 4 votes: If you are using macros to reformat data, move it around, or perform calculations in user. ![]() I want to have the user select from this directory the appropriate file. Mac Excel 2011 has a better VBA IDE (Editor) than newer versions. ![]() I want to open the "Finder" on a Mac to select from available Excel files. ![]() I have done this with Excel for Windows but it doesn't seem to work on a Mac.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |