A macro in computer science is a rule or pattern that specifies how a certain input sequence should be mapped to a certain output sequence according to defined rules and procedures. Consider using [vba] tag instead of this one if the question concerns a Microsoft Office product. This helps the ...

learn more… | top users | synonyms (1)

0
votes
1answer
2k views

Excel Import Dialog that prompts for location of file

Is it possible to have an Excel Macro stop and prompt for the location of file to be imported? I've created several macros for importing text files but the imported file must always exist in the ...
0
votes
1answer
277 views

Auto date calculator in excel based on different conditions

I have an excel sheet with an auto date calculator function linked to each cells. I want this function to work based on different condition. For eg: (lets say there are two conditions A and B)for ...
0
votes
1answer
1k views

Open an Access database with scripting disabled (macros and VBA)

Suppose you want to examine the contents of an untrusted Access database. It seems there should be a way to open it in Access with macros and VBA disabled. Searching around the web, I've found ...
3
votes
1answer
568 views

Macro Find: Is there a macro to Format a Word Document as if it were being created in VBA?

I have a lots of code (for Excel) in VBA and would like to transfer a copy of it into a Word document. Does anyone know of a macro that will format the Word document to treat the code as if it were ...
3
votes
2answers
1k views

Remapping key combinations (custom macros in linux)

I'm not sure at which layer this functionality would have to exist, so I'm just tagging this for my own stack. In my specific case, I'd really like to map the [Function Key]-J key combination to the ...
1
vote
1answer
293 views

Excel userforms

I have developed a macro that does a whole bunch of things for me based on a few things. (Importing files). The file names are dated dd_mm_yyyy and right now I enter them into a sheet where the macro ...
2
votes
1answer
2k views

In Excel, I pasted in a bunch of URLs, but they aren't live links — how do I bulk convert them to live links?

In Excel, I pasted in a bunch of URL's into a column. However, they aren't live links after pasting. How do I bulk convert them all to live links swiftly?
2
votes
1answer
990 views

Macro for helping superscript last character of many rows in a single column

I'm adding footnotes (always adding footnotes) to a table and I would really like to be able to automate the repetitive nature of making my symbols superscript. Currently it’s: >enter cell>highlight ...
2
votes
1answer
479 views

Opening doc files as docx

I am using an application that currently can't handle Word 2007 or 2010 files. The application treats them as .doc files. This means when opening them from the application, Word treats it as .doc ...
0
votes
1answer
4k views

How to send an HTML Email using Microsoft Access 2007

I want to create a Access 2007 form / report which will send a HTML mail. There will be a "button". When someone click on that button then an Outlook 2007's "New Email" window will be opened with a "...
3
votes
2answers
15k views

Custom macro buttons without writing code?

I just upgraded from Word 2003 to Word 2010. I'm mostly OK with the Ribbon, except that I've spent years maintaining and enlarging several custom toolbars full of buttons for extremely specialized ...
2
votes
1answer
827 views

How do I create a macro that copies one row down based on the # of records in another sheet?

Using Access I export/create a daily Excel spreadsheet which has an increasing number of records/rows. I'd like to then open a master Excel sheet, which: Opens the exported sheet. Counts the number ...
2
votes
2answers
90 views

Is there a software that can perform recorded user actions at a later date?

Is there a software that is able to record and perform the actions (clicks, entering of text, etc) that can be replayed at a later date. For example, I often place downloaded software into the same ...
10
votes
4answers
2k views

Is there any way to save a keyboard macro in bash?

I would like to permanently save a keyboard macro that I've recorded using C-x ( and C-x ). Is there an easy way to "see the source" for my newly recorded macro so that I can bind it to a keyboard ...
3
votes
2answers
2k views

Subscripts and superscripts in Excel

I have an XL sheet with chemical formulae - which is basically just letters with numeric subscripts and superscripts. I can save as an html page and get the <sub> and <sup> html elements, ...
7
votes
2answers
5k views

VBA Runtime error 1004: Method 'OpenText' of object 'Workbooks' failed

After an upgrade to Excel 2010 (from 2003), a script used for standardizing data from Access import has stopped working. It returns an error: "Run-time error '1004': Method 'OpenText' of object '...
1
vote
1answer
2k views

How to to fill a single column of cells with a number that increments when it finds a cell that spans multiple columns? (Screenshot)

I'm trying to organize some data that was dumped out of a proprietary system into something I can use. In column A, I want to put a 'group by' number. It dumps this long, spanning row out that ...
0
votes
1answer
4k views

macro to download selected messages attachments - Problem about downloaded files count

I changed some codes for getting selected messages attachments to my hard drive like below : Public Sub SaveAttachments() Dim objOL As Outlook.Application Dim objMsg As Outlook.MailItem 'Object Dim ...
4
votes
2answers
366 views

Keyboard macro software

I'm looking for a super-simple free keyboard macro program. Does not need to "automate" anything just send some keystrokes when a key is pressed. Ok, not just letters some arrows and enters.
4
votes
1answer
2k views

Excel 2010 Macro “Command could not be completed by using the range specified”

Running a macro on an Excel spreadsheet, I get the Run-time error: 1004 Command could not be completed by using the range specified. Selected Debug and the highlighted code is: Selection....
1
vote
1answer
197 views

Repeating a Wintask macro over and over and over

I'm using WinTask to run a macro for something. I need it to start over as soon as it finished. I just downloaded it a couple of minutes ago so I really only know the basics. I only need it for one ...
1
vote
2answers
516 views

Notepad++ macro problem: inserting extra characters

I sometimes run into a problem when playing back Notepad++ macros in that it inserts extra characters between all the letters, e.g. ”. Anyone else seeing this?
1
vote
1answer
5k views

Run macro upon opening Excel 2007

I need help setting up macro that runs each time I load Excel 2007. I have tried following a few walkthroughs on the web but they end up not autolaunching the macro.
5
votes
1answer
175 views

How do I Stop the Excel Macro Recorder from Auto-Wrapping Lines of Code?

When recording a macro in Excel (2007) the recorder will often wrap the lines of code if they get to long by using a "_" character. This is all well and good except that there is apparently a hard ...
0
votes
1answer
6k views

Excel cannot open the file “filename.xlsm” because the file format or file extension is not valid?

In Excel 2007, I get this error when I try to run a script a friend posted to the web. I have heard of no one else having trouble. Any ideas what might be going on here?
2
votes
3answers
939 views

How can I break a paragraph into sentences with Vim?

By breaking into sentences I mean that each new sentence should start with a new line. How to repeat )i<CR><Esc> to the end of the paragraph }? (<CR> = Enter) If I make a macro )i&...
0
votes
1answer
938 views

How do I enable macros when they are disabled for security reasons?

I upgraded to Office 2010. I have some Excel spreadsheets that contain macros that I would like to run. When I save the workbook as an excel macro enabled workbook it doesn't work. I get an error ...
4
votes
2answers
3k views

tool to record windows action?

My boss give me a job to record some hundreds script manually, it would break my fingers...is there any free tool for recording and playback windows' mouse and keyboard action?? I am on win xp. The ...
5
votes
2answers
3k views

Why notepad++ plugins don't work in macro?

Why don't Notepad++ plugins work in a macro? For example: Manual run plugin - Converter -> "ASCII -> HEX" AAAA 4141414120 BBBB 42424242 CCCC 43434343 Runned as recorded macro AAAA 4[nul][dc4][...
0
votes
2answers
4k views

Desktop Macro recorder Windows

I've heard of some software that let you "record" the actions you do in desktop (based on images), so if you do something and "record it", then you execute it and what you recorded can be reproduced ...
7
votes
3answers
2k views

vim macro to convert CamelCase to lowercase_with_underscores

Is there a vim macro to convert CamelCase to lowercase_with_underscores and vice versa?
1
vote
1answer
868 views

Check for trailing \ in string returned from msoFileDialogFolderPicker, Excel VBA

I am using the msoFileDialogFolderPicker to return a path when a user wants to deposit a report in a specific folder. A custom form (ufSelRepType) shows up in the macro in cases where the default ...
0
votes
1answer
2k views

Excel VBA MsgBox handling checking for existing file

I'm not sure how to handle the output from a MsgBox in order to allow my macro to continue processing given differing situations. This macro creates a daily report file with an output name of ...
0
votes
1answer
3k views

In Excel VBA Macro does ActiveWindow.Scroll change ActiveCell at all

I'm cleaning up and extending some excel VBA macros (written and currently running in Excel 2003), and I have a question about how far I can go in cleaning up without modifying the output. There are ...
2
votes
5answers
17k views

Subscript/Superscript Hotkey for Excel 2010 Macro?

Background In Excel 2010, for some ridiculous reason, there is no built-in hotkey (or even a button on the toolbar) for subscripting/superscripting text within a text cell. You can, however, ...
1
vote
2answers
1k views

How do I automate a set of VIM commands that I use all the time?

I'm running some text files written in Markdown through Pandoc to get html, but it renders the tags strangely with weird line breaks and white space in tags, so I've been running a few sed commands in ...
1
vote
3answers
28k views

Excel VBA Macro Sub or Function not defined

I used the macro recorder to generate a macro in Excel 2007. When I try to the run the macro, it tells me: When I click Ok the definition of the macro gets highlighted. I'm really confused ...
1
vote
2answers
1k views

AutoHotKey with better sleep awareness

I know of AutoHotKey and I know of AutoScriptWriter but my issue comes down to timing. I'm trying to reproduce user input into an application but the application sometimes has a loading time for some ...
1
vote
2answers
4k views

How to record a “macro” that saves web pages as PDF in OSX

I frequently save pages as PDF from Chrome on OSX. The page is apple-P then click the PDF button and the "Save as PDF.." menu item. I always use the pre-filled filename and save in the default ...
3
votes
5answers
24k views

How can I record a macro on the fly with Black Widow Ultimate?

I believe that Black Widow Ultimate can record macros on the fly. However, they are recorded with a delay in the time you take to press the keystrokes by default. Is it, in fact, possible to do this ...
0
votes
1answer
144 views

How to copy a file to network folder under OS X and Word 2004/2011

I am using Mac OS X. I have Word 2004 / Word 2011 on my Macs. I need to know how to create a text file under Word 2004/2011 and copy that file to my network share folder. I have to write a macro ...
1
vote
1answer
5k views

Word Macro: Move Cursor Down a Row

I have a macro which I've been using to merge two cells together in a word table, but what I want to do is to get the cursor to move down by one cell, so that I can repeatedly press the shortcut key ...
0
votes
3answers
887 views

Macro is not Cooperating with Quotations in Excel VBA

I Have a macro containing a line that will change the formula of a cell using R1C1 formula type. The formula is: ActiveCell.FormulaR1C1 = _ "=IF(R[0]C[-2]=0,"",(R[0]C[-20]-R[0]C[-16]))" ...
1
vote
1answer
9k views

What is needed to invoke LibreOffice running just the macro without the GUI?

Invoking LibreOffice and running a macro via the GUI works as expected producing three HTML files, one for each spreadsheet page: $ libreoffice x.ods Tools>Macros>Run Macros... Library: ...
1
vote
2answers
1k views

Extracting RTD (Real Time Data) from Excel file

I have an Excel 2010 file containing auto-updating cells with RTD. Example of cell: =RTD("xxx";"yyy") I need to extract (in a .txt file) those cells' values, every X minutes. My .txt file MUST ...
6
votes
1answer
515 views

Word 2007 macro gone

I have programmed a little macro for text search in Word 2007. I tried to install it on other accounts in our company with very strange results. On two accounts it worked like it should. On other two ...
3
votes
2answers
515 views

Why do I get special characters in my Notepad++ macros?

Ok so every time I go to make a macro for <br /> I wind up getting special characters because of the shift button and such this is what I wind up getting when I run the macro after just plainly ...
0
votes
2answers
10k views

Excel macro: Replace enitre cell contents; replace 1 but not 10, 11, 21 etc

I need to replace a large amount of numbers with words in an Excel spreadsheet. Eg: 1 = hello 12 = goodbye 4 = cat etc. I can do it with the standard search and replace, but i have a large list to ...
1
vote
1answer
359 views

Firefox URL / link to a group of saved bookmarks?

In Firefox, you can easily save a group of tabs together. When (re-)accessing this group, the 'cascading' bookmark menu shows each individual bookmark (and under a line) it says "open all in tabs" I'...
6
votes
2answers
33k views

How can I delete rest of the line after a specific string?

I'm looking for a way to search for a specific string e.g. '=UUID:' and delete it and all following characters per line. I would prefer a way/macro/addon for notepad++. But all other tools or scripts ...