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 |