Below is a macro to save multiple sheets to different csv files BUT it keeps renaming and saving the original workbook, how to stop this. Private Sub CommandButton1_Click() Dim WS As Excel.Worksheet Dim SaveToDirectory As String Dim CurrentWorkbook As String Dim CurrentFormat As Long Dim myName As String myName = myName & Application....
I am new to Excel macros. I have some columns with headings scattered in many sheets. I would like to type a heading in some column which has the cursor and have the column with that heading copy-pasted to the column with the cursor. Is it possible to do this by recording a macro? How? If not, how do I do it programmatically? ...
I have been writing a VBA macro that opens a HTML document within Excel (in order to perform various calculations on it). Excel will search for the HTML document within the current folder. If it can't find it there it will produce a file open box where the user can browse to the location of the HTML document manually. All good so far....
Question: Is anyone out there familiar enough with Komodo Edit to shed some light on this macro? I need to figure out how to do buffer text selection in a macro when it is invoked via the tool panel. Problem: I have a very simple macro in Komodo Edit javascript that works as expected, but only when invoked via a custom keybinding. If th...
I am wondering how to do (or where to find documentation) on these basic macro and snippet operations in Komodo Edit. 1) FILE/IO: write a string to a temporary file from within a komodo javascript macro 2) FILE/IO: read the content of a text file into a string within a komodo javascript macro 3) INCLUDES: cross-reference local javascr...
Is there a way to include an entire text file as a string in a C program at compile-time? something like: file.txt: This is a little text file main.c: #include <stdio.h> int main(void) { #blackmagicinclude("file.txt", content) /* equiv: char[] content = "This is\na little\ntext file"; */ printf("%s", content); } o...
In excel workbook I am trying to copy data from sheet1 to sheet2 with a condition, IF((Sheet1!B2:B80=Sheet2!A2:A80),Sheet2!D2) i am not getting the result.please help me solve this. I am trying to copy from sheet1 to sheet2 with a condition if the the value in sheet 1,column B is equal to the value in sheet2 column A the value in colum...
Hello Everyone, I'm very new to creating macros and programming in general. I have a worksheet of 38 tabs. 31 tabs are for the days of the month. I would like to create a macro that will prompt users with a warning message any time "MCO" is selected in column N for each of these 31 tabs. Is that possible? Thanks ...
Hi, I'm new to VBA and have been throwing together a small macro application for the Office. We've got about 80 users on essentially identical PC setups, and it will be accessed by all but a few users. I've been playing around with some automation of accessing web pages using the Web Services references, and I've also loaded the Micr...
Having implemented CLogClass to make decent logging I also defined macro, but it works only with one parameter... class CLogClass { public: static void DoLog(LPCTSTR sMessage, ...); }; #define DebugLog(sMessage, x) ClogClass::DoLog(__FILE__, __LINE__, sMessage, x) Well, it fails when called with more than 2 parameters :( ... I...
Hello, I have the source code of an application written in C++ and I just want to comment something using: #ifdef 0 ... #endif And I get this error error: macro names must be identifiers Why is this happening this?. Thanks ...
HI to all, Could anyone guide me in creating an Outlook Macro that does the following: What I would like macro to do is to check, in a specific E-Mail folder, if there are 3 or more e-mails with the same word in the subject or text, and if so, an alert would appeared, or something like that. Thank you very much Max ...
Hi im learning LISP and well, all day i program php for a living, so i was messing around with php.net and found the eval function... so i started playing around! I would love to know more about how to use eval to do crazy stuff, i know you can make functions with this and everything... but i wanted to ask why the next code wont work: ...
When my ASP.NET application crashes (when it shows the default exception page), I'd like to be able to click on a line of the call stack in the browser and Visual Studio would open the code file at the given line. Do you think it's possible ? Maybe with a macro/add-in ? ...
Calling all C macro gurus... Is there any way to write a C macro that will replace something like this: my_var = 5; with this: setVar(&my_var, 5); In other words, can I write a C macro that will override assignments for a specific variable (in the above example, my_var) and instead pass it to a function whose job it is to set that...
Hi, with (x)emacs, how could I run the 'compile' command without separately pressing enter to accept the default command? (I can bind the 'compile' to a key but I'd like the whole thing to happen without separate pressing of enter) Of course, similar behaviour with some else command would also be ok. ...
When opening a word document a macro should start and it did for a while. But the I save the document when the macro was activated and after that I get the error message "The macros in this project have been disabled" when I open the document. I have tried different security settings but without success. Does anybody have any idea what...
I've been working on an alternative compiler front-end for Python where all syntax is parsed via macros. I'm finally to the point with its development that I can start work on a superset of the Python language where macros are an integral component. My problem is that I can't come up with a pythonic macro definition syntax. I've poste...
I know something about MACROS. I don't mean the ASSEMBLY language kind. I am talking about those programs that you can use perform repetitions actions on another program. I am talking about those programs that you can use to record a series of events on your computer, like, mouse movements and button clicks and then you can play them bac...
I have some code that looks like this: someFunc(value) { switch(value){ case 1: case 2: case 3: #ifdef SOMEMACRO case 4: case 5: #endif return TRUE; } return FALSE; } SOMEMACRO is defined, and let's say the value is 4.. Why does case 4 and 5 get skipped and FALSE is returned ...