Tagged Questions
0
votes
0answers
91 views
Add a tab and ribbon to excel 2011 on Mac
How do I add a new tab and the ribbon for the same in Excel 2011 on Mac using VBA or any other approach?
All the links I see are about doing the same for Excel 2010 or 2013 for windows.
1
vote
1answer
82 views
Does `Application.StatusBar` work in office 2011?
I wrote this little macro on my mac using office 2011. I don't see any status bar. Anyone know why this is not working?
Sub testStastusBar()
Application.DisplayStatusBar = True
...
1
vote
0answers
86 views
How to remove Help button from CommandBar Popup menu
I'm using the Application.CommandBars.Add method to create a custom PopUp menu. I'm on a Mac with OS 10.8 and using Excel for Mac 2011. There's no problem in creating the menu and having it execute ...
1
vote
1answer
200 views
Mac Excel 2011 VBA Evaluate
I am moving a excel VBA from PC to Mac and one line has an Evaluate function, for example:
Public Function test()
test = Evaluate("=2+2")
End Function
However, if I try and run the macro on ...
2
votes
2answers
3k views
Load contents of CSV file to array without opening file
I have a requirement to collate over 6000 csv files into a single csv document. The current VBA process is:
1. Open individual CSV data file
2. Load contents of file to array based on number of rows
...
2
votes
1answer
40 views
Display Co-Ordinates
Cell A1 has top left coord of box, A2 has bottom right coord of box, how do I get A3 to display all the coords of the box in csv format?
Ex:
Cell A1 = (24,20)
Cell A2 = (26,19)
How to get this?:
...
1
vote
2answers
4k views
How to parse XML in Excel 2011 for Mac?
I have some VBA code for accessing various XML-based web APIs from Excel (2007, 2010), and have just run up against a user who is on a Mac running Excel 2011. The code I've developed depends on a ...
1
vote
1answer
741 views
“Object doesn't support this action” for a drop down menu in Excel 2011 (Mac OS X)
I have a big Excel Workbook made with Office 2010 with some VBA code. Everything seems to work fine apart the drop down menus. Precisely, they work, graphically, but
Me.Shapes("Drop Down ...
1
vote
1answer
2k views
Date for VBA not working in Excel 2011?
Here is my code, I am attempting, which works BTW on a PC, but not on a Mac, to run this code and have an excel sheet created, named, add a tab, change the color of said tabs, change the name of said ...
3
votes
1answer
4k views
vba excel shape
I've used a small subroutine to insert a picture into my sheet by
ActiveSheet.Pictures.Insert(URL).Select
This works fine with Excel 2003 (Windows), but does not work with Excel 2011 (Mac) any ...
1
vote
2answers
3k views
Create Word file from Excel 2011 vba (Mac)
The usual approach to create a Word document from Excel vba
Set WD = CreateObject("Word.Document")
results in an error when run with Excel 2011. Any idea on how a Word document can be created
in ...
