macros

Why have my Visual Studio 2008 SP1 macros stropped working

I just cannot for the life of me figure out why my build event macro is no longer firing. Any ideas? Option Strict Off Option Explicit Off Imports System Imports EnvDTE Imports EnvDTE80 Imports EnvDTE90 Imports System.Diagnostics Public Module EnvironmentEvents Private Sub BuildEvents_OnBuildProjConfigDone(ByVal Project As Stri...

Visual Studio 2008 BuildEvent Macros not Firing

I added this well documented macro to MyMacros, Environment Events in VS 2008 Macros in order to cancel failed builds: Private Sub BuildEvents_OnBuildProjConfigDone(ByVal Project As String, ByVal ProjectConfig As String, ByVal Platform As String, ByVal SolutionConfig As String, ByVal Success As Boolean) Handles BuildEvents.OnBuildProjCo...

Are there any websites dedicated to the distribution of Visual Studio Macros?

Preferably a site that has macros searchable by Visual Studio version. ...

VBA Word Macro doesnt recognize whitespaces or wildcards

Hi guys, I have a VBA Word Macro that gets words from .txt list and color highlight them in a word .doc document. The problem is that the script ignores whitespaces and wildcards from the .txt list. I insert the word "wit" but it also changes words like witHIN , witCHE, etc. I tried inserting wildcards in the .txt file, like or usi...

Downside of this macro construct and possible alternatives

I recently saw some code using macros like #define CONTAINS(Class, Name)\ private:\ std::list<Class> m_##Name##s;\ public:\ void add_##Name(const Class& a_##Name) {\ m_##Name##s.push_back(a_##Name);\ }\ int get_##Name(int pos) {\ return m_##Name##s.at(pos);\ }\ ...

Is there a good way of setting C/C++ member variables from string representations? (introspection-lite)

I've got a struct with some members that I want to be able to get and set from a string. Given that C++ doesn't have any introspection I figure I need some creative solution with macros, the stringize operator and maybe boost::bind. I don't need full serialization or introspection, more an 'introspection-lite' I'd like to have somethin...

Combining wide string literal with string macro

I have a macro for a character string as follows: #define APPNAME "MyApp" Now I want to construct a wide string using this macro by doing something like: const wchar_t *AppProgID = APPNAME L".Document"; However, this generates a "concatenating mismatched strings" compilation error. Is there a way to convert the APPNAME macro to a ...

Help need Pls.... excel macro: compare and copy between worksheets

Heres mine problem If cell H of worksheet A = cell E of worksheet B (contain words) and If cell J of worksheet A = Cell H of worksheet B (contain numbers) and If cell K of worksheet A = cell I of worksheet B (contain numbers) then copy cell O of worksheet A to cell L of worksheet B (contain numbers) (put in ot...

what is (__ASSERT_VOID_CAST (0))?

From assert.h file in C: #define assert(expr) (__ASSERT_VOID_CAST (0)) I wonder what is (__ASSERT_VOID_CAST (0))? I try to find its implementation but could not find anywhere. ...

java and excel question

is it possible to create a java application that will import excel files . execute excel macros and give the output in java gui. please give any advice u can on creating such an application. i will start creating the application after your input ...

excel macro help needed... to match if e.g. 500 to -500 then..

in a if statement, how do i match a positive number with a negative one e.g. if 500 match with -500, cut and paste one solution i thought of is changing one of the column by *-1 before i do anything but... Is there anyway i could rephase the below if statement to match a positive cell and a negative cell? Dim sh1 As Worksheet, sh2 As...

Excel waiting for one macro to finish before calling another

I'm using Application run to call several macros in order like this. Sub Run_All_Macros() Application.Run ("Macro_1") Application.Run ("Macro_1") End Sub When I start Run_All_Macros, all the macros run in parallel. Is there a way to wait for the first macro to complete before the second is started? ...

eval during emacs lisp macro expansion

How can I fix the simple macro foo in (elisp)Eval During Expansion? None of the followings work: (defmacro foo1 (a) `(setq (eval ,a) t)) (defmacro foo2 (a) `(setq ,(eval a) t)) (defmacro foo3 (a) `(setq ,a t)) I really don't get what's said in (elisp)Eval During Expansion. I think if I got it, I'd have been able to fix the ma...

Disable user from closing outlook e-mail through VB code

Hi There, I have some vb code that brings up an e-mail when a user closes the workbook. I was wondering if there is something i can do to stop the user from closing the e-mail @ the x in top right coner and on file memnu, please find code below.... Private Sub Workbook_BeforeClose(Cancel As Boolean) repdate = Format(Date, "ddmmyyyy") ...

iMacro scripting and wird 3th tab

This macro should activate tabs in sequence from 1th to 5th and then again. But there is something wrong. When you open 5 tabs, activate first of them and run this code in iMacros firefox extension, the 3th tab never is activated: //imacros-js:showsteps no var x=1; while(true) { iimPlay("CODE:TAB T="+x+"\n"); alert(x); x=x+1; ...

Beginner at Microsoft Office Macros

Actually, I'm not a beginner. I know nothing about them, though I do have some programming background. This is the thing: I have a couple of Word documents and an Excel spreadsheets. The documents need to grab some data from the spreadsheet and then print. There needs to be one document per spreadsheet row, and they need to be printed a...

Removing macro in legacy code

I have a lot of legacy code using macro of the form: #define FXX(x) pField->GetValue(x) The macro forces variable pField be in the scope: ..... FIELD *pField = .... ..... int i = FXX(3); int j = FXX(5); Is there way to replace the macro, without touching user code? Since FXX(x) has a function invocation style, I thought about inl...

taking java method names as function arg in clojure

All, I want to create a function that takes a symbol representing a java method and applies it to some object: (user=> (defn f [m] (. "foo" (m))) When I execute this, I get a result much different from what I expect user=> (f 'getClass) java.lang.IllegalArgumentException: No matching method found: m for class java.lang.String (NO_SO...

Excel 2007 Sum variable length column.

I'm trying to make a macro to sum a variable length column. I've tried a few different things but they haven't worked. What I want to do is: If the active cell is cell B17, I'd like B17 to equal the sum of B1 to B16. Similarly if the active cell is cell D22, I'd like D22 to equal the sum of D1 to D21. So basically it is summing all the...

Is there easy way to do macro to string map?

For example,in Windows,if I want to make the error message of gethostbyname meaningful,I would need to manually map the error code to message, as follows, #include <stdio.h> #include <winsock2.h> #pragma comment(lib, "ws2_32.lib") int main(void) { struct hostent *host; WSAData wsaData; int errcode; if (WSAStartup(MAKEWORD(2, 2), &...