The macros tag has no wiki summary.
1
vote
1answer
27 views
Automation / Macro Software Languages, Libraries, or Tools
Based on this info, what automation tools / libraries / scripting languages do you suggest?
I have a C++ / C# backround
I have a Python future
I use Windows, but would very much prefer a ...
0
votes
1answer
26 views
How to write a macro to get selected words an emphasis mark?
How can I write a macro for OpenOffice writer, which get the words/characters that I selected with mouse an emphasis mark like dot over the words/characters?
I tried to record macro, but failed.
I ...
1
vote
1answer
42 views
Lookup and return value based on sub-string match
Is there a formula or script that will match sub-strings from one column in another column and return the full value of the sub-string match? e.g.
Input
COL_a COL_b
name ...
1
vote
1answer
36 views
How to select radio buttons by cell value in Excel?
I have a group of radio buttons with labels in adjacent cells. How can I arrange for the radio button with the label matching a target cell value to activate?
EDITED TO ADD
Here's an equivalent ...
1
vote
1answer
52 views
Excel: change data source with macro
I'm using a CSV file (generated by a thing party program) as an external datasource, and I'd like to change its path from a macro... How can I do that ?
Another acceptable answer to my problem would ...
1
vote
0answers
40 views
macro to make Outlook prompt me on open/close to turn Out of Office off/on
I would like to add a macro to Outlook 2007 that asks me when I shut it down if I want to turn the Out of Office Assistant on, and then asks me when I open Outlook if I want to turn Out of Office ...
8
votes
8answers
195 views
Is there a Win7 shortcut to position mouse in center of primary screen?
I have a three monitor set up on Windows 7 and I sometimes lose track of where my cursor is. Is there any Windows shortcut to reset the mouse position? I'm guessing there is not, but might there be a ...
1
vote
1answer
74 views
Excel Macro/VBA cheat sheet?
I'm confident coding in C# & Java, but have never gotten around to writing macro's in Excel.
I was wondering if anyone could point me in the right direction for some NON-beginner cheat sheets for ...
1
vote
2answers
79 views
How to find the latest date/time on the column using macro
I have data generated from the system that looks like the table below. On the last column I need to display the user who was the last one updating the system from each dept.
Update Time User ...
0
votes
3answers
56 views
How can I avoid the clipboard message box when copying large amounts of data in Excel?
I have a macro that is copying 4 sheets from one workbook to a new workbook and saving it down with another name.
Unfortunately the message box asking me whether I would like to make this large ...
-1
votes
1answer
105 views
Word Macro - auto increment invoice number and file name on save
We're developing an invoice template for Word, which contains an invoice number in a field at the top of the page.
We would like the invoice number to auto-increment (from the last invoice number), ...
0
votes
1answer
48 views
Automatically rename the worksheet created for a CSV file imported into Excel 2010 to Sheet1
I have an application that can import data from an Excel (.xls) spreadsheet. This spreadsheet is in turn imported from a CSV file, which provides a template for data. The user then populates the ...
0
votes
0answers
41 views
Convert text to image in Microsoft Word [closed]
I have a large book written in Microsoft Word and want to create a macro that will find all text using a predefined style and convert that text to an inline image. This text will be in Arabic and ...
0
votes
2answers
50 views
Microsoft Access Macro - is there a way to copy records with a macro?
I have written a macro in Microst Access that runs a make-table query, opens the table and selects all the records. (I don't know VBA so I have to use macros).
Then I copy all the records and ...
4
votes
2answers
194 views
How do I add “input” to my macro, to replace text in Notepad++?
I'm trying to make a macro with an 'input' pop-up dialog that synergizes with the replace feature. It should go something like: "Paste text->ask for input->replace variable in pasted text with input ...
0
votes
0answers
3 views
Editing XML files [migrated]
I have some XML files and I need to edit them automatically.
For example
<Content>
<Texts>
<Text id="1">
<en value="blaabla" />
</Text>
<Text id="2">
<en ...
1
vote
0answers
56 views
When replying to email in Outlook 2010, how do I get it to automatically select the account I want it to send to? I have multiple accounts
I have multiple accounts and want to get outlook 2010 to automatically select the account it uses to send my reply emails - based on whatever email address is indicated in the "TO:" field for that ...
1
vote
1answer
26 views
How can I run a macro whenever I enter a new slide?
I'd like to have a simple macro run whenever I enter a new slide, whether I got there by normal click-to-advance or by following a link within the slideshow. Is this possible? I've searched for some ...
0
votes
1answer
47 views
Can Vim autocommand be triggered by filetype instead of by pattern?
I know how to set up features using :autocmd for specific file extensions:
Eg. ~/.vim/ftplugin/xml.vim
augroup xml
au BufEnter *.xml call Setup_XML_Menu()
au BufLeave *.xml call ...
1
vote
1answer
89 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
79 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
205 views
Macro Code for LibreOffice Calc
I have been working on a invoice spreadsheet in Libre Office Calc. Im almost done but I have a few tasks left to complete before its where I want it. I have used the Macro recorder to get most of ...
0
votes
0answers
42 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
66 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 ...
2
votes
2answers
117 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 ...
3
votes
1answer
62 views
How to automatically create Excel graphs from Access data
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
40 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 ...
1
vote
1answer
92 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
54 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
30 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
0answers
86 views
Application Volume control shortcut
I want to be able to control the volume of Windows while I play games via keyboard macro or short cut
I have a razer lycosa and can setup up macros and such. It allows me the control the master ...
0
votes
0answers
19 views
Is there any macro plugin for browser to do from input?
I would like to input huge amount of data from the browser, instead of click click click, like a machine, is there any plugin to doing so? Thanks.
0
votes
1answer
46 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
1answer
58 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
0answers
31 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
0answers
59 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 ...
1
vote
1answer
23 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
72 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
62 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 ...
2
votes
1answer
109 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
54 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 ...
2
votes
2answers
180 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 ...
5
votes
1answer
386 views
delete first 27 characters from every line notepad++
I have a log file and I need to remove the first 27 characters off every line. You would have a line like this:
2011-09-25 01:25:29 [INFO] <Exazoro> wazup
But it needs to be like this:
...
0
votes
1answer
53 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
83 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
...
0
votes
0answers
41 views
How to remove opening and closing brackets from selected text in Word?
I want to create a macro in word that will remove opening and closing square brackets from a selected text.
I just can't figure out what to type in the Find and Replace window. Is there a better way ...
0
votes
1answer
112 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
17 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 ...
1
vote
0answers
20 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 ...
1
vote
1answer
120 views
What do you use for linux keyboard macros?
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 ...
