Tagged Questions

0
votes
4answers
143 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 ...
0
votes
2answers
355 views

vba run java class

How can I run a java class from VBA. I am trying to post to a server using Excel VBA. I can do this only with VBA on a PC but when using a MAC the DomDocument object returns a compile error. So ...
7
votes
1answer
384 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 ...
4
votes
1answer
64 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 ...
2
votes
1answer
133 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 ...
1
vote
1answer
2k views

Loop though files in a Folder on Mac OS X - VBA Excel 2011

I am trying to loop through files in a folder on Mac OS X using VBA Excel 2011. I tried the following code, but it does not work. Sub ListAllFilesInDir() Dim strFile As String Dim strPath1 As ...
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 ...
0
votes
1answer
4k views

Macro to prompt user to select CSV files for import into existing sheet in workbook

I am running a macro which automatically takes csv files and import them into specific worksheets in my workbook. However, I would want to add greater flexibility by having the user select the files ...
-1
votes
1answer
362 views

Conditionally formatting cells in Excel based on value or no value being present.

I have an Excel table that looks like this: Status Agarwal Anandan Donna Ashar Grand Total TOD 1 1 TOE 2 1 3 CFI 2 ...
0
votes
0answers
34 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
36 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
0answers
293 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 ...
0
votes
0answers
106 views

emailed xlsx file is corrupt on OSX, not on Windows

I'm using the email module to send an xlsx file as an attachment. (I'm coding on Windows.) The email goes through fine, and the attachment opens fine on Windows machines. But Mac Office 11 says that ...
0
votes
0answers
157 views

code below working on PC and MAC but not working on server. changes are needed?

All, I have this line in my code, which I have tested both on PC and MAC and works fine. I am trying to copy a file from an existing folder called Templates to a newly created folder (see 2nd snipet ...
0
votes
0answers
144 views

Addition required - 1) copying existing file from same directory as active workbook to new folder structure 2) updating hyperlink to new location

Good morning all, Based on the help of an expert I have managed to create the following code that executes nicely what I am asking to do i.e. create a new folder and subfolder structure at the same ...