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

learn more… | top users | synonyms (1)

0
votes
0answers
7 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
2answers
20 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 ...
0
votes
0answers
11 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
1answer
25 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
3answers
9k views

Excel VBA Macro Sub or Function not defined

I used the macro recorder to generate a macro in Excel 2007. When I try to the run the macro, it tells me: When I click Ok the definition of the macro gets highlighted. I'm really confused ...
8
votes
6answers
32k views

How to turn hundreds of text URLs in Excel into clickable hyperlinks?

How do I turn a column of urls into hyperlinks, so that users can click on the url in a cell and have it open in a browser? I pasted 100 urls and each went into its own cell. When I double-click in ...
1
vote
1answer
39 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
2answers
45 views

Copy selected items in Excel filter

I have been strugling for past several day trying to resolve this issue. Here is what I have and what's needed: I've got about 20 Excel sheets that contain massive data (around 50K rows/sheet) that ...
1
vote
0answers
11 views

keyboard macro recorder for a dos program [on hold]

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
0answers
190 views

How can Ez Macros work on Windows 8?

EZ Macros (a nice software that records "keyboard macros") doesn't work on Windows 8 (64-bits), and I am looking for a way to make it work. When we try to record a macro, we can see the message ...
2
votes
3answers
7k views

Keyboard macro to change default audio device

Windows 7, Logitech G110 keyboard 2 audio devices (headphones and speakers) I am hoping to find a quick way to macro a key to switch to headphones, and a key to switch to speakers. Anyone have a ...
0
votes
2answers
4k views

Need macro to insert custom signature in Outlook 2007 email

I need a basic VB macro to insert a specific signature into an email message. Our support team uses a variety of different signatures to respond to different types of support needs. Currently, I ...
0
votes
1answer
35 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 - ...
1
vote
2answers
2k views

Office 2010 macro issues

I have some macro enabled word documents that worked fine in Word 2003, but in 2010 I cannot get the macro security settings to behave properly. When I first open a macro enabled document, I get this ...
1
vote
4answers
10k views

How to filter an Excel column for entries matching a master list

The general question entails sorting a large Excel 2007 list to find entries that match smaller subset list. I have a couple of ideas on how to approach the problem, but I lack the technical ...
0
votes
1answer
48 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
14 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
2k views

Excel 2010: dynamic update of drop down list based upon datasource validation worksheet changes

I have one worksheet for setting up the data sources of multiple data validation lists. in other words, I'm using this worksheet to provide drop down lists to multiple other worksheets. I need to ...
0
votes
1answer
18 views

How to size multiple images in Word 2011 via macro

I am importing screen shots from an Evernote file, into Word 2011 (Mac OS X). They look fine in Evernote, but are huge (20") in Word 2011. I need to quickly shrink them to 4" wide, and center them. ...
1
vote
0answers
11 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 ...
0
votes
0answers
8 views

Script/Macro to print 1st page of 1000 pdf to same printer

I have a folder with 100+ PDF documents each of varying number of pages. I need to print the first page of each document to a printer which adds a VAT code to the document (kind of like an ...
4
votes
9answers
26k views

Copy Excel worksheet and maintain relative cell reference in formulas

Another copy problem in Excel: How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula =B!23 becomes ...
0
votes
1answer
8 views

Looking for an application which types the string or text I give to it

The use scenario is typing the product keys into the mutliple textboxes which "tabs" automatically when I type and not when I paste. I don't think such an application would be common, so thanks in ...
0
votes
1answer
3k views

How to customize Paste Value Excel Short Cut

I was reading in this other post about how to set up a macro to past values in Excel. I understand how to create he macro but I would like to set the keyboard shortcut to Ctrl d but excel pops up an ...
3
votes
1answer
2k views

How to add a custom command macro in Windows 8 speech recognition

I have tried a few options but its not working for me. I am using Windows 8 Pro. Can anyone show me how I can write my own custom command macros for speech recognition in Windows 8? I have tried ...
0
votes
1answer
3k views

Copy/move values matching a pattern to another column

I have a worksheet where we need to move all the values matching a pattern to different columns. For example, we have a B column with values that are one or more letters followed by one or more ...
0
votes
1answer
26 views

Create an Excel Macro to categorize data based on values (by writing data to a cell based on the value in another cell.)

I'm completely at a loss for complex excel tasks, but I'm facing the following situation. I've got a large list of inventory items with various lengths, but I need to convert the exact lengths (as a ...
0
votes
0answers
24 views

VBA Excel: Macro working well, add-in does half of the job

I created a macro that: 1.takes the value in cell "D11" then 2.trims the value acording to some criteria, then 3.opens another workbook ans searches the trimmed value then 4.copies some info to ...
0
votes
1answer
373 views

How do I select text between two “bookmarks” in Word VBA?

Note: Originally I asked how to select text from a certain point downward, but I've got a solution for that: Dim f As Word.Field For Each f In ActiveDocument.Fields If f.Type = wdFieldAddin And ...
0
votes
1answer
43 views

Months and Date keep being switched around when running VBA

I have a column on my sheet, Column F which is full of dates. Now I need these dates to be in this format "dd,mm,yyyy" but sometimes they are in text form, us/armenian format in the original data. Why ...
0
votes
0answers
31 views

Automation of solver in Excel by VBA macro code

I'm solving a 3rd degree polynomial equation, e.g., -0.003x3 +0.195x2 -1.087x -180 = 0 in Excel. I can do this by SOLVER of Excel and can find the value of x. The problem is the constant term ...
0
votes
1answer
8 views

Notepad++: Insert comment-sections of same length via Macro/Shortcut?

I'm often using comments (using =====) to divide sections within my files in the same way which look always the same, e.g.: #===========================================# #============== IMPORT STUFF ...
0
votes
2answers
45 views

Excel concatenation of one column based on values in another

Similar to this: Excel - pivot values in one cell (as comma-separated value) Except it can be a VBA solution, and I do not have duplicates in Column A. Instead, there are blank rows below each value: ...
1
vote
1answer
88 views

How do I copy hyperlink only (and not text) to another cell? [duplicate]

I have a spreadsheet where column A displays names. There are a few hundred names and each has a different hyperlink (which links to that person's web page). I want to transfer those hyperlinks across ...
0
votes
1answer
29 views

Sort with a Macro

I have a spreadsheet with 8 columns of data. (Row 1 contains my headers). I am trying to record a macro that I do not have to edit afterwards. I press record macro, I highlight my data, I go to the ...
0
votes
0answers
10 views

Open image on specific monitor (trigger with Windows Speech Recognition)

I am using a speech recognition macro to open an Image with Irfanview on my Windows 7 system. What I want to do moreover, is to force any new window emerging due to the macro to open in a specific ...
0
votes
1answer
138 views

How can I create a persistent data connection from MS Project 2013 to Excel 2013?

I'm trying to get dates from an MS Project file to come across to a separate Excel file which I'm using to run conditional formulae on to handle the project status matrix. The catch is that I need ...
0
votes
1answer
47 views

How can I sort data that is organized in 4-row chunks?

I have an Excel document with six columns and 57,000 total rows. Each record comprises four rows, that is, each set of four rows goes together. How can I sort this data by one field while keeping the ...
0
votes
0answers
36 views

Removing an OTF macro from a Razer Deathstalker

I recently bought a Razer Deathstalker, and the other day I managed to activate the OTF macro recorder by accident, so now I have random gibberish and key presses bound to regular keys, so typing ...
3
votes
1answer
6k views

Word: Resize Image by Percent - Macro

I routinely paste many screen captures into Microsoft Word 2007 and then have to manually resize them to around 75%, which becomes very tedious. The screen captures are all different sizes. I've ...
0
votes
1answer
25 views

PPT Macro go to last instance of certain slide layout

I have a macro (below) for a button that I need to use. What I want to do is change the value of lngCurr to the layout 'section header' and make it so when the macro runs, it takes the user back to ...
0
votes
0answers
65 views

Saving excel as csv without messing the formula

I have an Excel workbook with 55 sheets. I would like to save the sheets as csv files (file name is the name of the excel sheet). When I run the macro, the files are created as desired but the macro ...
0
votes
3answers
642 views

Shortcut or macro for changing font type in Microsoft Outlook

Is there a keyboard shortcut for changing the font in Outlook on Windows? I have to alternate between Calibri and Courier constantly for technical reasons and clicking on the font dialog every time ...
1
vote
0answers
22 views

MS Word 2010 macro to renumber pages within the footer of all sections.

My problems is that I also have a divider page which originally I provided -1 in the page field to get the appropriate count. Could you please advise how I can manipulate the macro to take this back ...
1
vote
1answer
118 views

Pull Data from Excel Worksheet to Another Based on Defined Values

I have two excel worksheets which have data cells. I want that if a cell in column J equals a certain value, let's saying "Negotiating", then it automatically pulls that row to a new worksheet. The ...
0
votes
1answer
82 views

VBA EXCEL: find method not working when looping through each cell in selection

I'm trying create a macro that, after a range selection, will tell me how many 20ft or 40ft containers where found in the sample. The macro basically looks for the string "1x20" or "1x40" and when ...
1
vote
1answer
205 views

Open new ConEmu tab with the same working directory

I have a ConEmu macro for Ctrl+T which runs Task("Powershell"). My Powershell task just runs powershell with the argument \dir %userprofile%. The Macro tab in "About ConEmu" says that the Task ...
0
votes
2answers
73 views

VBA Excel 2011 for Mac: Create custom category for user defined function error

I created several functions i.e.: "cal_adval". I would like to add it to a new function category named "Custom Clearance" I read the documentation, and wrote this macro: Sub add_category() ...
-1
votes
1answer
37 views

How to split up above single cell Address value into multiple cell value through macro

How to split up the below single cell value into multiple cell value through macro ? So, this... A1 = MISS FirstName LastName***95*SPECIAL ROAD**LONDON SW92**SW929AB ...should split as below, B1 ...
0
votes
2answers
89 views

Split single column data into multiple columns based on leap year in Excel 2013

I have about 100 files of MS Excel which consist of weather data. I need the data on yearly basis but the file has a single column with data of about 140 years and manually copy-paste is very time ...