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 the [vba] tag instead of this one if the question concerns a Microsoft Office product. This helps the ...
2
votes
1answer
3k views
Word: Resize Image by Percent - Macro
I routinely paste many screen captures into Microsoft Word 2007 and then have to manually resize them to around 75%, which becomes very tedious.
The screen captures are all different sizes.
I've ...
3
votes
2answers
416 views
Excel 2010: Save current tab as tab delimited txt file
I do most of my stats in R, thus I know nothing about Excel macros and must ask for help. My institute provides MS Office 2010 (currently), so I use that to do quick edits to my data sets, then I save ...
0
votes
0answers
97 views
Excel Normal Layout: Horizontally Centered
Description of Problem
I have an excel form, which people fill out and submit. I have made it very user friendly, and protected it, even removing the "ribbon" formatting bar at the top. I would like ...
2
votes
2answers
132 views
Software for robotic-like job
What's the software that can help on my boring repetitive job?
My daily job involve lots of data entry, copy paste, using internal system to search/input/add and look for data. AFAIK there's some ...
3
votes
2answers
2k views
How to break a spreadsheet containing CSV into multiple columns?
I'm working on preparing data for export, and the client has put all of the data into a spreadsheet. Each field of data should be its own column. The problem is that the client erroneously put ...
2
votes
1answer
546 views
How to automatically create Excel graphs from Access data [closed]
I have some data in Access from which I have to create Excel graphs every month (data would also be updated every month). So it's creating the same charts with different data every month.
Is there a ...
1
vote
0answers
164 views
Timed/Periodical automatic uploads to DropBox?
I'm wondering if there are any tools/apps out that allow you to; select a specific set of files/folders -> select a specific time (every 3 hours for example) -> automatically upload/sync the selected ...
2
votes
1answer
1k views
How can I turn off calculated columns in an Excel table from a macro using VBA?
I am working on a macro that inserts formulas into a cell in an Excel table.
The Excel table does the automatic filling of columns and fills all the cells in that column with the formula, but all I ...
1
vote
2answers
1k views
Is it possible for a macro to open another program?
I am working with a list of 10,000 names, and need to copy info from Excel, paste it into a billing data system, and then paste it into a company data base type system.
Next I need to grab some info ...
2
votes
1answer
54 views
How to Save a File with a Filename Using a TimeCode in Linux
I'm on a tablet pc (Lenovo X60) so my keyboard is not available all (most) of the time, AND I'm trying out Linux Mint instead of Windows.
The main thing I'm missing is my AutoHotKey :(
I need to ...
0
votes
1answer
415 views
Download direct image links in Excel 2003
I have a list of about 6,000 direct links to images in an excel sheet, and I need to download them all automatically onto my computer into a directory keeping the same file names. How do I do this?
1
vote
2answers
928 views
Office 2010 macro issues
I have some macro enabled word documents that worked fine in Word 2003, but in 2010 I cannot get the macro security settings to behave properly.
When I first open a macro enabled document, I get this ...
2
votes
1answer
133 views
AHK macro automation software: GUI does not show
I remember in the past I have used AHK to do some repetitive task.
I did it via some GUI; it recorded my mouse gestures and my keyboard strokes.
I have downloaded it again but now I see no GUI, just ...
1
vote
1answer
535 views
How to add instructional placeholder text to a Word 2007 template
I am creating a Word 2007 template for others to use as a starting point for creating Product Requirements documents.
I would like to embed instructional text in the template which will guide users ...
2
votes
1answer
123 views
Mutt `folder-hook macro` Has Too Many Arguments
Mutt complains that the following folder-hook macro has too many arguments.
folder-hook +INBOX macro index,pager y "<save-message>=[Gmail]/All Mail<enter><enter>" "Archive ...
0
votes
1answer
912 views
Excel macros missing after transferring the file from a friend
I sent a friend an Excel file which contained some macros.
She made some changes and sent it back to me, but somehow the macros have been removed.
Could it be possible that some file scanner or anti ...
2
votes
2answers
1k views
Word macro: how to replace strings in a text, based on a 2 column-table?
So I have a series of strings that I'd like to search and replace in Word documents.
My strings would be displayed as a two-column table. I'd probably create the table with Word, then would convert ...
3
votes
1answer
468 views
Creating automatic links in OpenOffice
Are there any macros for OpenOffice that enable certain words to automatically be replaced with hyperlinks?
Every time I type the word "google" in OpenOffice, I want the word to become a hyperlink to ...
1
vote
0answers
255 views
Macro security disabled in Outlook 2007
All radio buttons under "Macro Security" in Outlook 2007 are greyed out. I am the admin in that Win 7 system and I have not been able to figure how to enable them. Because of the macro security, I ...
4
votes
2answers
8k views
Can I make an Excel VBA macro available to all workbooks?
Is it possible to write a VBA script in one workbook, and use it in other workbooks in the machine? I guess I'm looking for a way to write a macro package.
EDIT
Following the instruction in the link ...
0
votes
1answer
63 views
Key Stroke of SHIFT i displays “BIG PAPA” instead (full Virus/Anti Spyware Scans complete!)
This is a bit weird, and seems to be localized on three machines with MS Office 2007 and 2010, have scanned all three units (one of them was removed from the network, completely formatted, and the OS ...
1
vote
2answers
318 views
Excel macro date parser cannot handle single-digit days
From previous questions on this and other sites I was given a function that can parse for and find dates in text strings or cells. Here's the function:
Function GetDate(strInput As String) As Date
...
1
vote
1answer
1k views
How can I add a macro in Notepad++?
I found that I can record a macro in Notepad++ and stop recording.
However once I've finished recording, it doesn't show any new macros for me to replay or add a shortcut key to access it.
An ...
0
votes
2answers
66 views
How do I associate a shortcut key combination to a macro in Word 2007?
I've created a macro that inserts a reference to a table
When I did the macro, I configured the access to this macro through a button. But, now I want to change it to use the keyboard instead of ...
2
votes
0answers
52 views
Why are some options unavailable when recording a macro in Word 2007?
I am trying to create a macro that works with images in Word 2007. The problem is that when I start recording my macro I can't select some options, such as the one surrounded by a red border in the ...
2
votes
1answer
663 views
What do you use for linux keyboard macros? [closed]
I've tried IronAHK and xbindkeys. Xbindkeys was ok I guess and ironAHK didn't compile. Just wondering if there's better. Maybe something to where I could set emacs-like bindings when certain programs ...
3
votes
3answers
360 views
Is there a way to set the name box of a cell programmatically in Excel
I would like to programmatically set the name box of a cell in a worksheet I'm working on, either through a formula or through a macro. The end point is that I don't want to set it by hand.
In my ...
3
votes
1answer
823 views
Show styles pane when Word 2010 starts
I use Word 2010 with the Navigation Pane on the left side of the screen and the Styles Pane (Ctrl+Alt+Shift+S) on the right side of the screen. Whenever I open Word, I have to set this up manually. ...
2
votes
2answers
4k views
Excel data into PowerPoint slides
I have already found some helpful sites but I'm still unable to do what I want. My Excel file contains few columns and multiple rows. All the data from one row would be in one slide but data from ...
2
votes
1answer
466 views
Copy & paste of cell contents from one workbook to another loses color formatting
I'm using a macro to copy the cell contents (number data and the color format of the numbers) from one workbook into another but it's not carrying across the color formatting.
I have two workbooks:
...
0
votes
2answers
3k views
Need macro to insert custom signature in Outlook 2007 email
I need a basic VB macro to insert a specific signature into an email message. Our support team uses a variety of different signatures to respond to different types of support needs. Currently, I ...
3
votes
2answers
708 views
vim: Continue macro after error in submacro?
I'm in the process of beautifying some source code using vim. {1}
I've created a couple of vim macros that do the individual steps: removing trailing whilespace, removing empty lines after {, ...
0
votes
0answers
469 views
Macro to sharpen all images in word document
I have a 500+ page document with a lot of images. I need to convert all of these to grayscale and to increase sharpness by 40%. Both of these tasks can be done by right clicking each image and ...
0
votes
1answer
242 views
How to run macro with parameter from windows command line?
I have a need for running a Macro from the Windows command line with parameter. For example, a macro should save, in A1 cell, the value of the parameter specified. Is it possible to accomplish this?
3
votes
3answers
537 views
How can I strip macros from an Excel workbook so that I can upload and edit it on SkyDrive?
I don't have any access to MS Office, but SkyDrive for personal use is proving great for my basic edits, but as soon as somebody sends me a workbook containing macros, which I don't need, I can't ...
5
votes
2answers
389 views
Use keys for mouse buttons on linux. Alternative to AHK?
On windows I have an autohotkey script which:
Only works when caps lock is on
Generates left, middle and right mouse button events when left control, menu and alt keys are pressed
Allows holding the ...
2
votes
1answer
130 views
Macro Help: Finding a replacement for Cut and Delete for Speed
I’m looking for a way around using the commands
.delete
.cut
In my excel macros. I’m finding that these processes greatly slow down the procedure (by up to 20 min) for the more data it has to cut ...
1
vote
1answer
249 views
How can I type a single quote in Textmate?
Textmate has automatic quotation closure (clojure) and that's great most of the time. But a lot of times I just need to type a single ' or " and as far as I know there is no way to do this - which is ...
1
vote
1answer
99 views
Is there a way to make Windows (or Firefox at least) TYPE text that is copied? [closed]
I have to make changes to a graphing application. Part of these changes involves searching for a specific server in a dropdown menu that has over 900 entries. Firefox allows you to start typing in ...
0
votes
1answer
378 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
159 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
0answers
388 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 ...
2
votes
1answer
216 views
Macro Find: Is there a macro to Format a Word Document as if it were beign 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 in ...
2
votes
2answers
526 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
138 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
546 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?
1
vote
1answer
360 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
303 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
2k 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
3answers
7k views
Microsoft Word 2010 - 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 ...
