excel 2011

Hi everyone, was wondering if someone could help me, i created a macro on excel 2016 on my Mac, which will import data from another work book that is not open. It works perfectly. Now, the problem i have is when i sent it to my colleagues Mac who has excel 2011 installed everytime she runs...

I'm looking to use macros during a process of exporting data from Excel to Word. As the first step in this process I'm needing to select multiple rows (number will vary depending on number of classes attended) of information based on unique identifiers for each student that has attended...

Please forgive if this has been covered, I searched but there were *so* many posts on the general topic and the first bunch I looked at were all Windows-only solutions, so I decided I just needed to post anew. I'm on Mac Excel 2011, so there is no Pivot Table Wizard. I have 4 workbooks, each...

Hi I wonder if anyone could help , I can not get the Horizontal format Image (Jpeg Photos) menu to appear which allow me to crop or to set transparent backgrounds.. I only can see the vertical menu of the Format Picture in which these options are missing. I can not set transparent back ground...

Hello, I'm new to VBA and am having trouble setting the size of a string that is being passed to a new word document using excel. I keep getting the error: Run-time error '5843': Method 'Size' of object '_Font' failed. I am using Office 2011. Option Explicit Sub CreateBasicWordReport()...

Hi All, Google isn't being my friend when it somes to searching for answers to this, so I'm hoping someone on here can help me instead. :) The following code in Windows Excel 2010 returns True or False, but I just can't figure out how to check for a networked file from within VBA on a Mac...

Hi, I had a macro-enabled spreadsheet works well in windows PC, and now I want to make it work on Mac. When I open the spreadsheet in excel 2011 on mac, I noticed the following problems for combo boxes. 1). In windows version, when you click on a drop down list, the content will show, and...

Hi! Just want to ask if there's a difference between Excel VBA in Mac and in Windows? I just installed my Microsoft Office 2011 in my macbook and tried to run my codes that I created when I was still using Windows (and btw, I think I used Excel 2007 with that). I remember it was working really...

Hi all, I need to do some webscrapping in VBA (EXCEL 2011) but on a mac machine. Can anyone provide any info on opening a browser on a mac? That I can scrape the dom objects with. I know some will say use xmlHttp and things similar to it, but the site i am scrapping from has a username and...

I have a column in a Table with keywords. Here's an example: <colgroup><col></colgroup><tbody> Location,performance errors,ip address,impact ip address, identification, transaction Performance, identification historic, performance, UI performance, consolidation, identification...

System: MacBook Air with Lion, Office 2011 When trying to open and confirming to activate macros, I always get the message: runtime error 68, device is not available. Thanks!

I'm a relative Excel beginner. Using Excel 2011 on a Mac. On one of my Excel docs I can't get the dotted blue line page breaks to show. Any way to diagnose? Any way to correct in this one file? Thanks for any suggestions.

Hi: I've been using Excel 2007 and an add-in from Digdb that allows me to calculate medians within filtered tables, since that is not one of the options currently available within Excel (on the total line at the end of the table). Now that Microsoft has released Excel 2011, I'm hoping to...

We are all glad that macro capability was restored to Office 2011 for Mac. Unfortunately, it appears the ONLY way to get at your macros is via Tools - Macros - Macros. Even here, the pane provided is not wide enough to display the full names of my macros. If you are used to accessing your...

We are evaluating Office 2011 for Mac. I have an XLAM file which requires a password to open. It opens with that password in Excel 2007 (on a PC). The same password is rejected when I try to open a copy of the XLAM file in Office 2011 for Mac. (Yes, I did check CAPS LOCK.) The response is...