Is it worth learning VBA and Macro

Is there a macro for it? Doesn't want to learn VBA for nothing
at once

14 Aug 2012, 8:44 am
First name:

       Version: Office 2007

Hi Guys,
I am addressing the macro pros among you and trying to make it very simple. I don't know a VBA but I think it would be pretty awesome to have a macro for a certain thing that I have to do every day during the internship.
It would be great if you would tell me whether it is even possible to write a macro for what I want - if not, I don't even have to deal with VBA.

So, I have a Word document
The Dax rose by 4 points to 6599.
The price of gold fell 5% to $ 1,611.95.


......... ||| Change in% ||| Change absolutely ||| Final value
DAX ... ||| 0.06% .................. ||| 4.32 ........................... ||| 6599
Gold ... ||| -5.00% .................. ||| -84.84 ........................ ||| 1611.95

I get the table in the morning as an Excel file (here is just an example, the content is different). I add it to the bottom of the Word file and the text is at the top. I should formulate it because some colleagues get it on the Blackberry and the table is usually difficult to read.
Negative changes are red, positive changes are red (comes with the table)

What I want now:
1) Insert the respective numbers from the table at the top of the text
2) Tell Word that green 'rose' / red 'fell'.
3) Round the absolute values ​​to x number of digits.

Is it possible to combine these commands in a macro? If so, I would be grateful for tips, but in principle it would be enough for me to simply find out whether this is even possible.

Thanks in advance!


EDIT: Unfortunately you cannot upload pictures directly here.
currently online very irregularly

Aug 15, 2012, 1:12 am
Call name: Markus
Place of residence: Cologne rrh
       Version: Office 2007


without even having read your post in more detail:

1. It's always worth learning VBA. Although I could not and cannot program at all myself, VBA introduced me to programming, and I can now bake small, reliable procedures that help many people (hence the nickname macro Markus in my circle of friends).

2. Therefore: the macro recorder is your friend. Record what you want to do and post the code here - but please in code tags - then you will get help. And you can learn from it. And it's fun too (at least for me).


16 Aug 2012, 9:27 pm
First name:

       Version: Office 2007

if you convert the table - or the table parts - into text and use a tab character as a separator, you can do this quite well and with a little practice.

Cell 1 => Cell 2 => Cell 3

Then it works something like this:
Each paragraph of the document is extracted and split. A so-called "array" is then obtained, each with a cell value. You can analyze it and generate an output text as required.

Otherwise I can agree with the previous speaker: From Word VBA via and C # I came "naturally" to iOS programming. Ultimately, everything is based on similar concepts.

If you have a Word document that was created from the table as described (using standard Word tools), I can post code that you can use to convert it into speech output.
    UpAll times are
GMT + 1 hour
You can Post in this forum.
You can Reply to posts in this forum.
You can your posts in this forum Not to edit.
You can your posts in this forum Not Clear.
You can to polls in this forum Not participate.
You can Files in this forum Not Post
You can Download files in this forum

Related topics
Forum / Topics reply author Calls last contribution
Word VBA programming (macros): Macro via e-mail to other computers33alsimera443Nov 27, 2013, 8:46 am
Word VBA programming (macros): Open XP Word 2003 with macro in Windows 71dd3tj10430 Aug 2013, 7:37 pm
Word VBA programming (macros): Connect check box with macro3glory38722 Nov 2012, 11:32 am
Word VBA programming (macros): Change macros in several templates via script or similar0Kilmor18517 Oct 2012, 10:49
Word VBA programming (macros): Macro as add-in / command in the menu ribbon1mjocham86412 Jun 2012, 8:53 pm
Word VBA programming (macros): change macro1hamy178May 13, 2012, 9:21 pm
Word VBA programming (macros): Word Macro for searching and importing access data1ring-around490March 01, 2012, 2:29 pm
Word Help: WORD Form - Problem with inserting picture via Macro0Bensoné790March 28, 2011, 9:48 am
Word VBA programming (macros): Macro works in .doc, but no longer works in .dot3chris.815March 16, 2010, 12:02 pm
Word VBA programming (macros): Insert Jpeg file with Macro from the Internet into Word, how?14Weatherman1008May 29, 2009, 7:07 am
Word VBA programming (macros): Macro when selected in the drop-down form field0Bergelmir78025 Nov 2008, 7:04 pm
Word VBA programming (macros): Macro for Word0Baldur N.60307 Nov 2008, 9:26 pm
Baldur N.