The VBA editor does look slightly different in Excel for Mac, but also has the same functionality. Tally 5.4 download. Dead effect 2 - cybermagic for mac. Where commands or menus in Excel for Mac 2011 or Mac Office 365 are siginificantly different to those in the Windows version I have provided additional instructions for Mac.
Free Excel For Mac
willardpeabody
New Member
- Getting help with VBA code in Office 2011 for Mac You can rely on the following five principal sources of code examples, syntax help, and general programming assistance: Macro recorder: In Excel and Word, you can record your actions and then look at the code that was recorded inside the modules.
- Now that excel vba is 'back' for Mac in Office 2011, I would like to try to make my macros work for mac also. I have NOT yet got a copy of Excel 2011 for Mac and have not tested anything. But this question is pre-emptive: In one macro that I have programmed, I use the library MSXML From what I understand this comes installed with Windows.
Excel Vba For Mac 2011 Version
Microsoft Excel For Mac 2011
Hi!
I'm finding it difficult to do one specific thing. 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).
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'):
Workbooks.Open Filename:= _
'Macintosh HD:Users:MainUser:Documents:Folder1:Example.xlsm'
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.)
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?
I own a copy of Mr. 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. Excel textbook says only works on windows. Likewise, using some sort of Environ('username') function also does not work on a Mac, I'm told. I'm sure that there is someway this can work on a Mac!
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.)
Thanks so much,
Will
I'm finding it difficult to do one specific thing. 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).
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'):
Workbooks.Open Filename:= _
'Macintosh HD:Users:MainUser:Documents:Folder1:Example.xlsm'
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.)
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?
I own a copy of Mr. 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. Excel textbook says only works on windows. Likewise, using some sort of Environ('username') function also does not work on a Mac, I'm told. I'm sure that there is someway this can work on a Mac!
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.)
Thanks so much,
Will