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
3answers
7 views
How to Automatically have Text Cursor in Text Box (as Opposed to Command Button Selected) in Form?
I have two Excel picture objects linked to different forms, each with a text box and OK/Cancel buttons. In one form, the text cursor is in the textbox when clicking the object which is what I want:
...
1
vote
2answers
19 views
Excel VBA code modification so only alert me once for same item
I manage a contract log that list out all of my company's contracts with the effective and expiring date.
I've written VBA code that alerts me whenever any one of the contracts is about to expire; a ...
0
votes
1answer
19 views
How can I avoid evaluation of a lazy-seq inside a collection
I'm trying to write a debug macro that prints out expressions and their values. This lead to problems if I send in a lazy-seq, because if I turn it into a string (with str) the program hangs. It's ...
0
votes
0answers
19 views
Want to create a macro to perform vlookup in excel
I have a spreadsheet that I need to copy data into matching the product code. I know that I can use Vlookup to do that, but I wasn't use if there is a macro to do that? I have never created a macro ...
-1
votes
0answers
13 views
Client-Server programming using VBA macro [closed]
Is it possible to implement a simple client-server model using VBA macro? I was thinking to send some data strings from excel macro to a server running on my Android phone. Can it be achieved? Please ...
1
vote
1answer
23 views
subtotaling on live data macro
I have created a data table through Sharperlight reporting thats generates its results into excel as shown below:-
What I want to do is develop a macro that will subtotal all categories for the ...
0
votes
1answer
54 views
Grouping Similar Cells in Excel
I have an excel sheet that has 7000+ records. It has two columns- Number and Title. The rows under the 'title' column contains strings and some of the strings are quite similar. For instance:
Need ...
0
votes
0answers
19 views
Refresh Pivot table periodically
I have a pivot table in Excel which gets data pulled from a query with a ODBC connection from an Oracle Database which I set up on a Remote desktop where the Oracle Listener is installed.
The Excel ...
1
vote
4answers
59 views
Macros in system calls
In c++, is it possible and safe to use macros in system calls? Take the following code for example:
#define WINX 54
#define WINY 30
int main()
{
system("mode con lines=WINY cols=WINX");
...
Would ...
0
votes
1answer
24 views
Locating first empty cell in a column and ask user to input
I have a big excel file with different dates on Column B (it starts at row 7 and jump to the row 9.. e.g June6th - B7, June 7th - B9, June 8th - B11).
I want to have a macro that locate the first ...
3
votes
1answer
33 views
Why doesn't my macro give any output
I wrote a simple macro for printing out expressions and their results when debugging.
(defmacro dbg-print
"Print out values or expressions in context"
[& rest]
`(let [symb-str# (map str ...
13
votes
3answers
414 views
Confused by squaring macro SQR in c [duplicate]
This question was asked to me in a mock interview...Really got surprised to find awkward answers...
consider a macro:
#define SQR(x) (x*x)
Example 1:
SQR(2) //prints 4
Example 2:
If SQR(1+1) ...
1
vote
1answer
33 views
Is it possible to match repeated patterns in R5RS macroes define-syntax/syntax-rules?
This R5RS macro is what I have tried and is pretty much what I want to do. Racket or other implementations don't like this macro exactly where I wanted the magic to happen.
(define-syntax ...
-3
votes
2answers
47 views
Excel & VBA: Copy rows into a new sheet based on cell value
I'm a total newbie in Excel and VBA.
I have a sheet like this:
A B C D
someinfo someinfo someinfo OK
someinfo someinfo someinfo OK
someinfo someinfo someinfo ERROR
someinfo ...
2
votes
3answers
27 views
loading excel files takes forever [closed]
I use huge excel worksheets and they take forever to load because of cell calculations using macros and other formulas (over 5 minutes even if I have a good computer) . I was wondering if there was a ...
