Questions tagged [macros]
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 people answering, filter questions more efficiently.
1,766
questions
1
vote
2
answers
2k
views
How can I force Excel to recalculate after a UDF macro error?
I created a bug in a user-defined function that is called from a large number of cells on many tables in an Excel workbook (not the way I would design it, I just "inherited" it).
But now, I can't ...
1
vote
1
answer
634
views
How to create multiple rows combining data sets
I have three tables and i need an out put which has data from two tables, i would like to create the same using macro.
Table A
A
B
C
D
Table B
Apple
Orange
Pears
Table C
Americas
Asia
Europe
...
1
vote
1
answer
2k
views
Splitting an excel 2010 spreadsheet into multiple workbook files based on column value
I find and clean a lot of contact data, sorted by country, which I am currently using excel to manage. Mainly because it is easier to clean and manipulate the data I find this way, and I can easily ...
1
vote
1
answer
1k
views
Open new ConEmu tab with the same working directory
I have a ConEmu macro for Ctrl+T which runs Task("Powershell"). My Powershell task just runs powershell with the argument \dir %userprofile%.
The Macro tab in "About ConEmu" says that the Task ...
1
vote
1
answer
8k
views
VBA Excel Macro that can append data from one row to another
I have a macro that does the following:
Checks to see if consecutive rows have the same data (Columns F and G)
I need this macro to also somehow do the following:
If the data in Columns F and G are ...
1
vote
1
answer
29k
views
VBA to insert a carriage return after existing text and paste more text
I'm adding "Measure_1" within certain cells. This requires me to double click in the cell, go to the end of the existing text, insert a carriage return (alt+ent), and then paste in MEASURE_1. ...
1
vote
1
answer
2k
views
Issue with spaces in path name in Excel macro
VLOOKUP definition is:
=IF(ISNA(VLOOKUP(RC[-7],'[\\sqlc\Curr table & Checklist\Currency table - foreign.xlsx]Sheet1'!R2C1:R9999C2,2,FALSE))=FALSE,VLOOKUP(RC[-7],'[\\sqlc\Curr table & ...
1
vote
1
answer
4k
views
Add a button to an e-mail which runs a macro when clicked
I'd like to send a friend an e-mail that has a clickable button in the message body... The button will run a macro.
I know you can do macros on your side of things, such as:
Private Sub ...
1
vote
1
answer
13k
views
Copy text from a basic "Text Box" and paste it into a cell
I'm trying to access the text inside "Text Box 1", copy it and then paste it into a range beginning at A37.
UPDATE: the text boxes in question are simple text boxes that have been inserted using: ...
1
vote
1
answer
4k
views
Sharepoint Document's macros
I'm trying to upload an excel document with a few macros to a 2013 SharePoint, I don't know if I can use the macros via "View in Web Browser" option. I cant get them working, although if I download ...
1
vote
2
answers
10k
views
Excel 2010 Legend key color based on text
Background
I've an excel template. This template I populate with data by running a program I've written.
The excel template has a pivot table on a sheet that get's data from another sheet that I've ...
1
vote
1
answer
2k
views
Merging rows in an Excel document with the same email and preserving merged row data
I have an excel sheet of around 50,000 records of something like this:
email product info moreinfo
[email protected] 866 data data1
[email protected] 960 data data1
[email protected] 976 data data1
[email protected] ...
1
vote
1
answer
12k
views
Copy/move values matching a pattern to another column
I have a worksheet where we need to move all the values matching a pattern to different columns.
For example, we have a B column with values that are one or more letters followed by one or more ...
1
vote
1
answer
5k
views
Can I create a macro that will offer a drop down menu for subjects in Outlook 2010?
I need the subject line in my Outlook messages to begin with job the message concerns. Since there are about a dozen jobs going on at any particular time, it's cumbersome to either type the job name ...
1
vote
1
answer
681
views
Adding a macro to Outlook
There was a question on adding a macro in Outlook 2010 but the answer was a little unclear to me. I want a specific line of text to appear in an email that is sent to a specific group of people (...
1
vote
1
answer
586
views
Create text file named after a cell containing other cell data
I tried using the code below for the Excel program on my `Mac Mini using the OS X Version 10.7.2 and it keeps saying Error due to file name / path: (The Excel file I am creating is going to be a ...
1
vote
1
answer
11k
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
2
answers
3k
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
1
answer
1k
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 ...
1
vote
1
answer
8k
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 ...
1
vote
2
answers
3k
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 ...
1
vote
1
answer
296
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
1
answer
2k
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 ...
1
vote
2
answers
2k
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
1
answer
527
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'...
1
vote
1
answer
1k
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: ...
1
vote
1
answer
205
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
2
answers
493
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 ...
1
vote
1
answer
514
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?
1
vote
4
answers
28k
views
How do I get an Excel macro to copy data from a specific column and the same row that is selected at activating macro?
Example:
I have selected any row and any column, let's say D6.
The data I am looking for is in column H.
So, I want the macro to copy the data in row 6, and column H, i.e. H6.
If I have selected G14, ...
1
vote
2
answers
5k
views
Shortcut keys not working on Windows 7 Ultimate x64
yesterday I installed Windows 7 Ultimate x64. The problem is that I have some programs on the quicklaunch and I want some of them to be opened by hitting a shorcut key.
Well, the procedure to set it ...
1
vote
1
answer
69
views
Excel - put login times into neat hours
I have this info in an excel spreadsheet ..
representing the amount of time spent logged in to a computer..
logins time of day amount of time logged in (h:mm)
------ ----------- ---------------...
1
vote
0
answers
91
views
How to run a Word macro from the command line?
I'm trying to save and close all open Word files (to start I only target one of them).
The macro I made works when ran from Word (clicking "Execute"), but it won't run when called from the ...
1
vote
1
answer
146
views
Macro for using Goal Seek over a range of cells
I'm trying to automate the GoalSeek function over a range of cells. Each cell in Columns I and J calculates a quantity of interest using two different methods, and the results must agree.
Each cell in ...
1
vote
0
answers
13
views
Trying to update ranges in macro to not have set range
I am trying to update my macro to where the set ranges in the macro are not hard coded because when the data for the new data set is ran the data range may be smaller or larger. How do I update my ...
1
vote
1
answer
74
views
Need a VBA Solution - Clear contents of 7 cells to the right of cell
I have a document where I need to look for a specific text and clear all text in the cells to the right of it. I don't want to delete the cells just clear them out. There are a total of 7 cells next ...
1
vote
1
answer
782
views
Turn cell references in Excel hyperlinks into the text in the referenced cells
I have a column of bare URLs in Excel. Say it's Column A. I want to replace each URL with a friendly text link, like "here." Suppose A1 contains the link https://www.website.com/content/...
1
vote
0
answers
192
views
Excel VBA Macro: Formatting Duplicates and Uniques
I have a spread sheet where each row consists of information about a member of a group. In each cell of column B there is an integer that represents each person (i.e., think of an member ID). All ...
1
vote
0
answers
44
views
Skip rows with NULL value
I have this code I have been using to find the 50% exceedance value per hour and month. Attached is a picture of the data. There are some NULL values in the Gen columns and I need the code to skip ...
1
vote
1
answer
501
views
Create a macro on Word to save with current name at a different location
I have a Windows 10 PC.
Basically I have a similar problem to this: How can I save a file to two locations at the same time?, but just the opposite. I have files on a USB stick, and I want them to be ...
1
vote
1
answer
3k
views
Excel VBA - add date and time to a file name as FILENAME_MMDDYY_HHMMSS
A few weeks ago I posted about using VBA To prompt me to add a file name when saving an excel file using a macro. Thank you for all the help. I got it to work!!
Now I have another similar question.
...
1
vote
0
answers
12k
views
Outlook in MacOS search issue
Problem
trying to search mail in Outlook in a Mac computer. It can't find mails, even though the mails are in the inbox
Outlook Version: Office 365
Mac Version: MacBookPro (MacOS Ventrua
13.1)
...
1
vote
0
answers
52
views
Clicking on an unlocked cell on a protected sheet is unprotecting the sheet
I have a workbook with multiple sheets. There are unlocked and locked cells. I have a macro to protect all sheets.
After I run the macro and all sheets are protected, when I then click on a cell ...
1
vote
0
answers
50
views
Creating .txt files from excel columns with description [closed]
I am trying to create .txt files that have the following:
Txt file name would be cell(A1)
Content of the txt file needs to be the content of cell (B1)
Repeat throughout the column
I am new to VBA and ...
1
vote
1
answer
601
views
Word 365 Allow Macros to run on Read-Only/Protected View
I am attempting to upgrade our company to Microsoft 365 x86 from Office 2019x86. We are currently stuck on 32bit because our electronically controlled document process currently has VBA macros that ...
1
vote
1
answer
70
views
Microsoft Word - adding page number to page not Header or Footer
I reformat texts to be readable by our students who read with Braille. We are always looking for ways to speed up our processes so that we can deliver more texts and deliver on time.
Part of this ...
1
vote
0
answers
108
views
Formula for data distribution
I would like to know if there is a way to automatically distribute the amounts from column H into column D in 3 sections (Blue, Green, and Yellow) starting from D28 (Start) and climbing to the top D3 (...
1
vote
0
answers
24
views
Win10 - Excel 2010 - Need macro to place hyphens between each letter of a single Hebrew word in a cell
The goal is to separate each Hebrew letter of each word of the Tanach/Old Testament into separate cells. If I manually place hyphens between each letter in a word, then Text to Columns will place each ...
1
vote
0
answers
77
views
Remove lines with less than X number of letters from Microsoft Word (2016 or higher)?
I'm using MS office 365. I have a big MS word document containing more than 10000 lines.
The document has some meaningless lines that contain meaningless alphabet letters, unknown Asian letters, ...
1
vote
1
answer
788
views
Notepad++ perform multiple actions to multiple files at once
I have like 20 subtitle files where I do these actions one by one:
Encoding > Character Sets > Central European > Windows 12-50
(ctrl+shift+E shortcut)
Encoding > Convert to UTF-8-BOM (...