VBA enables building user defined functions, automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). It is also built into Office for Mac applications (apart from version 2008). Microsoft discontinued support for Visual Basic for ...
1
vote
1answer
8 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 ...
1
vote
2answers
36 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?
4
votes
1answer
65 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
35 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
1answer
46 views
How do I issue an HTTP GET from Excel VBA for Mac 2011
I need to issue an HTTP Get with a query string to a web service from Excel for Mac 2011. I've seen the answers for using QueryTables (How can I send an HTTP POST request to a server from Excel using ...
0
votes
0answers
37 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. ...
1
vote
2answers
48 views
VBA If Then Or Statements
VBA beginner here. I'm trying to do a pretty simple if/then statement in VBA 2003, but I'm running into the issue. My code reads:
Dim var as Integer
If var = 1 or 2 Then
'Do stuff
Else
...
0
votes
1answer
43 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
...
1
vote
1answer
29 views
Why is my applescrpt returning 2 msgbox while running the excel macro?
The following applescript seems to be running the macro twice as I am getting message box 2 times.
tell application "Microsoft Excel"
activate
run VB macro "Test.xlsx!Test()"
end tell
And the test ...
0
votes
0answers
303 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
229 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
213 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
1answer
154 views
How can I retrieve JSON from an HTTP endpoint, from within Excel on MacOS, and parse it?
I have seen How can I send an HTTP POST request to a server from Excel using VBA?
and the MacOS-friendly response that describes how to retrieve data from an HTTP endpoint using QueryTables. It ...
0
votes
3answers
494 views
Excel VBA :: Find function in loop
I'm trying to loop through several worksheets that contain some source data that has to be copied to one main sheet, called "PriorityList" here.
First of all, the sub is not working and I think the ...
1
vote
2answers
298 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
...
