![]() I hope someone can help me with this simple problem! There's not a lot of support out there for Excel 2011 for Mac! (Especially because it's so new.) I'm sure that there is someway this can work on a Mac! Likewise, using some sort of Environ("username") function also does not work on a Mac, I'm told. ![]() Excel textbook says only works on windows. Excel's textbook 'VBA and Macros: Microsoft Excel 2010,' but I could not find an answer there!! Other solutions that I found online either involve Windows API, which the Mr. Is there some way to use a name for a computer/user that is generic and not specific to one computer and user? Can I open the workbook in another way without referencing the entirety of the file's path? How do I get it to open a file with the same name and in the same folder, except on a different computer with a different user? (So that this file can be shared and my macros can run effectively on each computer.) "Macintosh HD:Users:MainUser:Documents:Folder1:Example.xlsm" The problem is when I use the following code to open a specific workbook, it will only open on the computer with that Computer name ('Macintosh HD') and that user name ('MainUser'): I want to open a workbook that has the same filename on 2+ different computers, all of these computers being Macs (OSX version 10.5 and later). I'm finding it difficult to do one specific thing.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |