macros

How can I copy Data from one sheet to another Sheet in Excel 07 Through Macro

Hello, I am using MS Office 2007. Please let me know that how can I copy whole data from sheet one to sheet two. I want to copy the whole data from row 5 to onward in sheet two. The whole scenrio is given below in detail. Sheet one: Copy the data from column B and Row 3 Sheet Two: Paste the Copied Data in Column B and Row 3 Shee...

C Macro for minimum of two numbers

I want to make a simple macro with #define for returning the smaller of two numbers. How can i do this in C ? Suggest some ideas, and see if you can make it more obfuscated too. ...

Do I lose the benefits of macro recording if I develop Excel apps in Visual Studio?

I've written lots of Excel macros in the past using the following development process: Record a macro. Open the VBA editor. Edit the macro. I'm now experimenting with a Visual Studio 2008 "Excel 2007 Add-In" project (C#), and I'm wondering if I will have to give up this development process. Questions: I know I can still record mac...

Declaring local variables in assembly

Is it possible to allocate locally-scoped memory in assembly? For example, consider the following (completely contrived) situation: I have two macros, one of which is dependent on the other. The first is: minimum MACRO dest, num1, num2 ; Finds the minimum of two unsigned numbers, stores the result in dest And the second is: tripMin...

System.Reflection.TargetInvocationException when running excel macro from C#

Hi. I’m trying to run a excel macro from my C# code, but I'm getting the following error when trying to execute the code. The code is: static void Main(string[] args) { object oMissing = System.Reflection.Missing.Value; Excel.ApplicationClass oExcel = new Excel.ApplicationClass(); oExcel....

How to automatically insert code for an Xcode video demo

I've been watching some of the WWDC 2009 videos which include some video demos in Xcode. The presenters are using some sort of macro or script bound to a keyboard shortcut to automatically insert some pre-prepared code at the current caret location. Each time they press the key, the next prepared snippet is inserted. Does anybody know h...

Visual Studio Macros: Loop through Selection, add .Append(" and ") to each line in selection

Found this: Sub SurroundWithAppendTag() DTE.ActiveDocument.Selection.Text = ".Append(""" + DTE.ActiveDocument.Selection.Text + """)" End Sub But I can't seem to figure out how to loop through each line of text in the selection. Any thoughts? ...

C++ Macro Arithmetric

Possible Duplicate: c++ var-arg macro, NOT template I have to do with Macros (it's macros calling macros; so templates are out of the question). Here's what I want: foo(3, a, b1, c1) --> foo1(a, b1, c1); foo(5, a, b1, c1, b2, c2) -> foo2(a, b1, c1, b2, c2); foo(7, a, b1, c1, b2, c2, b3, c3) -> foo3(a, b1, c1, b2, c2, b3, c3)...

How can I refactor this to use an inline function or template instead of a macro?

Hello, everyone :) I have a useful macro here: #include <algorithm> #include <vector> #include <string> #include <boost/algorithm/string.hpp> #include <Windows.h> namespace Path { bool Exists(const std::wstring& path) { DWORD result = GetFileAttributesW(path.c_str()); return result != INVALID_FILE_ATTRIBUTES; } // THIS IS TH...

cmake command syntax question

I require the syntax of a CMAKE macro that generates .cc and .h files from a tool like lex/yacc. Could someone please show me the syntax for the following contrived example: say I have a file y.cc that depends on x.cc and x.h, the two files mentioned are generated by tool z_tool from file x.z. What would the syntax for this be ? Fo...

Figures occurring after ^ and _ macros (was: LaTeX limitation?)

Hi, I've hit an annoying problem in LaTeX. I've got a tex file of about 1000 lines. I've already got a few figures, but when I try to add another figure, It barfs with: ! Undefined control sequence. <argument> ... \sf@size \z@ \selectfont \@currbox l.937 \begin{figure}[t] If I move the figure to other parts of the file, I can get s...

How to implement lambda as a function called "lambda" in Clojure?

I'd like to be able to define lambdas using common Lisp syntax, in Clojure. For example: (lambda (myarg) (some-functions-that-refer-to myarg)) This needs to result in the same as: #(some-functions-that-refer-to %) In my case, I know I'll always have exactly one arg, so perhaps that simplifies things. (But it can be called anythin...

Excel Macro to concatenate

Need help in creating an Excel Macro.I have an Excel sheet.The Excel sheet is not consistent. I am planning to make it uniform and structured. Eg. A B C D 1 test tester tester 2 hai test 3 Bye test tested 4 GN test tested Fine A B ...

C preprocessor at run time?

Hi guys, I want to do a Token concatenation, but I want to do this with the content of a variable, not its name. like this. #define call_function(fun, number) fun##_##number () while (i < 10 ) { call_function(fun, i); } but I give fun_number (), I want to give fun_1, fun_2, and so on... how to do it? About function pointers. I'...

Does anyone have a list of the Delphi IDE macros?

I know about $(Delphi) and $EDNAME but after much seaching I cant find a list of these and any others for use in libary path names etc. Can anyone oblige please? ...

c++ macros with memory?

Is it possible to define macros write_foo(A); and read_foo(); so that: WRITE_FOO(hello); code_block_1; READ_FOO(); code_block_2; READ_FOO(); WRITE_FOO(world); code_block_3; READ_FOO(); code_block_4; READ_FOO(); expands into: code_block_1; hello; code_block_2; hello; code_boock_3; world; code_block_4; world; ? Thanks!...

Visual Studio - "attach to particular instance of the process" macro

I guess prety much everyone who does a lot of debugging have a handy macro in Visual Studio (with shortcut to it on a toolbar) which when called automatically attaches to a particular process (identified by name). it saves a lot of time rather than clicking "Debug" -> "Attach to the process ...", but it only works if one is running a si...

Getting Visual Studio macros in console app

In a Visual Studio extension, you can get the default include paths for all projects with C# code like: String dirs = dte2.get_Properties("Projects", "VCDirectories"); where dte2 is the Visual Studio application object. Usually, those directories contain macros like $(INCLUDE). You can expand those macros by looking at dte2.Solution...

Help writing a complex macro

Hi all, I am working with a unit-testing suite that hijacks function calls and tests expected output values. The normal layout requires one block of unit-testing code for each expected value. Since my code makes use of a large number of enums, I would like to automate the automated-testing with some for loop / macro magic, and I'm look...

Excel macro, to copy and paste a cell value based on another cell value?

Hi I shall try to explain clearly what I need to be able to do, here goes: I have an Excel spread sheet 1 with postcodes in column A and a number in column B. I need to create a macro/formula so that it will see the number (i.e 3) and copy and paste the postcode that number of times into sheet 2 column a underneath each other. I need to...