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...
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.
...
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...
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...
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....
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...
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?
...
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)...
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...
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...
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...
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...
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 ...
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'...
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?
...
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!...
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...
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...
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...
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...