Odd phenomenon started six to nine months ago. Many of my "clients" (non-technical co-workers) create/edit documents for other clients. Part of my job is to minimize things that make them hate technology :-) One of those things is puzzling me. Some of the Word documents, when I open them, warn me that they contain macros. But when I...
I have the below vba macro to Export the selected cells into a text file. The problem seems to be the delimiter. I need everything to be in an exact position. I have each column's width set to the correct width(9 for 9 like SSN) and I have the cells font as Courier New(9pt) in an Excel Sheet. When I run this it comes out REALLY c...
I've noticed that sometimes, C macros are written as something like this: #define foo(bar) ({ ++bar; }) After some experimentation, I've found that: ({}); will compile, but do nothing. (As expected.) Leaving the ; off will cause a syntax error. A side effect of this is ensuring that foo() looks like a function in your code. (Althoug...
Hello, Please help me its emergency, i am looking for a macro code to compare two excel files if the data matches it should copy the info from one file to another new file. The comparision is like for eg: A Column (Name) and B Column( ID) in one sheet matches with the A column(EName) and B Column(EId) then it should take the entire ro...
I have a similar question to this one: http://stackoverflow.com/questions/621862/merge-the-contents-of-2-cells-into-another-3rd-cell-using-vba-in-excel But I want to combine a range of cells within a column, eg A2:A50. Sometimes I have over 300 cells to be combined into one. Values are text. Is there any way to modify this macro so tha...
Hello, Are multi-line macros supported(compilable) in gcc version 3.2.4. I am trying to build my source which has multi-line macros on a linux host using above mentioned gcc version. I get compilation error at the macro, which is multiline. #define YYCOPY(To, From, Count) \ do \ { ...
Is there a one line macro definition to determine the endianness of the machine. I am using the following code but converting it to macro would be too long. unsigned char test_endian( void ) { int test_var = 1; unsigned char test_endian* = (unsigned char*)&test_var; return (test_endian[0] == NULL); } ...
I have a calculator built in Excel 2003 in which you select options from a drop-down menu, data is then gathered and calculated returning your total cost to produce that package of items. What I'd like is to cycle through all the combinations of this drop-down and automatically return the total unit cost to another cell. I have already...
I have this line of code in my macro: ActiveSheet.ChartObjects("Chart 6").Activate When I open the file and run the macro on a non-English version of Excel, this code breaks. For example on the Japanese system I tested it on, I would need to change the previous line to: ActiveSheet.ChartObjects("グラフ 6").Activate (グラフ means Chart in...
Hi all, I have a spreadsheet with email addresses (column A) I need to write a macro/VBScript function to fill columns B to L with numbers 1 to 11 respectively i.e. [email protected] 1 2 3 4 5 6 7 8 9 10 11 Could someone help me achieve this please? TIA. ...
Hi guys.. I've just started playing with macros in IntelliJ. I recorded several then played back until I decided to add keymap shortcuts to my macros. I went to Settings and pressed Alt+C to add a new child map because I couldn't edit the parent. Since then the macros are no longer accessible from the Tools menu, not to mention that the...
I have an Excel spreadsheet template. It contains pivot tables having criteria that specify the content of the spreadsheet. I need to amend that criteria programatically from a macro running in a separate spreadsheet so that the template will feature different content. What coding would be appropriate to achieve this ...
Hi, I'm trying to write a macro and I have the 2nd half done (tile windows showing specific sheets) but not sure how to do the first half. There are some sheets that when displayed I would like to look at two other sheets at the same time (multiple window tiling). This is easy to set up manually, but I'd like it to happen automaticall...
Hi, I have three questions about VBA and controlling/manipulating new windows. I have several sheets set up. Master | Worksheet1 | Worksheet2 | Notes | Work Orders | Contact Info 1) I have WorkSheet_Activate functions set up on Notes, Work Orders, Contact Info that open up all three sheets in seperate windows and arrange them vert...
With C/C++ macros it's quite easy to generated long constructs automatically. For example, if I want a huge set of methods to not ever throw exceptions (a must for COM-exposed methods) I can do something like this: #define BEGIN_COM_METHOD\ try{ #define END_COM_METHOD\ return S_OK;\ } catch( exception& ) {\ // set I...
I'm writing a macro to automate the process of attaching to the IIS worker process (w3wp.exe, Windows Server 2k8) from Visual Studio. The trouble is that I often two app pools running at any given time, one in x64 mode and one in x86 mode. This means there are two processes called w3wp.exe running at any given time, and the only way to d...
Simple question for which I could not find answer on the net. In variadic argument macros, how to find the number of arguments? I am okay with boost preprocessor, if it has the solution. If it makes a difference, I am trying to convert variable number of macro arguments to boost preprocessor sequence, list, or array for further reproce...
I have a huge solution with many projects, I would like to set a particular propertie (for example warning level) for each of the projects. Can this be done with a macro? ...
Is there a macro that tells you what encoding C++ is using for its wchar_t type? I am currently stuck to GNU and clang. I am guessing UTF32 because my wchar_t has a size of 4 bytes. Although it could be UTF-16, it also uses 4 bytes for some code-points. But then there is still the problem of UCS-4 or UTF-32LE or UTF-32BE. Any help/expe...
I'm using Excel 2007. I'd like to add some buttons to the quick access toolbar for macros. And because the macros are specific to the workbook, I want the buttons to appear only when the workbook is open. I clicked the office button -> Excel options -> customize. I found the macros in the left column, and chose "For (workbook name)" in ...