While looking at the syntax-case section in R6RS, I saw the keyword make-variable-transformer, described as an identifier macro. The example given is very minimal, and I am not groking why it is necessary, or what use-cases require it. Finding additional examples of its use is also proving difficult. Presumably it makes some form of synt...
We, like most companies enforce a branding policy on our outgoing literature. This involves using different paper types etc, so we need to control the print process using a shared set of VBA routines stored in addin templates. One of the main problems we face is the nuances (such as hard coded tray enumerations) between different models'...
Excel macros don't seem to allow the use of "undo" after running them. Is there any way to bake undo functionality into a VBA macro in Excel? ...
Can a macro be written in Scheme (with define-syntax, for example) which will take expressions like this: (op a b c d e f g h i j) And yield expressions like this as output? (op (op (op (op (op (op (op (op (op a b) c) d) e) f) g) h) i) j) Of course, for arbitrary lengths. I can't think of a way to do it, given some template like th...
Hello, I'm trying to use VBA to write a formula into a cell in Excel. My problem is that when I use a semicolon (;) in my formula I get an error 1004. My macro is the following : Sub Jours_ouvres() Dim Feuille_Document As String Feuille_Document = "DOCUMENT" Application.Worksheets(Feuille_Document).Range("F2").Formula ...
For statistical reasons, I want an extensive analysis from a dataset. I already have a function that exports the data to Excel, but I have raw data that way; 500 lines, 35 columns, heaps of text sometimes... Is it possible to include a macro into a function so that the excelfile is readymade to be analyzed? I am using ASP, Javascript,...
I am frustrated trying to program macros for Visual Studio (using VS 2008, Version 9.0.30729.1 SP, with all updates). In the Macro Explorer, I can go to Micorsoft's samples/VSEditor and add a Subroutine that behaves as I desire. But I can't seem to make it work anywhere else. In particular, in the MyMacros area in Macro Explorer. Det...
I'm looking for a macro which can be run to select a consistent range of cells so that I can easily copy them to another spreadsheet. The range would be F3:BJ3. Thanks for your help. nlh ...
Hi I have a problem I have got stuck on. I want to export my Access table to an Excel file, currently, I am doing that using DoCmd.TransferSpreadsheet but I want some kind of formatting to be done on the exported data. Can I format that data I am sending to Excel or do I have to write a macro in Excel that will format that data after ...
I am a looking for a good text editor with a simple and powerful macro-recording functionality. Edit: after trying each and every option suggested below, I am still using Textpad on Windows, and vim on Linux (jEdit was a good contender as a macro-capable texteditor on Linux, but the excessive startup time, due to Java, is a no-go for me...
I would like to write a macro for Notepad++ which should replace char1, char2, char3 with char4, char5, char6, respectively. Thanks ...
I'm trying to use an excel VB macro to download excel files from a membership password-protected site. I am using the "InternetExplorer" object to open a browser window, log-in and browse to the correct page, then scanning for the links I want in the page. Using the Workbooks.Open(URLstring) doesn't work because Excel isn't logged. Inste...
Are C-style macro names subject to the same naming rules as identifiers? After a compiler upgrade, it is now emitting this warning for a legacy application: warning #3649-D: white space is required between the macro name "CHAR_" and its replacement text #define CHAR_& 38 This line of code is defining an ASCII value c...
I am trying to use Office Automation to open a word document. The problem is that I would like to open it without invoking the Document_Open macro. Is there a way to do this? The relevant line below is wordApp.Documents.Open() Imports Microsoft.Office.Interop Public Class WordFunctions Public Shared Function ConvertToDoc(ByVal fil...
I have a job to enter survey results (in paper form) to excel. I've never written any macro in Office :( Here I what I basically need: I have predefined columns (|A|B|...|AG|AH|) All surveys are grouped into groups. All surveys from same group have few (like predefined) same columns. It's always same columns that 'define' group All ot...
Hey, I am trying to write a command to print todays date on the front page of a report using the textsc command, but the today date capitalize December. Any help will be appreciated. ...
It USED to be the case in Office 2003 that you could find "macros" and -- IIRC -- you had a "record macro" option. But, in PowerPoint 2007, under View->Macros, you get a macro box. None of the options are "record". If you put in a name, you can select "create", but that takes you to the VB editor. If you edit the slide manually, it does...
Just as the title says, I see a lot of editors touting macro recording as a feature but cannot find a way to take advantage of these functions myself. So what can you use it for? The type where you can record mouse movement and/or keystrokes? Is it really that helpful to people out there? Specifically, I deal with Eclipse which has a...
Below was a macro provided, but I need to know how to do some adjustments to save it to the file name fixed to a specific worksheet, and specific cell with dates( eg. worksheet name is: AA on cell "B2" with ZZ ). So the filename will be ZZ AA 23122008.csv Thanks in advance. Public Sub SaveWorksheetsAsCsv() Dim WS As Excel.Worksheet D...
I have a macro that looks like this: #define coutError if (VERBOSITY_SETTING >= VERBOSITY_ERROR) ods() where ods() is a class that behaves similarly to cout, and VERBOSITY_SETTING is a global variable. There are a few of these for different verbosity settings, and it allows the code to look something like this: if (someErrorCon...