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

learn more… | top users | synonyms (1)

0
votes
2answers
47 views

Outlook rule with macro quit firing

So, I set a rule in Outlook that whenever an e-mail from a specific source (our IPS alerting system) it would fire the below macro to save the attachment to my disk for further automated scripting ...
3
votes
1answer
85 views

Enable Macros after message box closes

Is there a way to enable Macros after the message bar with the Enable Macros button has closed? I opened the Excel file and immediately went to edit the VBA. When I went to run the VBA, it stated, ...
0
votes
0answers
73 views

Create macro in notepad++ that copies line of text from one text file and pastes to another text file?

For example, I have a text file that has a tons of lines, but I only need the lines in the file that include the text "Employee_user_id". So I was thinking of doing something like this, using ...
0
votes
2answers
171 views

Excel Text to Number is not changing the Format

I have a Macro in Excel that is trying to convert text to number (currency) a Column. The values in the cells are text that looks like this "USD 8,765.43" the objective would be to have a currency ...
0
votes
0answers
195 views

How to create an Outlook macro that updates a table's attributes to shrink a table to the contained text without wrapping?

Version: Outlook 2013 I want to be able to... Alter the font-size of the text in the table. (Done) Remove (uncheck) the "Preferred Width" attributes from the table, collumn, and cell active ...
1
vote
1answer
79 views

How do I make a macro to generate a record number based on the fiscal year? (Access 2013)

I would like to create a record number that is based upon the fiscal year and automatically advances... Something like: 2015001, 2015002, 2015003, 2015004; 2016001, 2016002, etc. I already have a ...
-1
votes
1answer
794 views

vba - html table to excel worksheet

I need a vba script that can extract local html table data to excel worksheet. I have a code (found it somewhere on the web) that works by using url link, but what i want is to be able to do it using ...
1
vote
1answer
315 views

Find all instances of a text and make it a hyperlink with a macro

Required I want to find all occurrences of a single text in a MS Word document, make each occurence a hyperlink and change the generic hyperlink style to one of my chosing. What I have As I have no ...
-1
votes
1answer
88 views

How to render html file in Microsoft Excel?

I was able to open an html file using vba, the problem is, the content is not in the sheet. Its just white. is there a way to open an html file using excel and be able to display the html content?
0
votes
2answers
136 views

Excel Personal Macro Workbook keeps getting disabled

I'm a new user to this site. I'm trying to run a VBA macro in Excel once a day at midnight using the windows task scheduler. It imports data from a .txt file that gets dropped into a folder at night, ...
1
vote
1answer
24 views

USD to CADollar error

I am trying to develop a macro that converts USD to CAD. So far, the macro converts the value of the active cell to CAD while displaying the initial formula (required). However, I get an error when ...
0
votes
1answer
18 views

Excel 2013 Macros/ sub procedures

After creating sub procedures, they are not considered part of the macro group. Why? How should a sub procedure be created so it is included in the list of macros?
0
votes
1answer
145 views

Change save file format in VBA

I read this question: Can I split a spreadsheet into multiple files based on a column in Excel 2007? I have a question regarding the "Save in same format as original workbook" that I hope you can ...
0
votes
1answer
50 views

Excel: how to add random decimals to numbers with a macro

I have a list of gps coordinates for a map that we need to randomize a bit as we cannot provide the exact addresses. I would like to shorten the original coordinates (that is the easy part as I just ...
0
votes
1answer
28 views

Excel VBA localisation issue - WIN 8.1 Enterprise, Excel 2007

I have a problem with file using VBA macros created in GER version of Excel. This macro is testing the pivot table item for "Alle", but when someone opens the file in EN version, the pivot table item ...
0
votes
1answer
27 views

Error running macro after trying to run it from pesonal workbook

So I wrote a macro. The scenario of use is: I open a fresh and new CSV file downloaded from somewhere My macro runs and does some magic with the data Since I don't want to copy-paste my macro to ...
0
votes
1answer
25 views

Migrating Images from URL in excel

Reference to this discussion about migrating images from URL in excel How can I display a URL as an image in an excel cell? The VBA code looks perfect and working, my question here is that how can i ...
1
vote
1answer
81 views

Excel automatic “date changed” field for each column of data

I'm using Windows Excel 2007, if that matters, and I'm trying to have a date field update to today's date automatically only when a cell in that column gets changed. I add new data entries per column ...
0
votes
1answer
65 views

how to run a macro on multiple worksheets

i want to run a macro on multiple worksheets. the sheets are named A,B,C...X,Y,Z. when i get to Z, then the sheets start of as AA,BB,CC...XX,YY,ZZ, then AAA,BBB,CCC...XXX,YYY,ZZZ and this repeats all ...
1
vote
1answer
78 views

Will Excel macros continue or slow down after pc “screen-off” only not standby?

I'm running a large macro in Excel, and leaving it on all night. I realize that if your computer goes into sleep mode, it may pause the macro processing, but I didn't think that when the "screen ...
0
votes
0answers
60 views

Excel 2013 VBA Macro when another workbook is opened and closed will leave the empty Excel Window

Excel 2013 VBA Macro,when another workbook is opened programmatically from active workbook, it will open in different excel window (due SDI behaviour). When that workbook is closed from the active ...
0
votes
1answer
223 views

Macro for Reapply Filter on Excel 2016

I have a Mac and am running Excel 2016. I have an Excel sheet which is auto-filtered by date. Until recently, I had a macro saved which allowed me to press Command+Option+n and it would reapply the ...
0
votes
0answers
34 views

Auto Update data from one column in Excel file A to another column in Excel file B

I have 2 excel files for example myemployee.xls and salary.xls. In myemployee.xls, I have two columns: employees code and names like this and new employees will be entered here continously. A ...
0
votes
0answers
66 views

Use VBA in Word 2010 to search and manipuate a string

I have a macro that uses wildcards to find a particular string. I want to find another string within the result (preferably using wildcards), extract that substring and do something else with it. I ...
0
votes
0answers
25 views

I need assistance writing macro that will update a range of cells based on other cell values

I need help with a macro that will update a range of cells based on other cell values: For example on sheet one, I have names in column A1 and in rows B through Z I have their allocated hours by date ...
-1
votes
1answer
41 views

How can I make this macro capture the lastest data?

I have a macro recorded and its working, sort of. The problem is that its capturing the absolute cell and not the dynamic cell. Let me explain. I have an estimating page that I copy fixtures to. In ...
0
votes
1answer
764 views

excel macro - how to delete rows based on a cell value

I have the following spreadsheet **Columns a-i** A B C D E F **G** H I **Row 1** 003 His Dressing 3305 S4S 0 0 **35** 35 1 ...
0
votes
0answers
58 views

Find and Replace upper case

I would like to use the Find and Replace function to substitute a number of words which are in all caps, normal style, by a font in which they are in small caps with the first letter of each one ...
0
votes
0answers
104 views

Solver Across Multiple Worksheets

I've scoured the internet and Superuser for an answer to this, but found nothing that works... As I change data within my 7-worksheet workbook, I need to re-run solver across those 7-worksheets. ...
0
votes
0answers
20 views

(MAC) - Is it possible to be running a macro loop in the background while I work in another window?

I'm trying to essentially create a virtual mouse of some sort to run a macro in the background whilst I do other things in other windows without disrupting the process. Any software available to ...
0
votes
0answers
25 views

Shortcuts to move the cursor between languages

I am working on a document in Microsoft Word using two different scripts, namely Arabic (I created a customized layout keyboard using the Microsoft Keyboard Layout Creator 1.4, which has Arabic (Saudi ...
0
votes
0answers
9 views

excel sheet updating / copied sheet isn't

my excel spreadsheet is set on auto calc. The original sheet is updating when I make corrections. The sheet I have copied into my financial workbook (with the same formulas in it) is not updating ...
0
votes
1answer
84 views

getURL excel UDF

So in reference to a previous question I asked about displaying text and its hyperlink by referencing it in another cell, I found someone wrote this macro command for excel to retrieve the URL ...
0
votes
0answers
29 views

Font style formatting of a specific script among several scripts of a document

I am working on a document in which different language scripts pop up every now and then, even in the same sentence, e.g. the following excerpt [...] الْقُرْآن (al-Qur’ān). Now, 暴れる behave violently ...
0
votes
1answer
52 views

Duplicate rows based on its data

I have an excel file which I'll use to import hundreds of products in an e-shop. The excel have columns like this Title | SKU | Size | Price | etc I asked my clients to make the excel in very ...
0
votes
0answers
6 views

Excel 2007 run a macro by clicking a cell [duplicate]

Really simple, I would like to click a cell on a spreadsheet and have it run a macro. tried building code but it doesn't activate the macro. Sub scroll_Bar_update() If Target.Address = "$F$1" Then ...
0
votes
0answers
21 views

Unicode code points converted to characters in batch

To convert code points to characters you can, for example, place the cursor next to one of them and press Alt+x. I have a document full of Unicode characters' code points. I would like to substitute, ...
1
vote
2answers
77 views

How to unwrap a text in Microsoft Word?

I found this macro to unwrap but it unwrap all the document instead of just the selected text. How can I modify it to unwrap only the selected text? Sub pagebreaks() ' ' pagebreaks Macro ' ' ...
0
votes
0answers
13 views

Best way to perform action (e.g. open hyperlink in firefox) upon certain criteria met when clipboard contents changed?

At work, I lookup info on vehicles by their VIN (17-digit) code, e.g. 1FMCU59H98KC63209. What I want to be able to do is perform a certain action (open hyperlinks in Firefox to start iMacro actions ...
0
votes
0answers
103 views

Set keyboard macro to launch Windows 10 Metro apps

Recently picked up a keyboard with macro keys for the first time and they're incredibly useful, but it seems I can't set a macro that launches default Windows 10 apps (like Mail, Calendar, People, ...
0
votes
1answer
245 views

Insert formula if blank if next cell in row within range, but freeze data from previous cell/ remove formula

I have some users that are manually entering data from one excel generated from a reporting system and entering in that data into hundreds of cells per day. The format of the report generated excel is ...
0
votes
2answers
55 views

VBA Macro for fill random Dates

i have some 10,000 records in excel file. i want to put random dates for those 10,000 records. Random dates i will give manaully. For Ex:- Random dates:- 01-OCt-15 to 30-Oct-15 Emp id Emp Name ...
-1
votes
1answer
175 views

VBA excel macro to search open workbooks that have a specific text in the Filename

I am a macro novice trying to add macro code that will find workbooks where first 6 characters in the file name are "Custom" and any characters after that are allowable. The code would be added to the ...
0
votes
0answers
53 views

Hide column in report based on combo box on form

In Access 2010 I am trying to get a report to show or not show the contents of one column based on the value of a combo box on a form. For example, the column name in the report is "foo" and I only ...
3
votes
1answer
65 views

Apply an Excel VBA function to many files

I have an Excel VBA function and around 30 files with data (and the same data structure) to which I would like to apply the function to. My approach would be to write a macro in a separate Excel file ...
0
votes
1answer
493 views

Excel: Merging multiple Rows/Columns based on one repeated cell

I need to merge the information of multiple rows and columns based on a common value for an specific cell. I guess I can use a macro here, as the problem is I have to merge a lot of information, ...
0
votes
1answer
97 views

AutoHotKey: Pressing two keys simultaneously without repeats

Is there a way to press two keys simultaneously and bind it to a macro key (for example, pressing "s" and "d" simultaneously and then bind it to "a" key) without it having the "s" repeat multiple ...
0
votes
0answers
21 views

Notepadd ++ Macro

str# / xt / Name / Brief Description of Issue / Phone Number I'm trying to make a macro that would take this information and paste information into the fields of the table below to the appropriate ...
0
votes
0answers
159 views

Excel macro, paste not working

The macro I've written doesn't work and complains either of paste area not the same size as copy area, or a global not having been defined. The purpose of the macro (or at least the part that I'm ...
0
votes
0answers
578 views

Copy Data from one Workbook to Another in Specific Worksheet

I'm looking for a macro that can copy data from source workbook and paste it to master workbook based on specified sheet tabs. I not good at VBA. Searched the net and came across below code Sub ...