Questions tagged [macros]
***DO NOT USE for VBA / MS-Office languages. Use [vba] instead.*** 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.
macros
13,758
questions
1
vote
1
answer
39
views
macro to change the color of a cell after i copy it (CTRL+C)
i do a lot of testing and i use a list of barcodes generated in Excel.
I copy the barcode i use, then change the color of the cell so i know which ones are used.
Is there a way a macro could ...
- 35
0
votes
0
answers
7
views
How to call Power Point macro function from python without win32com
I'm currently working on a python program (I'm new to python) that modifies a Power Point template that is for official releases. Unfortunately after my program finishes, I need to run the macro.
My ...
0
votes
0
answers
33
views
can I trust compiler to avoid passing unused function parameters
I am writing error-handling code at many places, which typically has the form
if (!condition)
errorHandler(info);
here errorHandler is a function and info is in practice more than one ...
- 101
1
vote
1
answer
41
views
SAS how to use character variable in if statment
I want to use character variable for if statement comparison, however why SAS always trying to treat it as numeric?
let VAR = "apple"
other code...
%macro Exec_day1();
If &VAR. eq &...
- 237
0
votes
1
answer
18
views
How if condition works in SAS background?
How do if works if i write the code below:
data B;
h= 1;
D="M";
run;
data c;
set b;
length nn $30;
type = vtype(H);
if type eq "N" then nn=put(h,best.);
else if type eq ...
- 1
1
vote
0
answers
42
views
Lua scripting being used in mouse macro. (logitech)
I have a Lua script for Logitech G Hub that moves my mouse for me. It's set to use MB4 for that. I want to remap MB5 to press shift, mb4. But when I have the script running and press MB5, it only ...
- 11
0
votes
0
answers
63
views
Define macro to another macro : a hack to re-declare constexpr variable
I want to ease coding a very complex function with re-declarable variable hack.
It can be very useful for constexpr assignment later.
Here is MCVE ::-
int main(){/// line 1
#define ...
- 1,116
-1
votes
1
answer
49
views
How do I get images to link to urls within my carousel?
I'm redesigning a confluence page that displays various visualizations. I am using the following code:
<div class="carousel">
<img src="image1.jpg">
<img ...
- 562
0
votes
1
answer
28
views
SAS Enterprise Guide Creating Date Range Prompt
I created a date range prompt using SAS Enterprise Guide Prompt Manager. I right click the prompt to see its related macro variables.
1- I just want to run the program and select the prompt values. ...
- 23
1
vote
1
answer
74
views
change column names using a dbt macro
Can I use a dbt macro to modify the column names in AWS redshift?
Example changes to be made:
"checkedAt" --> checked_at
"helloWorld" --> hello_world
"testKitchenNew&...
- 3,198
1
vote
1
answer
34
views
VIM: digraph for padding character breaks macro in register
If I do q e CTRL+W Right Arrow q, it binds the command "move one window to the right in the split" to the e key.
The macro for this as found by "ep is ^W<80>kr.
If I want to type ...
- 275
0
votes
0
answers
23
views
Excel data copy with multiple filters in pivot table to another excel
I have an excel which has inputs to be entered in multiple sheets after which a pivot table in one of the sheets is to refreshed with filters as per the needs. This then updates another table which ...
- 1
0
votes
1
answer
26
views
Snowflake - reference variable as part of column name
I am new to Snowflake and trying to use a set variable to call a column name. Here's what I'm currently trying:
set macro = 'Aut_24';
Select *
from my_data1 a
left join mydata2 b on a.id = b.id
where ...
- 525
1
vote
2
answers
57
views
Issue in expanding variadic MACRO
I have the following piece of code in C which works flawlessly. I define NAME_LIST to facilitate the creation of NAMES_TABLE.
#include <stdio.h>
#include <stdint.h>
typedef enum {
...
- 639
1
vote
2
answers
70
views
Are enums appropriate for masks?
Since mask values are integers we can represent them in different ways. For example, as macros:
#define ENABLE_FEATURE_A 0x1
#define ENABLE_FEATURE_B 0x2
#define ENABLE_FEATURE_C 0x4
#define ...
- 4,099