Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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 ...

0
votes
0answers
10 views

Excel Spreadsheet Crashes if Regular User of that Spreadsheet [on hold]

Spreadsheets have a ton of Macros in them. They range anywhere from 6 - 10 Mb in size. The issue is, when the spreadsheet is opened, and you do anything as much as clicking anywhere, Excel crashes. It'...
1
vote
1answer
24 views

How to include a double quotes mark into RegEx exclusion group in Excel UDF

With help of this Is there an Excel formula to identify special characters in a cell? VBA code and excel UDF, I am checking special characters in my csv file. Using this formula: =RegExCheck([@...
0
votes
4answers
80 views

Excel - Day and Date of Month

I have tried a few "Date" formulas but I cannot get this to work. Here is my issue: I want to set up a spreadsheet that will allow the user to type in A1 - the month and year. I would like my ...
0
votes
0answers
22 views

SecureCRT Linux alternative with Macros/Scripting [closed]

I recently came across SecureCRT and i LOVE the scripting feature that it has, it can be so useful for automation in what i do like automate a VPN setup for a Cisco ASA or something. But the problem ...
0
votes
3answers
67 views

How to fill a large series (over 10,000 rows) in Microsoft Excel without dragging or selecting cells?

I have more than 10,000 rows of data I need to do some calculations on one column of the data. I have made the calculation in one cell and now need to fill the formula for the calculation and all the ...
0
votes
0answers
14 views

is there a way to use a Bash/Powershell script to send hotkey commands to terminal

I have been working on a project and have gotten it to the point where I need to be able to send hot key macros to the terminal in order to invoke or stop a process. I have been using python up until ...
0
votes
0answers
13 views

PPTX with linked presentation slide objects - Source file changes name - How to automize the fix/update

I have created this "Master Presentation Deck" in powerpoint consisting mostly of linked powerpoint presentation slides from other presentations. The whole idea is that we need a master presentation ...
0
votes
1answer
61 views

Make PowerPoint 2016 slide auto-populate with Excel data

I’ll do my best to describe what I’m trying to accomplish. In PowerPoint I have one slide that I need to have auto populate based on data within an excel sheet. I don’t know much about macros except ...
1
vote
1answer
22 views

Looking to loop a macro that I recorded, skipping rows and ending based on a condition

Apologies for the uninformed question but I've been looking into macros all morning to help me with a task I'm completing and I haven't found the answers that I need by searching google. I'm using ...
0
votes
0answers
30 views

Macro in excel error when pasting

I filter a column then I try to copy and paste the values. However, I get the error PasteSpecial Method of Range Class Failed Sub DD() ' ' DD Macro ' ' Rows("1:1").Select Selection....
0
votes
2answers
29 views

Macro/VBA to Add Text to Column if there is text present in another cell

I have a report that I download. It has varying Column A lengths. I'm looking to create a VBA/Macro that will put a certain text in M2 if there is any data present in the corresponding A cell. I don't ...
-1
votes
1answer
32 views

Macros disabled on Word

I don't know why my macros on word is suddenly disabled. I tried everything including placing the template location and my word docs as Trusted locations, Enabling all macros. It still won't run. Any ...
0
votes
0answers
39 views

Creating a macro in excel that pauses at the stage I run VBA code

I am creating a macro in excel. I get to a particular stage in the automation when I need to run some VBA code. During the automation process, I click on Developer and input the things that I need ...
0
votes
0answers
43 views

MS Word 2019 crashes while recording macros

I installed MS Word 2019 and I tried to record a macro, but program crashed and closed down. I repaired installation, and I enabled macros in "options" and trust center but problem persists. Anybody ...
0
votes
2answers
73 views

Tell a macro to check if object exists and if yes do A. but if no then do B.?

I use MS Excel 2007. I have the following code in a macro that creates two Option Buttons (not active X) into Cell B25. Range("B25").Select ActiveSheet.OptionButtons.Add(129.75, 540, 24, 20.25)....
0
votes
0answers
26 views

Fixing AS400 error: “Someone else is working in 'J:\AS400 Automation\tk.csv' right now. Please try again later.”

I was able to create a simple command in AS400 by recording some macros from AS400 then adding some codes thru the .ebs file. It was working fine when I was using it but when it was applied to 10 ...
0
votes
1answer
30 views

Exactly position new option button in VBA

Is there a way of exactly positioning and sizing a new option button in VBA or a macro? The code I am using inserts a new Option button in which ever cell is currently selected within a worksheet. ...
0
votes
0answers
30 views

Tips to speed up code which copy/ pastes pictures?

This is my first project using VBA. I have a code (see below) that reads if a number on the sheet is present. If it is, then the code will call a macro to copy the source picture from another sheet, ...
0
votes
1answer
19 views

How to exclude ranges overlap from a range ? (Move cell contents macro)

I have been unable to find a macro to move cell contents without changing formatting. I put together a macro below which achieves this, BUT it clears the pasted range where it overlaps the copied ...
0
votes
0answers
20 views

Excel 2016 - Delete Rows if a duplicate value and if duplicate average the cost

see the attached photo. I am trying to delete any duplicate values from the column C "30018", but i also want the cost which is in column K to be averaged. Although in this example the answer is 13.64,...
0
votes
0answers
45 views

CommandBars.ExecuteMso - VBA code not working

I am trying to make a macro to pull up the 'Change Picture' file explorer. Basically I just want a macro that will do the same as right clicking on a selected picture and then clicking this: I don't ...
1
vote
1answer
44 views

Disable automatic scrolling while allowing typing in cells without macros (Excel)

I am using Excel 2016. When I type into cells at the bottom of the screen and press Enter, Excel moves the view down so that I can see what I just typed. Is it possible to disable this 'feature'? I am ...
0
votes
1answer
69 views

Excel 365 VBA macro

i'd like to populate a spreadsheet Nr 1 based on the entries I made in a different spreadsheet. Here's a description of my workflow: Based on a due date, I generate a calenderweek for specific Task ...
0
votes
0answers
15 views

Move one column to another sheet's first empty column VBA code?

I am new to this macro thing. I've been trying to write the VBA code for the purpose of moving column E of Sheet1 to Sheet2's first empty column with the following code. If I can succeed I will ...
0
votes
0answers
44 views

Macros Created in Excel 2016 Not Working in Excel 2010

I create a file with the same macro in Excel 2016 to send out to people in my company. Users on Excel 2010 were able to use the macro last month, but when I sent them a file with the same macro today, ...
1
vote
1answer
25 views

Creation of a Folder Structure with a path defined in a cell (or pop-up)

I'm a new to using excel's VBA and was wondering if you could help me figure out a solution. So I'm seeking to create an excel spreadsheet that will create a folder structure in a certain location. ...
1
vote
2answers
47 views

How to make a macro that will transfer/distribute data from one cell to various cells?

I would like to ask is a macro could be address this automation. I would like to transfer/distribute data from 1 cell to various cell.
-1
votes
1answer
33 views

User Path - relative paths on work computer vs on home computer

I work on two PC's one at home and one at work. The user name for my home pc is Mike. for work it is mmcloughlin. I have a text file that is located at C:\Users\Mike\Dropbox on my home computer. On ...
1
vote
1answer
25 views

Excel Macro - copy data from several cells including its header to one cell

I have zero knowledge about Macro. Is there a kind of code I can use to copy data from several cells including its header to one cell. It looks like this: This is the source table: And this should ...
0
votes
0answers
26 views

Sounds window opens in random locations

I'm trying to set up a macro that will disable my microphone so I don't have to navigate through the maze of windows every time. Everything works fine until the sounds window opens. It opens at random ...
0
votes
0answers
46 views

Focusing a window in cmd with Nircmd

First time posting. I have been playing around with creating macros that can individually adjust the sound of individual application. Found that Nircmd has the commands that I want for example if I ...
0
votes
2answers
68 views

Group policy to block office macros

my organization has a windows 2016 server standard edition and i'm wondering how to go about adding a group policy to block office macros. I've seen a lot of other posts using user config > ...
0
votes
1answer
70 views

How do dynamically hide cells/sheets without macros

I recently created a company excel workbook that used to have an a lot of rarely used columns/cells and was tasked with making it simpler but still universal. I was able to create a checkbox with ...
0
votes
2answers
34 views

How do I setup an Outlook macro to run when I'm on holidays?

I have setup an Outlook rule that runs a 'save attachment' Outlook macro when a file with a specific subject line is received. This is working fine due to the comprehensive answers already logged on ...
0
votes
1answer
62 views

Macro to fill cells based on conditions [closed]

New user to Excel Macro's here but need to get this task done. I was wondering how I would possibly go about filling cells with a set number based on a couple of conditions. I have a spreadsheet ...
0
votes
2answers
53 views

VBA Code for filtering a column using Input Box

Im looking to filter a column based on a code the user puts into an input box. I used the following code: Sub Filter() ' ' Filter Macro Dim strName As String strName = InputBox(“What DMA would you ...
0
votes
0answers
157 views

How to split multiple worksheets of data by column value and output to separate files?

I have an Excel 2010 workbook (let's call it 'Master') with two worksheets, Sheet1 and Sheet2. Each worksheet has data structured as shown below. One of the columns (in this example, Column1_header)...
0
votes
1answer
47 views

How to keep references unchanged after sorting

In the following spreadsheet, the references will change after sorting and break the calculations. Absolute referencing is not an option. The table has to be copied periodically to another sheet and ...
0
votes
0answers
11 views

Column headings do not pull when i filter for a specfic name

I can create macro to pull data I filtered for but the column headings do not pull, only the one line of data associated with the name I filtered for. Sheets("NOA SUMMARY").Select ActiveSheet.Range("$...
-1
votes
1answer
50 views

How to sync same excel workbook between 2 computers on the same network

I need some help with this please. I have an input workbook where product data is entered, and an output workbook(Report) where this said data is copied into a single line using vba macros. The ...
0
votes
1answer
195 views

Office: file opens in protected view, how to find out why?

When a open a certain DOC file, it opens in protected view. The message says Protected View: Office has detected a problem with this file. Editing it may harm your computer. Click for more details ...
0
votes
1answer
42 views

How to repeat a Macro to end of document - MacOS High Sierra v 10.13.6 - Microsoft Word for Mac v 16.15

I know very little about V Basic, but I know what I want to do must be simple. I just want to go down a line, over to left, and backspace so there are no line breaks. I'm trying to format so I can put ...
0
votes
0answers
24 views

Update Values to an Existing Sheet from every new Sheet created by Macro

As the question on the title, I want to update the values of a sheet from every new sheet that gets created by a macro I made. I made a Macro run when inserted Client Name on the inputbox that runs ...
0
votes
0answers
11 views

I'm trying to use my laptop keyboard for macros when and only when I have a secondary keyboard attacted

I'm trying to improve my productivity when I'm at my desk setup, and I'm too new to Linux to know what I'm doing here. OS is Ubuntu 18.04.1, and I'd love to provide any other info. It would be great ...
0
votes
0answers
13 views

Designing automated grid in Excel

I have a grid that is used to determine the size of a company expressed as a letter of the alphabet. At the top of the grid I have "Number of Staff" expressed in groups of "Up to 100", "100 -200", "...
0
votes
2answers
120 views

Remap Delete Key in Outlook 2016 - Move to Folder

I'm in an industry where it would be best practice to keep all of my emails, however, they live in either my deleted items once i've actioned them. Currently using Outlook 2016 with Exchange. Our ...
0
votes
0answers
15 views

Macro to allow copying/pasting of chart when sheet is protected

I am creating Excel-based dashboards and want to be able to copy and paste charts to another application when the sheet is protected. I do not want the charts to be edited so I have left the box for "...
0
votes
0answers
142 views

Word VBA: Document_open() macros execute on manual open but not when called with a keyboard shortcut

Thanks, @Albin...Sorry, I'm new. If I have a document with code in the Document_Open() section of the ThisDoc section of the document Project in VBA, the code works fine when I open the document ...
0
votes
2answers
109 views

ActiveCell.Value = Time vba without seconds

I have a "timesheet" macro for clock in and clock out times for employees to use at work. The macro I have is this: ActiveCell.Value = Time ActiveCell.NumberFormat = "h:mm AM/PM" It works well and ...
0
votes
0answers
33 views

Excel macro buttons dissapear after screen resizing

I use an excel workbook (made by someone else). Many years ago I used to program excel files with buttons and stuff, but now I don't remember even the terminology so please take that into account The ...