Hello Everyone : I have been wrestling with this since yesterday but gotten nowhere,was hoping someone could show me the light I have this workbook in which I have the following 2 requirements : 1)if the user enters a value(which is a date) in column A : the value of '2' is automatically filled in column C 2) a- if the user enters ...
I need a macro to look at the list of data below, provide a number of instances it appears and sum the value of each of them. I know a pivot table or series of forumlas could work but i'm doing this for a coworker and it has to be a 'one click here' kinda deal. The data is as follows. A B Smith 200.00 Dean 100.00 Smith 1...
Hi folks, is it possible to have a macro on an SSRS Report that is exported in Excel format ? We need to rename the sheet based on content of the report a user is viewing. For ex: 'SalesReport' shows data for California - so sheet name might be 'California sales'; 'SalesReport' shows data for New York - so sheet name might be 'New York...
Hi, I've got a Word document that contains an AutoOpen macro. It works fine until I upload it to out intranet for people to download. When some users opens it from the intranet, it opens an embedded instance of word within IE, the doucment opens but the AutoOpen does not run. If they download the document, then open it, it work correctl...
I'm trying to call an Excel macro that's in another workbook. It's a sheet-specific macro, but the syntax given by Microsoft documentation and researching on the web, only gives a way to access a macro by workbook only. That syntax is: Application.Run ("testworkbook.xls!macroname") What I need to do is have a sheet reference in ther...
Does Java have anything like any of the following macros a way to iterate over all private fields something like smalltalk symbols-ie something for quick comparison of static strings? note I'm trying to emulate enums for blackckbery (and a little worried about speed for a simple string-> int dictionary ) which I'm fairly sure doesn...
I'm looking for a simple macro to specify cells as being of type "time" and typing only numbers (for example "955") will format that (and recognise as) "hh:mm" time. In other words, by typing "955", the cell would interpret to "09:55", whereas all I can have it do right now is interpret to "1902-08-12 00:00:00" (most likely 955 is the d...
Is there a way to pass std::map<std::string, float> as an argument to a macro? (the problem is that the "," is used by the macro to split std::map<std::string and float> as separate arguments. I would like to avoid this. ...
Not going into detail on why I want to do this, I need to execute a macro inside Visual Studio as part of our msbuild script. The macro performs some actions in the IDE and then calls Application.Quit() to close the IDE. Do you know if there is a way to make devenv.exe return some error code or anything really that could let msbuild kno...
Noob xcoder here and for some reason i cannot get the text macros to expand within xcode. For example if i type ifelse and then hit ^. it doesnt automatically expand the macro?? Likewise if i type fo and then ^. it will complete it to either for,fori etc, and will also pop up those options if i hit escape however i cannot get it to expan...
I have a piece of code which compiles without problems with x86 gcc 4.4.1 but fails with blackfin gcc 4.1.2 with many "expected unqualified-id before numeric constant" errors. I see that there are some variable names that clash with some predefined macros. Is it possible to see defined macros at a certain line of a cpp file? ...
What error is thrown when macro and function conflict in C arises? Is it a macro processor error or does this error occur due to some language violation? For example, in this code: #include <stdio.h> #define MAX(i, j) (i>j)? i : j int MAX(int i, int j){ return (i>j) ? i : j; } int main(){ int max = MAX(5, 7); printf("%d",max); ...
Hello, I have the following code : #define LIMIT_DATE \"01-03-2010\" #ifdef LIMIT_DATE #if _MSC_VER #pragma message ("Warning : this release will expire on " LIMIT_DATE) #elif __GNUC__ #warning ("Warning : this release will expire on " LIMIT_DATE) #endif #endif The problem is that LIMIT_DATE is not eval...
Given: #define f(x, y) (x+y) #define g(x, y) (x*y) #define A 1, 2 #define B 2, 3 int main() { int a = f(A); int b = g(A); int c = f(B); int d = g(B); } which does not work, how can I make it work? The basic idea is that I have one list of arguments that I want to pass to two different macros, without repeating the list of lo...
Is there a way to do check for numerical equality in macros? I want to do somethign like #define choice 3 #if choice == 3 .... #endif #if choice == 4 ... #endif Does C macros have support for thigns like this? ...
Is it possible to write a C macro that returns the length of its arguments? I want something that does: foo(1) -> 1 foo(cat, dog) -> 2 foo(red, green, blue) -> 3 Even better if this macro can be defined in such a way that it works with ## so that foo(1) -> bar1(1) foo(cat, dog) -> bar2(cat, dog) foo(red, green, blue) -> car3(red, gr...
In our application (older parts) we alter calls to malloc (and realloc) and free so our own implementations are called instead of the standard runtime ones, e.g. #define malloc(s) OurMalloc(s) #define free(p) OurFree(p) This works quite good (for newer C++ code we simply implement global new and delete operators, so the C++ solution...
Hello, I read this piece of macro(C code) and was confused in decoding it to know what it defines. What does it define? #define sram (*((unsigned char (*)[1]) 0)) -AD ...
I have some C++ code that includes a method called CreateDirectory(). Previously the code only used STL and Boost, but I recently had to include <windows.h> so I could look-up CSIDL_LOCAL_APPDATA. Now, this code: filesystem.CreateDirectory(p->Pathname()); // Actually create it... No longer compiles: error C2039: 'CreateDirectoryA'...
I would like to create a Resharper Live Template that changes all spaces to underscores ind my "fact" Live template variable $testname$: <Fact()> _ Public Sub $testnames$() ' Arrange $END$ ' Act ' Assert End Sub I have this: [Macro("applyRegex", ShortDescription = "Run on {#0:variable}", LongDescription = "")] ...