macro

Fri
11
Feb
John Lister's picture

Microsoft Tackles Macro Malware

Microsoft is making it harder for scammers to distribute ransomware and other malware through Office documents. However, the tighter block on visual basic macros running by default may frustrate some users. A macro is a way of reducing a series of ... instructions to a single instruction, while VBA (visual basic language) is a way of handling macros in Microsoft programs. It's often used for frequently performed tasks. To give a hypothetical example, a user could create a macro in a spreadsheet that means pressing a couple of keys together which tells the computer to check two columns for any ... (view more)

Tue
03
Nov
Dennis Faas's picture

'Win Macro', and 'Registry Life'

Win Macro WinMacro is a simple Macro recorder/player for Windows. It can record whatever you do on your computer, and then 'replay' it. It doesn't record video, instead WinMacro uses Windows hooking mechanisms to monitor your mouse and keyboard ... events, and allows you to re-execute those same commands by automoation. This is a huge time saver if you ever need to do repetitive tasks. http://senthilthecoder.com Registry Life Registry Life helps correct errors in the Windows registry, increasing the working speed and stability of the system. It's a compact, simple to use, and free solution for ... (view more)

Tue
26
Aug
Dennis Faas's picture

Create a Macro in MS Excel Using MS Visual Basic

This is a different method for creating a macro in MS Excel 2007. You can use this method if you want to write your own script or if you want to copy and paste a part of another macro into an existing macro. You can also use this method to copy and ... paste a new macro. Follow the steps below:If the Developer tab is not available, do one of the following to display it: Click the Microsoft Office Button, and then click Excel Options. In the Popular category, under Top Options for working with Excel, select the Show Developer tab in the Ribbon check box. Click OK. To set the security level ... (view more)

Wed
11
Jul
Dennis Faas's picture

'Win Macro', and 'Wavosaur'

Win Macro WinMacro is a simple Macro recorder and player for Windows. It can record whatever you do at your Windows Desktop, and can replay it exactly using windows hooking mechanisms to monitor your mouse and keyboard events. For example, use ... WinMacro to connect to the internet using dialup, open browser windows and type URLs for checking mail. Simply play that file back, and everything takes place automatically. http://www.geocities.com/win_macro/ Wavosaur Wavosaur is for editing, processing and recording sounds, wav and mp3 files. Wavosaur has all the features to edit audio (cut, copy, ... (view more)

Tue
06
Mar
Dennis Faas's picture

Customize your Keyboard to Run a Macro: MS Word

One of the fastest ways to run a macro is to create a shortcut key for it. You don't need to put a button on your toolbar or even click anywhere. As a matter of fact, your hands don't even have to leave your keyboard! You can create a shortcut key ... to run a macro before you even record it. Follow the steps below to learn how. Choose Tools | Macro | Record New Macro or double-click REC on the Status bar. Enter the name for the macro. Click Keyboard to see the Customize Keyboard dialog box. Choose the macro name. Click the Press New Shortcut Key box. Press the key combination you want to use. If ... (view more)

Thu
01
Mar
Dennis Faas's picture

Create a Toolbar Button for Any Action: MS Word

I bet you didn't know that you could have a button for any command or macro did you? Well the good news is that you can! Follow the steps below to create one! Choose View | Toolbars | Customize and select the Toolbars tab. Click to place a check ... next to the name of the toolbar to make certain the toolbar is currently on the screen. Click the Commands tab. Under Categories, choose the one containing the command you want, or Macro for a macro you created yourself. Choose the command or macro name and drag to the toolbar location. Choose Modify Selection, actions and continue as before. Your ... (view more)

Fri
23
Feb
Dennis Faas's picture

Create a Toolbar Button: MS Word

You can customize Word by creating a button on a toolbar for a macro or command that you find yourself using more and more often. It is more efficient and much easier to use a toolbar button than to choose a macro from the dialog box or to choose a ... command from a menu, don't you agree? You can quickly create a button for a macro before you even begin recording. Follow the steps below to learn how: Choose Tools | Macro | Record New Macro or double-click REC on the status bar to begin recording a macro. Enter the name you want to call the macro. Click the Toolbars button to see the Customize ... (view more)

Thu
22
Feb
Dennis Faas's picture

Working with Macros: MS Word

In my last article I told you how to Delete a Macro and how to Edit a Macro . In this article, as promised, I will show you how to rename a macro and copy a macro. To rename a macro, follow the steps below: Choose Tools | Macro | Macros. Select the ... macro you would like to rename. Choose Edit. This opens the Visual Basic editor. When the Visual Basic editor pens, change the name of the macro to what you would rather it be. Close the window. It's really pretty simple to do isn't it? To copy a macro, follow these steps: Access the Macros dialog box by choosing Tools | Macro | Macros. Select the ... (view more)

Wed
21
Feb
Dennis Faas's picture

Modify an Existing Macro: MS Word

Sometimes after you have recorded a macro, you can't remember the name or it doesn't do exactly what you wanted it to do or you want another macro that is almost the same. Luckily, all of these things can be taken care of. You can change an existing ... macro by changing its name, making a copy of it, deleting it or changing the actions of the macro. Macros are recorded in a programming language called Visual Basic for Applications (VBA). The VBA program can be changed to modify the action of the macro. The language may be confusing at first, but a closer look will show you that the code echoes ... (view more)

Tue
20
Feb
Dennis Faas's picture

Record and Run a Macro in MS Word

Many times you find yourself doing the same task over and over and sometimes a task is very difficult for a new user or it's a task that is used so infrequently that even an experienced user has to take the time to figure out exactly how it's done ... again! Luckily MS Word enables you to record the steps to accomplish your tasks and store them as a macro. A macro lets you run the steps quickly by pressing a shortcut key or by clicking a customized button on your toolbar. Macros are automatically stored in the Normal template. When you exit Word, you will see a prompt asking whether you want to ... (view more)

Pages

Subscribe to RSS - macro