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 people answering, filter questions more efficiently.

0
votes
0answers
15 views

How to convert range of image file path from local folder as comment in the selected destination range?

I'm asking for your help. My research ended up in 2 different macros that combined will give a good utility for my work. This VBA code will insert image as comment. This VBA code will fetch ...
0
votes
0answers
13 views

VLOOKUP equivalent for ms-word: help to auto-populate cells in a table

I would like to be able to enter information in the first cell of a row, and for Word to auto-populate the other cells in that row with pre-determined data. At present, the cells in the first column ...
0
votes
0answers
14 views

Run multiple javascript code for imacros inside a javascript file (iim, js)

I have Windows 7, Firefox 56, Imacros 8.9.7 I need to run multiple imacros javascript code in sequence one after the other. With iim imacros extension I can use this command inside the javascript ...
0
votes
0answers
11 views

Macro Reports files too large [on hold]

Having trouble with my Macro that creates reports, it does the job but the reports are coming out as 2-3mb files, is there something I can put into the macro to avoid it saving such large file size, ...
0
votes
0answers
27 views

Closing COMAddin login window when excel is opened from batch file

I am opening an Excel (.xlsm) workbook using a .bat file. @echo off pushd \\Network123\Folder123\ "Retrieve.xlsm" Note: I need to open the file using command line as the macros I need to use are in ...
0
votes
0answers
17 views

Excel Crashing Because of Deleted Macros

I hope I can get some help here. I have an Excel book that I've used Get & Transform queries to manipulate my data. I wrote a macro to ensure all queries and pivots were updated in a specific ...
0
votes
0answers
26 views

How to transfer EXCEL macro shortcut for the same user on different office PCs

I have a problem that I quite frequently have to change PC on my work but I always keep my user settings on local drive. Every time I change the PC I have the EXCEL settings reseted and all the ...
-2
votes
0answers
16 views

How to call multiple images from folder in excel?

Hi Excel experts & VBA wizards, Is there an easy way to call images from folder in Excel using a formula or VBA? Also, I would like images in R2 to be tied to the campaign names in R1. If the ...
0
votes
0answers
20 views

Is it possible to run a vba macro inside a vbs script?

Long story short, I'm a complete newbie when it comes to VBS (our dev left half work done and then dissapeared) so I """"made"""" (got help from SO) a macro that basically organize HR data based on ...
-1
votes
0answers
29 views

Selecting strings in a Word document other than URLs and changing font color to red using VBA

I have a word document that has a lot of URLs followed by their descriptions mostly separated by a dash (-) but not always. I would like to write a script in VBA that selects those descriptions (minus ...
-1
votes
0answers
10 views

personal macro will not hyperlink data in an active workbook

I wrote a macro that will alpha sort names for sheets in both an index on a team overview as well as sort the tabs in the same workbook. the final step is to exclude blank or unused sheets named(zzass)...
0
votes
0answers
12 views

Editing the From/Sent/To/Subject Mini-Header on Email Forwards

If I receive an email in Outlook 2013 with a body that says: Please call me. -Bill And I go to forward that email, it says: _________________________________ From: Bill Sent: Monday, January 7 2019 ...
1
vote
1answer
13 views

Excel - Can't tick boxes in the Select Data Source dialog

I have been trying to record a macro that would select a specific series to display on a graph. Since I can't use my mouse and I do not know VBA, I have been trying to record this using only my ...
0
votes
1answer
30 views

How can I automate mouse movement in OS X via AppleScript or a shell script?

Just recently I got into an FPS game and I've wanted to challenge myself to make an anti-recoil script for a while. An anti-recoil script would essentially move the mouse based on a set of ...
1
vote
1answer
30 views

Excel VBA Macro - Copying data from multiple sheets in existing file, and creating new file and pasting selected data into separate sheets

any and all help is greatly appreciated. Description: I have an excel file with several sheets of data. I need to copy ALL of the data from multiple sheets, create a NEW excel file, and paste that ...
1
vote
1answer
25 views

Libreoffice Calc, macro set Text Alignment Indent, or property documentation?

In Libreoffice Calc it is possible to use macro's to set the text properties of each cell, to format the layout and font. I was able to find some property names online, in code examples and forums. ...
0
votes
1answer
28 views

Word macro for replacing images with numbered index and moving the image to the end of document

I would like to create a Word macro to separate text and images. The macro should insert the text at first place and move the images inside the text to the end of the document and replace the image ...
0
votes
1answer
23 views

Automatic date calculation in MS Word (maybe using macro)?

I want to have a Date field (manually entered or automatically display "today's date") and a second Date field, such as Due Date and Due Time. I want the Due Date/Time to be automatically calculated ...
1
vote
0answers
22 views

Excel VBA VLOOKUP in Colunm

I have a sheet for monthly report. When daily report got, I want a VLOOKUP formula to be entered under the column where the date exist. I have already set the sheets up with the VLOOKUP formulas ...
2
votes
1answer
40 views

Excel: How to automatically store data gathered from a website scrape?

I have set my workbook to retrieve data from a website which gives prices of stocks. It refreshes hourly. I then have some cells that make calculations based on the stock prices using a simple ...
1
vote
0answers
33 views

How come after generating a screenshot at the same coordinates every time, files may sometimes have different hash signatures?

I am having a hard time figuring out the reason to this. I have a macro running that is screen capturing using snipping tool at the same exact coordinates every single time within a web site (a table) ...
1
vote
0answers
35 views

Defining Words Automatically [closed]

I have a table of words in Microsoft Word. One column has all the terms and I want to output the definition of those words to the second column. I thought there might be a way to do this but have had ...
0
votes
1answer
20 views

Disable a macro, with another macro. EXCEL VBA

I have 7 macros that prevent a user from copying and pasting in a workbook. However, now and then I want to be able to copy and paste. Is there a way to disable these macros with another macro ? I ...
0
votes
1answer
20 views

How do you self sign a macro for Microsoft Office for a non admin user

I am trying to self sign a macro that I wrote for Outlook, and my searches lead to SelfCert.exe I ran SelfCert.exe and was able to make a self signed certificate, and inside of Outlook I was able to ...
0
votes
0answers
24 views

VBA - Excel Stops Responding - Table Applied to Whole Sheet?

I have a button that calls many separate macros. Everything works as expected, but with 1 exception. I need to input a formula in row 2 of four separate columns and have the formulas drag down to the ...
0
votes
1answer
21 views

Excel file, want to keep ID cell when filtering columns

I would like to filter column D , But need to keep the id from Column C to show. The easy way would to just have the column C list the code for each row, but that gets confusing when trying to get a ...
1
vote
1answer
26 views

Powerpoint - Open PPTM (macro enabled) File on Startup

I have a PowerPoint presentation with a macro. I would like PowerPoint to open on startup the following to files. Blank.pptm (My custom PPT file with macro) Blank.pptx (Default PPT file) (Optional) (...
0
votes
1answer
57 views

Excel dynamic search vba code

With this VBA macro for Excel I get instant search filter when I type the whole word, but I want it as follows: when I type O for opel, that I get opel already showing. This is the code: Sub ...
0
votes
0answers
24 views

VBA - Assigning Macro to Form Control Button

I wrote the below code in VBA to delete full rows if, in column U of Sheet21 (actually named "ROG Registration") if "Self Cancelled" or "Waitlisted" appear. When I'm on the ROG Registration tab with ...
0
votes
1answer
36 views

VIM - running a shell command fails within a macro

I have a list of items in a file, and I am trying to add an id on the line before each one. The id is generated by an external shell command and added to the buffer: :r !php _setup/getid/php item | ...
1
vote
1answer
34 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
82 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
3answers
112 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
21 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
19 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
70 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
33 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
54 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
38 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
37 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
44 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
65 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
110 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
42 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
41 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
25 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
102 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
46 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
73 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 ...