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)

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
508 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
512 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" ...
6
votes
2answers
30k 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 ...
2
votes
1answer
24k views

Importing CSV files into Excel using a macro

I want to develop a macro where in my Excel worksheet I type a date in a specific cell, and the macro will go into a folder containing text files. A database you could say. I want it to find the ...
24
votes
4answers
44k views

Where can I find a macro recorder for Autohotkey? [closed]

I used a macro recorder for AutoHotkey in the past, but now I can't seem to find it at all.
12
votes
3answers
19k views

Can I search and replace in a Notepad++ macro?

I'm trying to create a macro in Notepad++ that allows me to do a few standard Search & Replaces. I can get the macro to do everything (add lines, add characters) except search and replace. I ...
1
vote
1answer
715 views

Mapping data from OCR'd Document to Form Fields

Is there any way to automatically take the data from a particular place in a document and have it insert into a particular field in a form? All of the documents follow one of two standard formats: ...
2
votes
1answer
2k views

Replace <b>…</b> with bold in MS Word with macros

I have seen the posting for Replace bold text with … in MS Word without macros. How can I do the opposite? How can I open up a .txt file that has html tags in it like here is ...
1
vote
1answer
726 views

Convert <x ug/kg to <x mg/kg MS Excel 2007 macro

I have to interpret data for scientific reports. We report the data all in the same units, however, the lab sends the data in different units. I would like to know how to make a macro that you can ...
1
vote
1answer
116 views

I need to duplicate a word file and name it based on an excel list or other list format

I have a base word file that I need to copy and name approximately 300 times. The content of the word file will be the same, but the file name will be different based on a column within excel (or a ...
0
votes
3answers
10k views

Using dynamic links to external workbooks in Excel

I have a master workbook that needs to pull data from a specific dated subfolder. The date is specified by the user prior to macros being run. The master workbook acts only as a presentation layer, ...
1
vote
1answer
176 views

Looking for alternative to RoboForm's SearchCards

I use Palemoon (a Firefox build) on Windows 7 x64 and I've recently migrated from RoboForm to LastPass for my password keeping needs. The only thing I miss from RoboForm, was it's ability to let me ...
1
vote
1answer
633 views

Mac OS X Open Source equivelent to QuicKeys

Hey there all, I'm looking for a free(as in speech) equivalent to QuicKeys If I'm lucky it'll also be free(as in beer) Any suggestions?
4
votes
1answer
2k views

How do I create an Excel Macro to output key/value pairs to file?

I have two columns as key/value pairs and want to export them to a file in the structure key=value (to create a properties file). I tried this script: Sub Properties() Dim FileName As String, i As ...
1
vote
2answers
438 views

Using Macros with Word 2007

Yesterday, I made a macro to automate switching to a split view in the print layout. It worked fine, and I added a button for it to the quick access toolbar. All was good. Now, today, the button is ...
9
votes
2answers
29k views

How do I get a macro to run in Outlook 2010?

I've written a macro for Outlook and would like it to be run from a button which is visible whenever you compose an email. As such, I've added a button to the Quick Access Toolbar pointing to the ...
2
votes
2answers
343 views

Is there a free ftp client that has macros

At the moment I'm using filezilla to deploy new versions of a site to the live server. the trouble is that there are one or two config, bootstrap etc. files which are different for the live site and I ...
3
votes
1answer
2k views

Preventing a confirmation pop-up when updating fields in Word

In Word 2007, an obvious candidate for updating all the fields in a range is myrange.Fields.Update But if the range is the element of ActiveDocument.StoryRanges corresponding to the footnotes, ...
2
votes
1answer
136 views

Looking for Windows macro recorder that can dock its own toolbars in other applications

About 10 years ago there was a Windows macro recorder product that would create custom toolbars that would dock themselves in specific applications under the application's built-in menubar or toolbar. ...
0
votes
1answer
114 views

Looking to append a tab separated line from word to excel with a macro

Or something.... Word is integrated with our software so it does only one account at a time. Each tab separated line is formatted like: name address acct# dob amtdue For each account I have to load ...
1
vote
1answer
129 views

Fast way to update file names in Mac OS X

I have about 200 images that I optimized with PunyPNG, but it appended .png to the end so all of the images are .gif.png. I don't want to have to manually edit the file name of each one to just be ...
2
votes
2answers
16k views

Excel workbook protection: how can I stop users tampering with a workbook?

I have a workbook with a lot of sheets, macro's and calculations going on. I now need to send this sheet out (not forseen before yesterday). How do I lock it down so that users: are unable to ...
5
votes
5answers
20k views

Switch speaker configuration between stereo and 5.1 using shortcut

I'm trying to find a way to quickly change speaker configuration between 5.1 and stereo in Windows 7; anything that I will be able to make a shortcut of on the desktop for quick access. The issue ...
-1
votes
3answers
319 views

Macros Excel 2007 - extracting data

Im trying to extract certain data from a cell and trying to put it somewhere else within the same cell. Any suggestions? EDIT I have several text strings in ONE cell (a date, a part number and a ...
6
votes
4answers
14k views

How do I create a Macro/short cuts in Eclipse?

How do I create a Macro in Eclipse? For example: I want the combination alt+s will print on the page //********************************************************************
1
vote
1answer
407 views

How to invoke the macro OpenOffice Writer in Linux command?

How to invoke the macro OpenOffice Writer in Linux command when the document is loaded?
0
votes
1answer
169 views

Activating text editing macros on Netbeans

Ok, I've been using Netbeans on Mac OS X for sometime it has some really good features but it doesn't support most of the macros and that sucks. I'm not only talking about complicated emacs macros but ...
2
votes
2answers
13k views

Automate mouse button click with script or macro

I'm searching for a script or macro program which pushes the 4th or 5th mouse button every 5 seconds. This script or macro program is for a friend who uses Windows 7 on an Asus notebook. I cannot try ...
1
vote
1answer
64 views

Trouble with macros

Recently, at work, the program that we have used for years has drastically changed and all of our old file types are no longer supported. This has left us completely out in the cold as to how we can ...
1
vote
0answers
710 views

Gimp batch processing on the Mac?

I am looking for a way to batch apply auto-brightness, auto-contrast, and a dash of colour correction to a pile of images with Gimp. I found a the David's Batch Processor (DBP) plugin but can't ...
2
votes
2answers
2k views

Excel 2007 VBA macros don't work in Parallels

I've got a complex Excel spreadsheet I need to use at work. My colleagues use the spreadsheet on Windows PC's, with no special configuration required. I want to run it on a MacBook Pro running Snow ...
1
vote
2answers
305 views

To pick a particular value from a column

I have got two columns, let say column A and B. In Column A, I have P/L Value. In column B, i have got percentage corresponding to each value. Now i need to find out a way to pick the P/L value whose ...
0
votes
1answer
113 views

Selection of a matrix from the given worksheet and doing the calculation

Sorry for confusing you. Let me state the problem again. I have got two worksheets, let say datasheet and calculation sheet. In datasheet, i have 750 rows and 50 columns. In calculation sheet , i ...
3
votes
1answer
2k views

How to configure a hotkey/shortcut to activate a macro in Outlook 2007?

Is there a way to configure Outlook 2007 so by pressing a [CTRL]+[letter] combination, a macro is activated?
1
vote
1answer
649 views

TextWrangler macro for changing buffer?

I'm using TextWrangler as my main editor and am looking for a macro command that can change the buffer I'm working on. It's really annoying having to touch the mouse each time I need to change file.
5
votes
1answer
6k views

Custom keyboard shortcut for macros in Outlook 2010?

I have a suite of macros that I used to have linked to buttons in a custom toolbar in Outlook 2007. Using the & encoding I could assign keyboard shortcuts to those macros (e.g. &1 to make ...
2
votes
1answer
1k views

Record keyboard/mouse macros for games

I want to record a keyboard/mouse macro for automatically playing repetitive flash games. The programs I'm familiar with xnee/gnee/pnee and xmacro don't work under Ubuntu 10.04. (Xnee gives "Xnee ...
0
votes
1answer
741 views

How can I create a toolbar button that applies a thousands-separated number style in OpenOffice.org Calc?

In OpenOffice.org Calc I very often want to format numbers with a thousands separator. How can I create a toolbar button to do this? Via the menus, the appropriate format can be applied with Format ...
1
vote
1answer
433 views

Excel: Why use an XLA and not just a blank XLS?

Someone has put lots of Macros in blank XLS documents, and now someone has aked me to put them into an XLA document. Why and for what purpose? The Macro's loop through opening workbooks and ...
0
votes
1answer
862 views

Excel Macro: compare separate workbook lists and LINK to the data in a corresponding column?

1. How can I compare two matching lists from separate workbooks? And then retrieve the data from the same row but another column - (Index&Match maybe be appropriate for this). But how does this look ...
2
votes
1answer
2k views

How to delete macros from an Open Office document?

How to delete macros from an Open Office document?
0
votes
3answers
3k views

Excel VBA/Macro: how can I delete rows and remove dots & dashes?

I've recently been handed an Excel file to format - 100's of lines. The image below shows you the state of it. This could be a really long exercise if I work through it manually, so I wondered if a ...
0
votes
1answer
526 views

Enabling macros in a word file

How do we enable macros in a MS Word document. Assume i have a document with many questions and answer choices. I am not able to see the correct answers. I found a suggestion like enable macros in ...
0
votes
2answers
299 views

getting started with macros programming in word 2007 [closed]

I just came to know that macros in word/excel/powerpoint can be programmed. That is awesome because I've a word document with 70 tables for styling. I'm a programmer but I don't know VB or VBA or VB ...
1
vote
2answers
1k views

Remove Excel 2003 macros easily

I am using Excel 2003 and I have some workbooks that I have to send several days a week to some recipients. These workbooks have macros in it and I don't want the people receiving the file to be able ...
2
votes
2answers
906 views

Excel Macros 2007: How can I Bold the Row if a number is in Column A?

My long list of data has numbers in Column A, but in random rows. How can a macro be written to find a number in Column A and then bold the corresponding data in that row? I know if I record my ...
9
votes
7answers
56k views

How to turn hundreds of text URLs in Excel into clickable hyperlinks?

How do I turn a column of urls into hyperlinks, so that users can click on the url in a cell and have it open in a browser? I pasted 100 urls and each went into its own cell. When I double-click in ...