A macro is a rule or pattern that specifies how a certain input sequence (often a sequence of characters) should be mapped to an output sequence (also often a sequence of characters) according to a defined procedure. The mapping process that instantiates (transforms) a macro into a specific output ...
0
votes
1answer
15 views
Lisp recursive macro problems
I'm writing a recursive Lisp macro taking a number n and evaluating the body n times (an exercise from ANSI Lisp). I've tried two ways of doing this -- having the macro call itself in its expansion, ...
-1
votes
0answers
10 views
Macro: search across two columns and copy the entire row if 2 values match
I have a quick question regarding macros. I have three sheets, the macro sheet, the master list sheet and a report sheet. I would like a macro (in the macro sheet) to search across two columns in the ...
0
votes
1answer
27 views
Hide AutoExec() and AutoNew() macros from the macro list yet still have them run?
I'm trying to keep certain macros running when Word fires up or opens another document, but I want them removed from the list of macros the user can access (alt+f8).
I've tried adding 'private' ...
0
votes
1answer
16 views
Is it possible to run Macro in more than 1 workbook at the same time?
I am new in this forum. I just need to know, if is it possible to run multiple macro in multiple workbooks at the same time. I am using Excel 2007. When I start the Macro in the workbook, I can not do ...
0
votes
0answers
7 views
Outputting Drop-Down Form Field to String for use in VBA formula
Ok, I have a Word 2010 template I'm playing with. I have a button at the top that users click to automatically save the word doc as a pdf with the (almost) correct name, in the correct directory, and ...
0
votes
0answers
23 views
Error Help: Adding to ranges using Application.Union
I am attempting to loop through a large list rows searching a specific column for values based on the values in another tab. I had it working for one value but as soon as I add a second criteria I am ...
0
votes
1answer
18 views
Excel: simple macro to paste as text returns error 1004: Could not run the paste method of worksheet class
When I try to copy any text from another application to a cell in Excel 2010 (Win 7 64bits) using this macro:
ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:=False
I get this ...
0
votes
0answers
11 views
Automatically move data between tables on condition
I have an Excel 2007 spreadsheet titled "Generic". It has 3 sheets called "Sheet1", "Sheet2", and "Sheet3". Each sheet has a single table called "Table1", "Table2", and "Table3" respectively. The ...
2
votes
2answers
43 views
How to use defmacro instead of eval?
I have come up with the below function, which works as intended but it uses eval which is horrible, and does not exist in ClojureScript where i intend to use it.
(defn path [d p]
(eval
(concat ...
1
vote
1answer
22 views
how to create a macro in racket where a list becomes the args of said lambda?
How would I go about in doing a define-syntax-rule that accepts a list as arguments and a list (or a quote, in case it is a single element) as body of a lambda?
i would like to do something like:
...
1
vote
5answers
56 views
Why should or shouldn't we prefer a macro that accepts arguments over a function that does the same job?
Following are two programs that give the area of the circle when the radius is passed as argument.But in the first program, macro.c, I am using a macro for the job ,while in the second,function.c I am ...
0
votes
1answer
12 views
(Macro Language Processor m4) How do I run resp. compile .m4 programs on Ubuntu 13.4?
I installed m4 from this site:http://www.geeksww.com/tutorials/libraries/m4/installation/installing_m4_macro_processor_ubuntu_linux.php
So far so good. The package also had some examples in it. If I ...
-1
votes
0answers
14 views
Excel Macro help. Selecting rows between two specific text strings [closed]
I am trying to create a macro to select between two specific text strings. This data is repeating, and I would like to capture it and then paste it on successive new sheets. Each set of data begins ...
0
votes
1answer
37 views
Using def-macros to capture source code
(for TL;DR, go to the bold face part)
I am having a clean closed type class system with serialization (detached from POJO serialization woes). For example:
trait Expr
case class Const(i: Int) ...
2
votes
2answers
44 views
VBA Excel Won't Change Cell to the Right Color
I am new with using VBA macros in excel, and I am trying to change the background color of a cell based on the condition that another cell is not empty. I thought I had it figured out, but I must be ...
