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
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
90 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 address:...
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
23 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
111 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
120 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, etc....
0
votes
1answer
278 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
58 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
204 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
58 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
546 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
108 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
164 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
688 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 ...
0
votes
0answers
15 views

Inserting Another Files Information into Excel (last few characters are always changing)

I'm not sure if excel can even do this but I have created a file (Top 3 Sort) and I am working on creating a macro to pull information in from other files and put them into a formula {this part I ...
1
vote
1answer
38 views

Repeating values - Microsoft Excel [closed]

I am provided a large spreadsheet monthly that requires up to 6 instances of the same customer ID to be entered manually. I would like to design a Macro or VBA code that will take my customer list and ...
0
votes
2answers
86 views

I want to record a keyboard typing as though a human is typing [closed]

I am recording screencasts on OSX and Linux, and I am trying to set up some way to speed up recording of typing long blocks of code. I need a way to take scripts or macros that I generate, and have ...
0
votes
0answers
46 views

Using a macro, or any other way to sync date/time in different tables in excel?

I'm using a macro to sync data from a webserver, by import of CSV. The tables are unfortunately not synced and does not contain data for the same timestamps. I would like to use some way to ...
0
votes
0answers
41 views

Excel macro shortcuts do not work for macros showing absolute macro name in “view macros” window

Sorry for the long title, but that pretty much covers it. We are using a spreadsheet at work - it has a number of macros, all of which have keyboard shortcuts assigned to them. Some of them always ...
0
votes
0answers
160 views

ImageJ: How to measure multiple ROI in Batch Process using Macro and save each ROI's result in individual measurement table

I have 1000 images in a folder. Each images have four ROIs labelled A, B ,C and D and I wanted to measure it's grey value (min, max and mean). Is it possible to run a Macro from Batch Process that can ...
0
votes
1answer
32 views

Automating cell movement preferably using if/when style conditions

I want to fully automate the process of cleaning up exported data. I want to: Move the data in the overflow rows into their prospective column. I have tried the following code in VB. (This is trying ...
1
vote
0answers
43 views

VBA is disabled in Excel Home and Student 2010 (on XP SP3)

Everything seems to be working fine with Office, except that in Excel the VBA/Macro functionality is disabled. I cannot launch the editor, all macro-enabled files are interpreted as corrupt and the '...
0
votes
1answer
31 views

What software or programs can I use wherein I can record keystrokes [closed]

What software or programs can I use wherein I can record keystrokes? I will use this in filling out forms on the web, and I want to record several keystrokes, ie (like the examples below): tab tab ...
0
votes
0answers
39 views

Excel 2010 merge rows where data in duplicated except 7 columns

I have a xls file. I has some duplicate rows of customer names and other data that is identical. I want to be able to find the identical rows by customerid and copy data from one row to another ...
0
votes
1answer
151 views

How to assign a tooltip at a macro button added by customize ribbon in ms excel?

I want to assign a tooltip to a macro button added by me by customizing ribbon in options at file tab in MS Excel. You can see this snapshot for understanding that where and how I want the tooltip.
0
votes
0answers
89 views

How can I split a spreadsheet into multiple files based on column values while keeping other worksheets and macros in the resulting files?

I've been using the macro below created by mtone for these kind of tasks (splitting spreadsheets) and it works well, but I need to adapt it so that the resulting split files "carry" other sheets of ...
0
votes
1answer
33 views

Mass Find and Replace for Pictures Macro - Microsoft Word 2013

I have this macro that is able to do a mass find and replace across multiple word documents. I am able to do a find and replace for pictures (within a header) but when I implemented it within my macro ...
0
votes
1answer
50 views

Mass Find and Replace Issue - Microsoft Word 2013

I am trying to create a macro in order to do a mass find and replace across multiple word documents. I have found this one on the net and altered it to also apply for graphics however I keep getting a ...
0
votes
0answers
36 views

Creating a template and possibly macros for flashcards on MS Word

I've played around with creating two styles (different text sizes, alignment, etc.), one for each side of an index card, but it doesn't allow me to set vertical alignment. Do I have to make a macro to ...
1
vote
2answers
204 views

Excel: using 2 cells to collect data from a list

My Example is this: (workbook name"Rev) letter weekly bi-weekly monthly a 100 200 400 b 110 250 500 c 111 300 600 d 112 350 700 e ...
1
vote
1answer
58 views

Can I use this macro to convert first letter to UpperCase after comma?

I use this little macro to convert the first letter to UpperCase in a specific range Sub TitleCase() Dim rng As Range, cell As Range enter code here Set rng = Range("D4:D999") For Each cell In rng If ...
0
votes
0answers
75 views

Is it possible to run windows 8.1 without monitor, keyboard or mouse?

I have windows 8.1 and a macro recorder installed in my laptop. The macrorecorder executes some internet tasks automatically everyday in a schedule. I would like to transfer this automatization ...
0
votes
1answer
12 views

Assign Hotkey and Mouse Event to Logtiech Gaming Mouse

I have the Logitech G602 gaming mouse. Specifically, I'm trying to set a macro where the "D" key is pressed, followed by a right-click under the cursor. Even in the advanced settings, I couldn't find ...
1
vote
2answers
31 views

Guarding init modifications for both emacs23 and emacs24?

I have some emacs commands cribbed away and copy/paste them into ~/.emacs when needed. I want to add a code-folding macro, but the macro appears to be different for emacs23 and emacs24. The next two ...
0
votes
1answer
64 views

How can I apply this macro to all the pages in an excel file

I have a code to do a particular modification to some cells in a page. I'd like to apply this code at one click to all the pages in the excel file. I'm using VBA and am a newbie to it. Here's my code :...
0
votes
1answer
33 views

How can I specify a keyboard shortcut in Mac OS X?

How can I set the keyboard in Mac OS X 10.10 (Yosemite) so I can map the function keys to write specified symbols? I want to be able to write \( every time press F1.
1
vote
1answer
526 views

open html document with excel save as xls with batch file

I would like to run a batch file that will open an html file with excel and subsequently save the opened html file as a xls or xlsx document. Ideally, the batch would then be scheduled to run nightly....
1
vote
0answers
164 views

How to paste from Excel with VBA macros (xlsm) to PowerPoint (pptx) without warning

I teach using a combination of Excel and PowerPoint. I use an Excel workbook with a helper macro that makes it easy to display a cell's formula adjacent to that cell. I don't think it's directly ...
0
votes
0answers
126 views

How can I automate printing multiple documents, each of different page setup?

I would like to be able to print an entire document package by running a single program, script, etc. Each of the documents are contained in the same folder. The issue is that certain file types and ...
0
votes
1answer
240 views

How do I create a keyboard hook using VBA in MS Word 2007?

How do I create and use a keyboard hook to trigger VBA macros? This is related to the questions "How do I trigger a macro when someone types" or "Is there a typing event in VBA for MS Word". The ...
0
votes
1answer
68 views

Excel macro to search for duplicate names in all rows

In an excel 2013 spreadsheet, Windows 10, how can I execute the following pseudo code in a macro, which I think will delete spreadsheet rows with duplicate first and last names: from unknown last row ...
0
votes
0answers
189 views

.XLSM file has sharing violation when saving during remote desktop use

I have a large (~5mb) multi sheet excel macro file *.xlsm stored locally on my laptop. While using the file I occasionally connect to my office via remote desktop to do unrelated work. If I make a ...
0
votes
1answer
16 views

Run the same macros in two workbooks

I would like to run this same code in two workbooks. The code puts data labels on an xy scatter chart. Here is the code: Sub AttachLabelsToPoints() 'Dimension variables. Dim Counter As Integer,...
1
vote
1answer
36 views

How can I run a macro changing the value of the cell (no carriage returns)?

I can run a macro whenever a value is changed in a cell. However, I have to press the carriage return button to change the value of the cell. Is there any way to run a macro whenever I press a single ...
-2
votes
1answer
37 views

How to transpose range in Excel through insertion of new lines?

My data looks like this: a 1 2 b 1 2 c 1 2 I want to reorganise it so it looks like this: a 1 a 2 b 1 b 2 c 1 c 2