The macros tag has no wiki summary.
0
votes
1answer
25 views
Is there a macro to split the contents of an Excel spreadsheet into separate spreadsheets?
I know there are similar questions out there but I don't think they are quite the same.
I have an excel spreadsheet with the following headings-
First name -- Surname -- Host Trust -- Contact ...
1
vote
2answers
33 views
Reading macros in an Excel file?
I've got an Excel file (supplied by someone else) that opens with the message
This file contains Visual Basic macros.
I'd like to look at the macros within the file - they contain code that I ...
3
votes
2answers
43 views
Looking for a simple macro/keyboard shortcut software
I'm looking for a simple software which would do this:
When I type in something like dbs and hit tab or enter, it will replace dbs with $this->db->set() in the program that I typed it in.
It ...
2
votes
1answer
86 views
Keyboard macro to change default audio device
Windows 7, Logitech G110 keyboard
2 audio devices (headphones and speakers)
I am hoping to find a quick way to macro a key to switch to headphones, and a key to switch to speakers.
Anyone have a ...
1
vote
0answers
41 views
How do I disable the row/column unhide option in a shared Excel file with vba?
I have a shared Excel file that I need multiple people to work from at once.
The file contains some macros that hide certain columns based on the username.
1) check for username
2) hide columns A, ...
0
votes
0answers
52 views
Android macro recorder for the internet [closed]
I saw a bunch of macro recorders for Android when I did a search.
Is there a good one that will work with the internet? I don't see any Firefox plugins (iMacro is not ready yet). I am looking for ...
0
votes
3answers
98 views
One computer, two desktops?
Can I make my single computer run multiple desktops at the same time.
I need one desktop that will work in the background until I decide to switch back to it from the other regular everyday desktop.
...
0
votes
0answers
25 views
Macro to collapse section of table in Word 2003
I was wondering if it's possible to hide/collapse a section of table in Word. It's like when the user hit "NO" button the section of table for detail information should hide/collapse. I know the ...
0
votes
0answers
18 views
Keyboard with hardware macros?
Are there any keyboards with extra programmable keys for which there is hardward-only support for macros? In other words, the macros can be programmed and played back on any OS without installing any ...
1
vote
0answers
50 views
Refreshing Crystal Reports through Excel Macro
At work we have an ancient Ingress database that wont allow me to make links between tables using the SQL Query editor in Excel 2007.
My current solution is to generate the data in Crystal Reports, ...
0
votes
0answers
73 views
Access 2012 - Can't find object
When opening certain macros, whether in design or run, I get ' Microsoft Access cannot find the object 'whatever the object name is>'. This only is on certain macros, but most of them work properly. ...
0
votes
1answer
90 views
Rows in Excel VBA Macros
I need help in being able to do the following:
In Worksheet A I have raw data.
In Worksheet B I have a template with formulas.
The data on Worksheet A change on a weekly basis.
I need to find a ...
0
votes
0answers
50 views
Word macro for currency formatting to 2 or 4 decimal places
I have an old word document with several form fields that I'm trying to update for the first time in a few years. I have discovered that in Word 2010, any field formatting that I try to apply goes ...
0
votes
1answer
50 views
Username password Macro or tool
I write extensions for a program. The program has a username/password dialogue box. There is no "remember my password" option. The task of entering this information is quite cumbersome and breaks ...
0
votes
1answer
33 views
How to set up a shortcut for Mail PDF?
I often need to email a PDF of the document open in the front app.
Currently, I need to invoke the print command, then reach for the mouse to open the "PDF" menu in the system print dialog, and ...
1
vote
1answer
82 views
Office 2010 missing macros
I'm running a newly installed Office 2010 installation on a Windows XP machine, but whenever I try using some of its features, like equations in Word, I get this message:
The function you are ...
0
votes
2answers
165 views
Running macro through NPPExec (Notepad++)
Is there a way to run a macro using NPPExec script in notepad++? Thank you very much for your help.
EDIT:
I have also tried to find the solution here and the NPPExec Manual that can be accessed ...
1
vote
2answers
94 views
Auto start Notepadd ++ Macro
Is there a way to auto start a Notepad ++ Macro? I have a macro created but I want it to auto start when Notepad ++ starts.
0
votes
0answers
92 views
Install Windows 7 on Mac using Virtualbox but stuck in “setup is starting…”
I am installing Windows 7 Ultimate on Mac, using Virtualbox.
The setup starts smoothly at first few seconds, but then stuck in step "start is starting..."
Would anyone know what is the reason and ...
1
vote
0answers
50 views
Scripting / Macro tools for Bluetooth etc on Windows
Say I have to connect a Bluetooth headset, it takes a long time to do it manually each time (and afterwards its the sound settings).
What kind of scripting or macro tools would I use to automate ...
0
votes
1answer
207 views
Sort list into multiple columns - vba
Ive got a long list of about 2000 names in column A in an excel sheet, there are only about 40 different names and they are all repeated. I need to sort them by name into columns. Some of the names ...
2
votes
0answers
59 views
Is there a FOSS macro somewhere that will convert tabs to the spaces up to the next tab mark?
Would like to ensure text documents don't get mangled by badly behaving email clients on smart phones that mangle tabs, so would want to convert tabs to the number of spaces up to the next tab mark in ...
1
vote
1answer
103 views
VBA - pop up commands to fill in detail on spreadsheet
I can successfully find a specific row (by reference in column A), copy the row and paste it below the original.
I would now like the ability to request information to fill in certain cells. For ...
0
votes
1answer
377 views
Macro - Find Job, Copy and Paste row
i would like to create a macro to find a job (use find function) and then copy the row that the job is on and copy and paste the whole row including values and formulae.
The job number to find will ...
0
votes
1answer
56 views
Can you re-purpose built-in laptop keyboard as a hotkey launcher?
I have a MacBook Pro - but I don't use the keyboard, I use a (more ergonomic) plugin keyboard.
I have an x-keys (programmable keypad). I'm thinking of getting another one, but it just struck me as ...
1
vote
3answers
189 views
excel vba - multiline regex not working
In cell A1 of an excel sheet I have the following contents inside the cell:
select a.id, b.type, c.name
from blah a,
blah2 b,
blah3 c
where a.id = b.key
and b.key = c.id
;
Either of the below ...
1
vote
0answers
96 views
Need to set cron for random intervals with iMacros
I am trying to learn about cron for iMacros but I don't know where to look. Google was no help.
Basically I have script I wrote, a series of commands, like this:
Line 1
Line 2
Line 3
etc.
What I ...
1
vote
3answers
207 views
How do I transpose data in columns to rows?
How do I transpose data in columns to rows?
If the data is:
Joe
some city
some state
Bob
no city
no state
and I use Paste Special » Transpose, I get
Joe some city some state Bob ...
0
votes
1answer
64 views
Excel macros making all text superscript
I have several different macros that create a sheet in Excel 2003 and populate it with information. These macros are all written in VBA and some are linked to a toolbar in Excel and some are in MS ...
0
votes
3answers
959 views
Copy Excel worksheet and maintain relative cell reference in formulas
Another copy problem in Excel:
How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula =B!23 becomes ...
0
votes
2answers
148 views
Microsoft Word keyboard shortcuts for macros aren't working
At work, I have several Word 2007 macros in a Normal.dotm template. Under Windows XP, I had some of the macros assigned to keyboard shortcuts, e.g. Ctrl+Shift+9. Everything worked perfectly.
Our IT ...
1
vote
1answer
63 views
Excel - getting a macro to generalize to other rows
Let's say I create a macro that solid fills over text from B2:F2. I would like this same thing to be possible on all other rows without writing a macro for hundreds of other rows.
Is there a way ...
2
votes
1answer
161 views
How to execute an Excel 2010 addin?
I created a macro using vba using Excel 2010. I then needed to make it available for everyone on my team by turning it into an addin.
So, I took my macro
and opened a new workbook
pasted the ...
3
votes
2answers
84 views
How can I keep every fifth row in Excel
I have a data set in excel with 3084 rows. I need to delete 4 rows, then keep one: deleting Tuesday, Wednesday, Thursday, Friday but keeping Monday to create a weekly rather than daily data set.
...
0
votes
1answer
224 views
PowerPoint 2010 Developer Tab - “Code” Group Disabled
The "Code" group on my Developer tab in PowerPoint 2010 is entirely disabled. For clarity, the "Visual Basic", "Macros", and "Macro Security" buttons are greyed/grayed out. I am also unable to open VB ...
0
votes
0answers
99 views
LibreOffice Impress template: substituting text obtained from a list of texts?
I have:
An Impress template with a text: The Name (for example)
A text file with a list of n names (one per line)
What I would like:
n Impress files for each name in the file with the text The ...
1
vote
3answers
84 views
What technology allows the “stripping” a DOC, PDF, XLS, etc of non-data features
For security reasons, I need to reduce a document to a common format, thereby removing any Macros, metadata, cleaning embedded images, and reducing risks the attachment may pose. Even though the links ...
1
vote
1answer
193 views
Prevent Excel 2010 user from pasting formatting into cell
Is there a way to lock a cell so that a user can copy/paste a value into it, but not copy formatting to it? Locking the worksheet doesn't prevent the user from changing the formatting of the cell by ...
0
votes
1answer
257 views
outlook automated reply with unread message count
I get hundreds of daily emails and I'm looking to configure an out of office reply for outlook which will inform the recipient that I have X unread emails and that I'll get to theirs as soon as ...
0
votes
1answer
72 views
why do my vim macros stop working sometimes?
This happens to me sometimes, and I haven't been able to figure out why. Lets say I start recording in vim (press q) then I finish and use the macros a few times. Then I do something else, like ...
0
votes
1answer
296 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
106 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
214 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
263 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 ...
2
votes
0answers
110 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 ...
10
votes
8answers
631 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
381 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
287 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 ...
1
vote
3answers
112 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
419 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), ...
