Tagged Questions
0
votes
0answers
4 views
Excel VBA From PC Excel 2010 not working in Mac Excel 2011
I am pretty new to VBA and I am trying to run a script written by someone else on their PC running excel 2010 on my mac running excel 2011.
The line creating the error is: x = ...
2
votes
1answer
18 views
VBA code to fetch data from Mysql DB in Mac Excel 2011
I was using ADODB code in Windows to fetch data from Mysql Database and it was working fine. However, I can not seem to get my Excel workbook (using ADODB) to work with Excel Mac 2011. After a lot of ...
1
vote
1answer
41 views
VBA Form Completion across multiple worksheets
I have a standard template I've designed in WKBK 1 that I am using to grade teachers.WKBK 1 has 15 different worksheets, or 1 per teacher. In WKBK 2, I have a table I am using to keep scores on their ...
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
147 views
How to paste values from a variable into a column
I needed to write some code that would select the minimum of blocks of cells that correspond to equal cell values across rows in another column. Here's what I have:
Function MoveDown(c)
MoveDown ...
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
...
2
votes
1answer
39 views
Range.Count difference between PC and Mac
I am downloading historical stock price data from Yahoo Finance I need a count of the number of data points that get downloaded. The data itself gets downloaded such that Row 16 is a header row and ...
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 ...
0
votes
0answers
109 views
Excel for Mac 2011 - Delete all rows except rows with a range of two word terms
I found some macros, input boxes, and VBAs to do this function, but none of them worked for me. I'm using Excel for Mac 2011. I have never used these features in excel, so I would like some help ...
0
votes
1answer
2k views
How to get the cells value through Function in VBA Excel
I am working on a task where the users enters first a column from “A” to “Z” and then a row number from 1 to 20. I have to write a function getIntData(col as String, row as Integer) as Integer that ...
1
vote
0answers
290 views
VBA (Excel) Dictionary on Mac?
I have an Excel VBA project that makes heavy use of Windows Scripting Dictionary objects. I recently had a user attempt to use it on a Mac and received the following error:
Compile Error: Can't find ...
0
votes
1answer
132 views
Highlight Duplicate Rows - Entire Row vs Entire Row
I cant believe how difficult this has been. I want to find all duplicate rows. Columns A:R, dynamic row count. I know how to delete the rows. But I just want to highlight them. My data is in a ...
0
votes
1answer
188 views
Excel 2011 VBA Documentation
I have used VBA in various Office products on Windows but this is my first attempt on Mac (OS vsn 10.8; Excel version 14.3.8; Microsoft Visual Basic version 14.3.8. I can't find any documentation on ...
0
votes
1answer
385 views
Returning values through VLookUp in sequence of Multiple Instances
This is my first question in this forum..
I am facing problem in excel macro. I have two different workbook. I have to pick particular values from first workbook and copy in another workbook ...
-1
votes
1answer
36 views
Excel Macro for Identifying duplicate records in Excel
I have attached a scenario of duplicate records.
Appreciate if you can let me know macro for highlighting duplicate records. For example record 1 and 3 are duplicated(Salary may be different, if ...
0
votes
1answer
163 views
Remove entire row based on match?
Need to remove multiple rows within a CSV file in Excel based on a match in column L on sheet1 with column A on sheet2. The content is email addresses. How can I achieve this?
So, if sheet2 column ...
0
votes
1answer
978 views
Excel VBA macro works on Windows but not on Mac
I coded an excel macro on a Windows PC and need to make it work on a MAC.
Basically there is a field in the sheet where I need to enter the folder path and the macro is looking for images within this ...
0
votes
0answers
66 views
Is there a way to import image from a web site to Excel sheet using QueryTables?
I am trying to get images from a website and populate Excel sheets in Mac (2011).
Shapes.addpicture and a lot of things that work in Windows do not work in Mac.
I'm wondering if I can use QueryTables ...
0
votes
1answer
118 views
Excel Visual Basic - executing a command if two cells in the same column are populated
My first post here, so i shall try to make it as concise as possible.
I need to add some functionality into a spreadsheet that cannot use data validation. So i need it to be in visual Basic.
The ...
0
votes
1answer
45 views
Checking for condition before continuing on a form
I am using Excel 2011 for Mac. I have a userform that contains 3 combo boxes. The data in the combo boxes is populated with information from the spreadsheet. The initialization populates the combo ...
2
votes
1answer
3k views
VBA Excel query a closed workbook without opening it
I'm having trouble searching for a string within a column of another, CLOSED excel workbook.
The following code gives a type mismatch error on MsgBox
If, however, I replace that line with ret = "'" ...
0
votes
1answer
602 views
Conditional copy/paste cells from sheet to sheet based on overlapping content in A columns?
Excel 2011, Mac.
Two sheets, both with names in "last, first" descending in A.
The name list of sheet 1 is much shorter than the name list on sheet 2.
Sheet 2 has the headings there in row 1, but the ...
0
votes
1answer
109 views
IF LOOP in VBA Function
I made two excel sheet.
one contains information as below
Date Name Quantity
12/7/2013 Bharat Sapte 12
12/7/2013 Ghorpade 10
14/7/2013 Desmukh ...
1
vote
1answer
367 views
Looping the cells and getting the count of a string value in all the sheets and printing the count sequence in another column in respective sheet
I stuck with a problem in excel, also new to VBA macro.
I have 4 sheets (sheet 1, Sheet 2, Sheet 3, Sheet 4) in a excel file which consists of same two columns in all the Sheets. Columns namely ...
3
votes
2answers
306 views
Excel contains filter with more than 2 values
Does anyone know how I can quickly hide/remove all rows in sheet1 that contain any of the rows info from sheet2?
It would need to contains filter as it wouldn't be an exact match.
For example
...
0
votes
3answers
1k views
Excel macro to find duplicates and copy their adjacent cells
I need a macro that loops column C and locates the duplicate values and copies them to col D, once a duplicate value is located it would copy the adjacent value from Col A and place it in Col E
...
1
vote
1answer
260 views
Mac Excel 2011 VBA UDF not working - SET or FIND command seems to be the issue
I am converting a spreadsheet from Excel 2007 to Mac Excel 2011. I have tried for hours to solve my problem, without success, so any help would be appreciated!
This UDF finds a string in a range, ...
1
vote
1answer
355 views
getelementsbyID inner dt id values
I am extracting data from HTML using Vb Script. This is the HTML code from which am trying to extract the data.
<dl id="overview">
<dt id="overview-summary-current-title" ...
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 ...
3
votes
1answer
433 views
Excel for Mac 2011: UBound() Not Working
I'm working on making an existing macro-enabled spreadsheet functional on Excel for Mac 2011.
I have a function (Source) that searches arrays for a specified value:
Function ...
3
votes
2answers
2k views
How to edit Excel 2011 VBA buttons instead of clicking them
When I click the VBA buttons in Excel 2007 I go to edit mode. But when I'm trying to modify them inExcel 2011 - I click it, and it clicks! But how to switch command mode and edit mode?
5
votes
3answers
789 views
Copy-paste doesn't trigger worksheet_change
Here is what I need to do: When I have written something into a cell in the sheet, my Worksheet_Change code should check if the cell contains certain characters and then replace those characters. That ...
0
votes
0answers
167 views
Excel VBA with given values compare recordset obtained from Access
I have an input called part number i.e. Test123, and have obtained several datasets from an Access Database through vba.
Given data set in obtained order is:
(PartNo) (JobNumber)
TestW ...
0
votes
0answers
143 views
Ouput data to specific cells in Excel document through its vba from an Access database
Screen Shots of Access and Excel as Explained below (Visual Aid)
I am trying to obtain data stored in an Access Database and output it to specific cells in an Excel (Macro enabled template) document. ...
0
votes
1answer
114 views
Recursive list/sort with a redundant or missing cell
I'm using a single column of data that contains a few quirks. I have included the VBA code below the details of my problem.
An example of how the data is organized:
NAME
Court
Offe
Court
Offe
Offe
...
0
votes
0answers
712 views
VBA Code to update all Excel pivot table filters does not work on a Mac
I've created a set of pivot tables in MS Excel 2007 - all of the pivot tables are derived from the same data table. I have VBA code on each worksheet that will update all pivot table filters with the ...
1
vote
2answers
2k views
VBA: save cell contents to text file in a specific location on Mac
I'm really new to VBA, and I'm trying write a macro that will save the contents of some specifc cells to a specific location on my Mac. The whole code works fine, EXCEPT that it won't save to the ...
3
votes
2answers
481 views
Excel VBA – How to create AND dump hash of arrays complex structure?
I am from perl background and learning Excel-VBA. In perl, we can use Data::Dumper to get the dump of data structure.
Here is the example from perl:
use strict;
use Data::Dumper;
my $hash={};
...
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
...
0
votes
4answers
910 views
Copying specific columns from several workbooks to one master workbook, without constantly editing code
I am trying to read a specific set of columns from a workbook (every week it is a new workbook) and copy them into another workbook. This I have been able to do, but I think there is a cleaner way to ...
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?:
...
0
votes
2answers
509 views
Run Time Error 52 Bad File Name - Mac Only
I have the following function which produces a runtime error 52 (bad filename or number) only on Mac on the line Open filePath & filename For Output As #1
Function ExportAsCSV(ByVal charToEncode ...
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 ...
0
votes
2answers
745 views
VBA opening/closing workbooks on MAC throws error
The following macro has no problems on windows but throws a runtime error on a MAC. The problem is that I do not have a MAC to test this on. The code simply picks up the locations of 2 files (A & ...
8
votes
3answers
1k views
How to develop an Excel Macro that contains regular expressions so it will work in Windows and Mac
I have developed an Excel 2010 VBA Macro that makes use of VBScript.RegExp. One of my users is apparently using Excel Mac 2011, which supports VBA, but no VBScript.RegExp.
I have seen several posts ...
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 ...
3
votes
1answer
137 views
#NAME? error after renaming all my 'ThisWorksheet' modules
I have a excel workbook with many worksheets and a lot of data. One of my VBA functions is the following. It has been working perfectly well.
Function TextResult(Name As String) As String
Select ...
0
votes
1answer
433 views
Select columns and copy duplicates between them
Two nonadjacent columns, Column A and C, contain strings and Column E (again nonadjacent) should contain the duplicate strings between Column A and C.
Now my main problems is that Columns A and C ...
2
votes
1answer
339 views
Programatically adding reference gives run-time error
I've written two VBA add-ins for Excel (Office 2011, Mac): The first, 'basic' add-in also provides functions for the second add-in. There will also be other add-ins that use functions of the basic ...
0
votes
1answer
208 views
ThisWorkbook vs opened_workbook?
What is the difference between ThisWorkbook and opened_workbook?
I only ask because I am looking through some of my old code and I am seeing both being used, I am attempting to clean up some of this ...
