Stack Overflow
Stack Overflow

Questions tagged [excel-2011]

Excel 2011 refers to the spreadsheet editor included in Microsoft Office for Mac 2011.

151 questions
4
votes
4 answers

Counting cells that contain a certain bit of text without duplicates

I need to count the number of cells in a column that contain a certain bit of text. Actually, I will be doing multiple of these counts, and I need to remove the duplicates. Example info: Lala Lerly PTY LTD Trang AS TTE Trerek AS TTE PRING PTY LTD AS…
Luke Beacon
  • 154
  • 1
  • 2
  • 10
3
votes
5 answers

Waiting in Excel Macros

I am recording an Excel Macro where I would like it to wait half a second before switching to the next value. I am plotting changes to a graph, and right now it just storms through the values so you dont really see any changes. I would therefor like…
Saucepan
  • 298
  • 1
  • 6
  • 19
3
votes
1 answer

What does "=R[-115]C" mean in VBA for Excel 2011 on Mac?

What does "=R[-115]C" mean in VBA for Excel 2011 on Mac in below code? Range("F171").Select 'to select a cell ActiveCell.FormulaR1C1 = "=R[-115]C"
Waleed
  • 59
  • 1
  • 1
  • 8
3
votes
2 answers

Only display hours if time is greater than 60 minutes

I'm using a time-tracking sheet that calculates the time spent on a job by doing a simple subtraction between a start time and an end time in two cells. The hh:mm format would suffice in this case, or as a small modification I'm using [h] "h" mm…
Tom
  • 33
  • 1
  • 3
3
votes
0 answers

npm excel-export (Node.js) corrupt files

I need to export some data from my node.js application into an excel spreadsheet (for qa purposes). I looked online and found the convenient npm module called "excel-export". I installed it and followed the example that can be found here…
user3754489
  • 41
  • 4
3
votes
1 answer

Trouble Controlling Excel with Word using VBA; late binding and early binding aren't working

I am having trouble using the automation to control Excel from Word that should be possible from the GetObject function. I am using Office 2011 for Mac. My goal is take information from a word document and insert it into an excel workbook after the…
Eddie_Wharton
  • 33
  • 4
3
votes
1 answer

"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").ControlFormat throws an "Object doesn't support this…
marco
  • 806
  • 1
  • 7
  • 17
3
votes
1 answer

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 more. Therefore I modified my subroutine (like proposed…
TomThumb
  • 135
  • 1
  • 6
2
votes
2 answers

Create Word file from Excel 2011

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 how a Word document can be created in Excel 2011 with VBA? (I do not want to use…
rolf
  • 51
  • 1
  • 6
2
votes
2 answers

Opening New File using VBA on Mac

I am using Excel 2011 for Mac and trying to open a new file. However, I keep getting an error that file not found even though the file is there. The code I am using is below: Dim theFile As String theFile =…
Ali
  • 4,311
  • 11
  • 44
  • 49
2
votes
2 answers

Adding Outlook Object Library to Excel 2011 for Mac

I am trying to move a VBA macro code from Excel 2003 to Excel 2011. The macro requires sending an Email from Outlook. However, when I went to Tool > References to add the Outlook Object Library, it does not show up in the List box. How do I go about…
Ali
  • 4,311
  • 11
  • 44
  • 49
2
votes
1 answer

Is it possible for Excel to recognize a pattern of comma separated numbers in a cell and remove duplicates of that pattern?

Its an easy task for the human eye, but it will take me 2 weeks to do this if I do it manually. I'm using a UDF that I got from this site to add the TextJoin functionality to my Excel 2011. Works great, but I've encountered a problem on a new…
Devil07
  • 141
  • 1
  • 8
2
votes
2 answers

Excel: Average of parts of a column based on another column

Using Excel 2011 for mac, I have three columns: ID, Start date, end date and time to completion. (Date format: dd/mm/yyyy) ID | Start | End | Time 1 | 01/01/2016 | 05/01/2016 | 4 2 | 04/01/2016 | 08/01/2016 | 4 3 | 01/02/2016 |…
Julian Finn
  • 41
  • 1
  • 4
2
votes
2 answers

Add unknown variables to Excel

Here is a screenshot from my TI CAS: I would like to do the same into an Excel file. I want to put "x" in a cell and make other cells compute with it. Is there a way to add "unknown variables" to Excel? I don't want it to solve anything, but I need…
Annie Caron
  • 437
  • 1
  • 5
  • 15
2
votes
1 answer

Application.Filedialog support in Mac excel 2011

Couple of questions Is Application.Filedialog(msoFileDialogSaveAs) support in Mac excel 2011 vba? Difference between Application.Filedialog(msoFileDialogSaveAs) and Application.Dialogs(xlDialogSaveAs)?
Zara
  • 21
  • 1
  • 3
1
2
3
…
10 11