Tagged Questions

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 [tag:vba] tag instead of this one if the question concerns a Microsoft Office product. This helps ...

learn more… | top users | synonyms (1)

0
votes
2answers
38 views

How can I perform search & replace in a text file based on conditions?

I have a large text file (.bib) with lots of double entries for some fields. Essentially, the file is a .bib-file (more info here) which has roughly 1000 entries. The content is structured like this: ...
1
vote
1answer
39 views

Defining math shortcuts/macros for Microsoft Word

Is it possible, in any version of Microsoft Word, to define shortcuts for recurring mathematical expressions? (preferably in a way that allows updating all occurences at once if needed) For instance, ...
0
votes
1answer
27 views

Running a set of data through multiple calculations and outputting the results back on the data sheet

Using Microsoft Excel 2013. I am creating a calculation sheet for quickly evaluating the metrics of rental properties. I have a sheet called CALCULATIONS with several calculations, and several ...
0
votes
0answers
43 views

Copy-pasting between two computers , or a virtual machine and host?

In my work, I find myself hopping between a VPN machine and my host machine to do work. Lately I've been using https://www.cl1p.net/ a lot , for copy-pasting between 2 computers. A nice site, ...
0
votes
1answer
80 views

Excel 2010 Formula: Finding a dynamic column based on string value, then count # of “0's” within that column

I have tried looking at many different potential avenues at solving this; INDEX, MATCH, DCOUNT, HLOOKUP with INDEX & MATCH, COUNTIF with INDEX & MATCH. What I'm looking for is a way to set the ...
0
votes
0answers
36 views

Excel Macro for preserving line breaks in cell text

I have an excel sheet containing text that I require copying and then pasting into a 3rd party application (bit like notepad). I need to use a button to copy the text so it cannot be edited or ...
0
votes
1answer
47 views

Keyboard Shortcut to Run Macro in Excel for Mac

Basically the title says it all. In the editor in Excel on Windows, all you have to do to run a macro is press F5. What is the keyboard shortcut to do this on a Mac?
0
votes
0answers
15 views

Pasting a formula on many excel files using a macro

So basically I have around 500 excel files with different names. But they are in same format. I want to paste my formula in sheet(3), Cell (AW6:BL6). This is what i'm trying. Private Sub ...
1
vote
1answer
118 views

AutoHotkey, don't get the solution

I really need your help. I trying to program an AutoHotkey script but I not quite getting a working solution. My current AutoHotkey script is: #IfWinActive Guild Wars 2 shift & 1:: Send, 1 sleep ...
0
votes
1answer
36 views

How to Run macro in excel instance “2” from excel instance “1”

Lets say i have already opened Workbook 1 in Excel instance 1 and Workbook 2 in excel instance 2 And i have macro called "AAA" in instance 1 and "ASD" in instance 2 i want to call "ASD" in instance 2 ...
0
votes
0answers
198 views

Select item from drop down menu and run macro

I have a drop down list in a sheet called 'Report', cell B9. The source for this list is in another sheet in the same workbook, 'List' with range 'A1:A32'. When the different items in this list are ...
0
votes
0answers
138 views

Prevent 'Run-time error '7' out of memory' error in Excel when using macro

I keep getting this error whenever I run a macro in my excel file. Is there any way I can prevent this? My code is below. Debugging highlights the following line as the issue: ...
0
votes
0answers
47 views

Macro to copy values to new sheet and prompt user where they want to save

I'm looking to create a macro in Excel 2007 which will do the following: copy the formatting and values from a sheet called 'report', insert this into a new workbook, naming the file with the value ...
1
vote
1answer
118 views

Excel: How to extract group of the same rows and their values into columns?

How can I extract the second table from the first one? I need to extract those titles that have exactly three costs (in the following example: f1 and f3). I tried using pivot tables but could not ...
1
vote
0answers
114 views

run-time error 1004 Application Defined or object-define error

I have this macro that I wrote: Dim lastColumn As Long lastColumns = wkbWorkbook2.Worksheets(2).Cells(1, Columns.Count).End(xlToLeft).Column 'this is the highlighted part in debug SourceRange.Copy ...
0
votes
1answer
46 views

Autohotkey - How to overwrite an existing hotkey, while remapping the original hotkey

I want to do a seemingly simple action but I'm having trouble figuring out how. I want to remap Ctrl+F -- which natively opens a 'find' window in the program I'm using -- but I want to create a new ...
1
vote
1answer
29 views

How to change superscript text so that it is displayed in parenthesis in Word?

How to change superscript text so that it is displayed in parenthesis in Word? I have a massive amount of interlinear text in the format: x y where y is the translation of the word x. I would like ...
0
votes
1answer
169 views

Use an user defined function for data validation

I created a named range which is the result of a user definer function. Let say my rage is named List and has three items, if I select three cells and enter =List and press Ctrl+Shift+Enter, I get ...
-2
votes
1answer
42 views

sum the values in a column and add the sum to the filename of a workbook

Hello I have been able to create new worksheets based on unique values in a column. In addition to this, i want to sum up the values in a column and include this sum in the filename of each ...
1
vote
0answers
56 views

Deploy macros and ribbon button - Outlook 2010

We need to deploy macros across our organization, along with a shortcut button up on the ribbon, in Outlook 2010. Right now, the way we're slated to do this is by copying over and overwriting the ...
0
votes
1answer
57 views

Excel Macro: Setting Character Range to Bold garbles text

What I want to do is the following: I have around ~1400 rows full of data, of which the last column contains a lot of text. Here's an image to show what I mean: image removed because I can only post 2 ...
1
vote
1answer
89 views

Transferring custom excel ribbons in local computer to other computers in Excel 2010

I have created certain Macros. By customizing the ribbon ,i converted the Macros into buttons. I saved the file as an add-in (.xlam). Now, when i send the file to other people, I shall tell them to ...
1
vote
1answer
74 views

How do I debug Excel / OpenOffice / LibreOffice macros - getting started

How do I get started with debugging VBA macros? This is to help to locate faults and mistakes within the code and the data it handles.
3
votes
1answer
44 views

Emacs - move cursor back after mark-whole-buffer & indent-region

I'm Emacs newbie and for automatic re-formating of my source codes in Emacs I've created simple macro using mark-whole-buffer and indent-region commands, mapped to C-j shortcut: (fset ...
0
votes
1answer
149 views

Merging multiple excel files in to one file

This is my macro for merging all the files in one directory to one excel sheet. I am unable to find why its not working as per expectation. I have thousand rows in each file. It copies 1000 rows from ...
0
votes
0answers
41 views

Change Excel cell value on each saved revision

Is there a way of increasing cell values on each file save? I have a version number on a macro-enabled spreadsheet, and I want it to increase by say 0.1 each time I save the file. I would rather not ...
0
votes
1answer
16 views

Word 2010: Loop in Active Table Cell

UPDATE: I am now working from the top of the Active Cell with this code: Selection.EndKey Unit:=wdLine Selection.TypeText Text:=", " Selection.Delete Unit:=wdCharacter, Count:=1 I need it to loop ...
-2
votes
1answer
32 views

how to run four macros by click one button?

i have four groups of shapes. And each group got 6 shapes, and i would like to random choose one of 6 shapes in each group. And because i got four groups, which means every time i click a button, 4 ...
-1
votes
1answer
37 views

Execute an Excel 2010 Add-In

An excel add-in seems to be the easiest way to share a macro I created with my team. I saved the workbook as a .xlam file and installed the add-in so it shows up under the addins button with a ...
0
votes
0answers
103 views

Could not load an object as it is not available on this machine - Excel 2010

Got an issue that is driving me mad. Every time a user accesses this file, he always gets the error messages: "Could not load an object as it is not available on this machine" & "Compile error in ...
0
votes
1answer
68 views

Word 2013: Disabling spellcheck for following-typed words, then reenabling for ones after

I have 2 macros, one that switches to Courier New and one that switches to Calibri. I use these to write a few lines of code in between and as part of regular paragraphs. The font change helps ...
2
votes
1answer
77 views

Excel Help: How to scan a row and return the value of the first cell in that column

I have a matrix of numbers and the matrix has column header -- say like this: a b c d e f 0 0 0 1 0 0 0 0 1 0 0 0 What I want to do is to search for each row for the element 1 and return its ...
-1
votes
1answer
3k views

How to write Excel macro to copy selected row of data between two sheets?

I'm not really experienced in the whole VBA area, i get how macros work but this is just out of my reach. Basically as i stated in the title i need to write a macro that will copy the selected row or ...
0
votes
0answers
442 views

Hack for running multiple iMacros in random fashion

I have 20 iMacros (for browser) and they are specific to different URLs. I run these macros one after another, and then repeat or loop all of them 10 times. But within that loop, i need those 20 ...
0
votes
2answers
70 views

How to shift unique values down a column to the same value in another column?

My friend has two columns where one has unique values and another column has those same values but also duplicated like shown below Column 1 Column 2 ABC123 ABC123 CDE456 ABC123 EFG789 ...
1
vote
2answers
46 views

String Manupulation in VBA

I have single column that needs to be split to multiple, like Text-to-columns in excel. However there is a small challenge. Conventional delimiter will not work. Consider the string below Original: ...
0
votes
0answers
34 views

Excel workbook contains a userform which opens up black on 8.1 office 2010

The userform within the worksheet opens black on windows 8.1 office 2010, yet it opens fine on XP with office 2010. It's a excel 79 to 2003 xls file. We checked trust centre on 8.1 but no joy, ...
0
votes
0answers
18 views

Server Tasks Automation

I would like to run some tasks on my Windows 2008 R2 server and need some kind of automation. Right now I am running the tasks with my Macro Recorder - BUT - I need to be connected via RDP in order ...
0
votes
1answer
30 views

Store user's personal Excel column filters in a cookie-like file?

I'm developing a reporting app (how exciting!) that puts out HTML, PDF, and Excel reports. In the HTML version I let the user select which columns they care about, and filter out the others. This is ...
1
vote
1answer
351 views

Easily type Unicode characters using AutoHotKey?

For example, I want to be able to type → (right arrow) using AutoHotKey's text replacement feature, and this is what my script looks like: ::|rarr::{ASC 2192} So when I type |rarr in my text editor ...
0
votes
1answer
62 views

Create a shortcut for Notepad++ to reopen a closed tab?

To reopen a closed tab in Notepad++ you press ALT+F&1. I was wondering if there was a way to make a macro or program to do this so that I can press link it to the shortcut CTRL+SHIFT+T instead, ...
0
votes
0answers
81 views

How can a Macro sort dates from oldest to newest?

I'm doing account statements in a bank and I need to be able to make them fast, so I am using macros for making this process. However, there is a step that I always have to do that a macro won't let ...
0
votes
2answers
88 views

VBA Excel: How to assign .txt file content to a string type variable?

I made a little sub in excel that sends an email according to the parameters you enter: Sub Mail_LSP(mailsubject As String, consignee As String, coalcopy As String, mailbody As String) Dim mlook As ...
1
vote
1answer
1k views

Find and replace multiple words in a column in Excel 2007

Sub xLator2() Dim s1 As Worksheet, s2 As Worksheet Dim N As Long, i As Long Dim from(), too() Set s1 = Sheets("Sheet1") ' contains the data Set s2 = Sheets("Sheet2") ' contains the translation ...
1
vote
0answers
25 views

keyboard macro recorder for a dos program [closed]

I need a keyboard macro recorder (possibly free) for a dos program running inside DOSBox window in text mode which is able to wait until a certain text string appearing inside the window before ...
0
votes
1answer
30 views

Format text list with corresponding key into spreadsheet

I have a text file with dates arranged as such. name1 2010-01-02 (i) 2010-05-07 (i) 2010-06-12 (i) name2 2010-01-02 (i) 2010-05-07 (i) 2010-06-12 (i) name3 2011-01-05 (i) 2011-05-05 (i) 2011-06-14 ...
0
votes
1answer
222 views

Hide columns based on content (sum of rows)

I'm trying to hide columns based on the sum of selected rows (i.e., cells) in those columns. For example - if the sum of E9:E12 is 0, then hide column E. Additionally, and probably a little harder - ...
0
votes
0answers
49 views

Can I write a Macro to export data from Web?

I need to write a macro that can import data from the web (salesforce.com). Is it possible to pull data from the web through a macro? The data I will pull from salesforce.com, is a monthly task. Can a ...
0
votes
1answer
127 views

For loop macro in excel

I am completely new to Excel, but I want to make a macro where I can fill in two columns, and the start and end number of the rows, and it will do this: (A1*B1+A2*B2+A3*B3...)/((SUM of column B)/N)) ...
0
votes
0answers
44 views

Convert HTML to Word and embed file hyperlinks as attachments.

I have some HTML files that I'm opening with Word and saving as docx files. I have some macros I run to break the links on the graphics so that they get embedded in the doc file, but I haven't figured ...