Question about Business & Productivity Software

1 Answer

Writing macros Hi, How can I start writing macros.Normally a situation comes when I need to convert a text to excel format with the help of macro.How can I start?

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 13 Answers

Anirbanmj

Macros for Excel and the rest of the office suite are based on Visual Basic for Applications (VBA) which is a subset of VB programming language.

If your not familier with this language then i would suggest "Googling" VBA Introduction or similar and have a look at some introductory info. If you are ok with VB then you can record doing a task you want to do and then look at the code generated to see what it has created.

Posted on Feb 03, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Hi Team, I have created macro in MS Excel2007 and after executing macro output file will be created MS Excel2003. Once MS Excel2003 file closed and reopen all the formating lost. How can overcome this...


It is unlikely that you can really overcome this as Office 2003 and Office 2007 have completely different file formats and structures. But if you output it to an Office 2007 file and use the Microsoft converter for Office 2003 than it may work. The converter can be found here

Jun 22, 2011 | Microsoft Excel 2007 0882224152648 Full...

1 Answer

Hello, I have got a problem in excel and thought some expert here can solve it. I have a worksheet with thousands of rows, in following format 1:00:00 1:59:00 30/12/2009 3:00:00 3:59:00 30/12/2009...


There are two ways to solve it, with a macro and without.
In either way, the concept is to determine the difference between rows, if it is more than 1 hour, then you have detected the missing row.

With a formula, you can tell excel to put true if it is the case and correct it manually.

For a macro, basically you detect the same thing and then insert a line with all the appropiate information. I can write the code for you, but i would prefer to have the sheet. You can send me the information to my mail lucho_lnc@yahoo.com

Mar 03, 2010 | Microsoft Excel for PC

1 Answer

VBA and macros


To understand VBA, you download HERE and read it.

Jun 22, 2009 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...

2 Answers

Using Macros in Excel sheet Requires Programing.. or it can be done, as we do Vlookup and other formulas


Creating Macros does not require programming. The only suggestion I would make if you are new to macros - break down your task to very small sub tasks, in order to avoid confusion.

Jun 09, 2009 | Microsoft Excel for PC

1 Answer

Macros


After you record your macro do the following.
Open the excel file contains the macro. Go to tools and go to macro and click on macros. Select the macro you wish to add the close operation. Click on Step into... This will open up the visual basic editor. In the code window, at the bottom row you will see End Sub. Right before that row, type workbooks.close
Save the macro by clicking the save button. And you can run your macro to see if it works. I tried, it does :) Good Luck :)

Aug 18, 2008 | Microsoft Excel for PC

1 Answer

Macro


Hi motilal

Follow these steps to create multiple macros

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, and then click OK.

Note The Ribbon is a component of the Microsoft Office Fluent user interface.
To set the security level temporarily to enable all macros, do the following: On the Developer tab, in the Code group, click Macro Security.


In the Macros Settings category, under Macro Settings, click Enable all macros (not recommended, potentially dangerous code can run), and then click OK.

Note To help prevent potentially dangerous code from running, we recommend that you return to any of the settings that disable all macros after you finish working with macros.
Open the workbook that contains the module that you want to copy and the workbook that you want to copy the module to.
On the Developer tab, in the Code group, click Visual Basic.
On the View menu, click Project Explorer .
Drag the module that you want to copy to the destination workbook.

Regards,
TheAssembler

May 06, 2008 | Microsoft Excel for PC

2 Answers

I need to Have a timer created in excel


Hi, I was looking to create a timmer. with stop and start option on excel.I have found the anser withyahoo group answers, that was help full and free, i got the VB macro programee. if you still can help me , here is the query,

I need a timer with stop and start option,

when i click on the star button i want the present time coming up on a cell(any cell) and when i click on the stop, i need to get the presen tme on the other cell, i need to clculate the time spent between the 2times.

i also need the time geting accumalated in the different sheet to calculate, how many times i have clicked and the difference.

Thank you for you any help you provide.

Regards

Rochboy

Apr 03, 2008 | Microsoft Access 2000 (077-01277) for PC

1 Answer

Macro in excel


Open up your Excel and hit ALT + F11. This opens up the VBA editor.
You can then right click and click New Module and write your macro in there.

Mar 22, 2008 | Microsoft Excel for PC

1 Answer

Macro on excel


Macros are a timesaving feature that allow you to record a sequence of actions that you do in excel, and replay them back later.

You give each macro a name, and you can invoke them later, and Excel will "do" whatever it is you did when you recorded the macro.

To record a new macro:
1) Open Excel
2) Go to Tools->Macros->Record New Macro...
3) Type in a name for your macro and hit OK

(A new toolbar will popup with a "stop" button on it. Excel is now recording everything you do)

4) Do something, like, for example, select some cells and make them bold.
5) Click the "stop" button.


Now your macro has been recorded! You can play it back later by:

1) Open Excel
2) Go to Tools->Macros->Macros...
3) Select your macro from the list
4) Click "Run"

The actions you performed earlier will now be executed.



-------


Macros are written in Visual Basic for Applications, or "VBA". It is a programming language which uses the Excel Object Model to perform various actions. You can edit and create custom macros by writing the code manually in VBA. To do this:

1) Open Excel
2) Go to tools->macros->macros...
3) Select an already existing macro
4) Click "Edit"

(The visual basic editor will open, showing you the code for your macro)

At this point you are writing a program in Visual Basic. To learn how to edit macros, you need to learn visual basic, as well as the specific quirks related to excel macros in visual basic.

Recording a macro, and then using it as a template while you edit it is a common trick for making macros manually more quickly.

If you are not familiar with VB, I would not suggest attempting to edit your macros in any but the most simplest of ways. If you're brave, you can try to learn about editing macros in VBA here:

http://www.anthony-vba.kefra.com/

Jan 28, 2008 | Business & Productivity Software

1 Answer

HOW TO USE MACROS


Dear ROCKY open Tool Menu-Macro-record new mecro-give the macro file name like rocky-do your work when you finish your job then stop button mecro and save it . next day when you do same job on other file then again open macro and run your macro file and get same job on your new file

Sep 20, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

144 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18299 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...