[Kindle] Free - Excel VBA: Ultimate Excel VBA Programming Step by Step Guide to Go from Beginner to Expert @ Amazon AU/US

940

Affiliate

Go to Deal

Cashback

Taegukgi on 13/10/2019 - 20:28 amazon.com.au (2767 clicks)
Last edited 13/10/2019 - 20:36

This post contains affiliate links. OzBargain might earn commissions when you click through and make purchases. Please see this page for more information.

Amazon US link

Was US$2.99.

VBA Programming in Microsoft Excel is an incredibly versatile and powerful language for automating all kinds of complex tasks, but only if you know how to use VBA to its full potential!

Need to learn how to program using VBA in Excel fast?
Microsoft Excel can be used for so much more than simple spreadsheets. When you understand how to use VBA in Excel, you unlock a world of computing power and possibilities. Get the most out of Excel simply by following the easy instructions fully explained inside this guide. It doesn’t matter if you have never programmed in Excel VBA before. This step-by-step guide gives you everything you need to know to do more with Excel and VBA than you ever thought possible!
Fully up to date for 2019

Here is a preview of what you will learn in this guide:
Introduction to Excel VBA
What Is VBA?
The Difference Between VBA and A Macro
The Structure of A VBA Code
The VBA Module Outline
VBA Procedures and Routines
Sub procedures
Function procedures
The Meaning of Statements
Declaration statements
Executable statements
Assignment statements
Objects
Classes
The Purpose of Collections
The Relationship Between Different Objects
Properties
Methods
Variables and Arrays
Conditions
Loops
Getting Used to the Developer Toolbar
Understanding the VBA Development Environment
Check out your first recorded macro
Understanding Excel Dot Notation
Conditional Logic
VBA Examples and Techniques
Copy and Paste
Adding Buttons to Help You Stay Organized
The Most Popular Excel Functions
Frequent Troubleshooting
And so much more!

Related Stores

Amazon AU

Marketplace

Amazon Cloud Reader

• 

  CyberMurning on 13/10/2019 - 21:17

  can VBA on excel do something like this below?:

  platform: Windows
  at my workplace we have multiple overnight reports with .REP extensions (those are actually TXT files we can open with notepad). not big files just 10-20 kb each in size.

  Every morning i have to do:
  1. right click a file and select 'open with' then choose MS Word
  2. delete first page (always blank)
  3. rotate to landscape layout
  4. select all contents then change font to 8
  5. search for word "WARNING" and then highlight that word (if found) in yellow (could be none could be many)
  6. save the file (as word doc) in the same folder.

  • 

    frisbeedog on 13/10/2019 - 21:34

    +2

    VBA in Word could

    • 

      CyberMurning on 13/10/2019 - 21:36

      oh yeah doh i was using txt files and ms doc of course nothing to do with excel.

      • 

        fishball on 14/10/2019 - 00:21

        +8

        I had a go at it for fun (this is word VBA so you don't have to load objects into Excel and whatnot):

        Function Test()
        
            Dim sFile As String
            Dim WordDoc As New Document
        
            sFile = "C:\temp\boi.docm" 'change as required or add a filedialog box
        
            Set WordDoc = Documents.Open(sFile)
        
            WordDoc.Select 'select all in doco
            WordDoc.GoTo(wdGoToPage, wdGoToAbsolute, 1).Delete 'delete page 1
        
            Selection.Font.Size = 8 'size 8
            WordDoc.PageSetup.Orientation = wdOrientLandscape 'landscape
        
            Application.Options.DefaultHighlightColorIndex = wdYellow 'set highlight do yellow
        
            With Selection.Find 'configure the find settings
                .Text = "WARNING" 'find text // may need to set case sensitivity
                .Format = True
                .Replacement.Highlight = True
            End With
        
            Selection.Find.Execute Replace:=wdReplaceAll 'execute the actual find
        
            WordDoc.SaveAs "C:\temp\boi_" & Format(Now, "yyyymmdd") & ".docx", wdFormatDocumentDefault 'saveas a docx word file with a yyyymmdd appendix
            WordDoc.Close 'close this doc
        
            Set WordDoc = Nothing
        
        End Function
        

        Have fun :>

        • 

          CyberMurning on 14/10/2019 - 00:22

          +1

          @fishball: Thank you Sir!

  • 

    fishball on 13/10/2019 - 21:40

    +7

    Yes.

    In VBA, use FileSystemObject to rename the .REP as .TXT (might be optional; word can open things smartly sometimes), open with word, delete first page, set page settings etc

    Set wordApp = CreateObject("Word.Application")
    Set wordDoc = WordApp.documents.open("yourfile.TXT or yourfile.REP")

    …. do stuff here …

    wordDoc.options.defaulthilightcolorindex = wdYellow
    worddoc.selection.find.replacement.highlight = true
    with wordDoc.selection.find
    .text = "Warning"
    .format = True
    end with
    WordDoc.selection.find.execute Replace:=wdReplaceAll

    wordDoc.saveas "some other file" & format(now, "yyyymmdd_hhmmss") & ".docx"
    and exit etc

    That code isn't 100% correct because I just typed it from my mind so didn't verify syntax etc but I know it's possible to do what you need.

    • 

      CyberMurning on 13/10/2019 - 23:24

      wow that is super cool i'll continue from there thanks

    • 

      Homr on 13/10/2019 - 23:36

      wow nice, what do you do for a living?

      • 

        fishball on 13/10/2019 - 23:43

        +1

        Robotics Process Automation. I automate stuff.

        • 

          Homr on 14/10/2019 - 07:06

          @fishball: Impressive, is that excel extensive? Good pay?

          • 

            fishball on 14/10/2019 - 10:33

            +1

            @Homr: Excel is one of the many tools I have to use. Pay's alright I guess, it lets me ozbargain at least lol

    • 

      nomoneynoproblems on 14/10/2019 - 00:10

      The real MVP

  • 

    alvian on 13/10/2019 - 21:48

    +1

    Simply record a macro. No need to do any VBA programming.

  • 

    jv on 13/10/2019 - 21:54

    Yes.

    You can use the sendkeys method in Excel to do pretty much what you want in MS Word.

  • 

    cristtos on 13/10/2019 - 23:55

    Yes it can but why use VBA excel and not VBA word?!?
    You can start by recording a macro of your actions and, then, try to edit it to make it generic.
    https://www.teachucomp.com/record-a-macro-in-word-instructio…

• 

  ihbh on 13/10/2019 - 21:40

  +3

  Wow, the reviews read like horsesh*t. Robo-written perhaps?

  • 

    jv on 13/10/2019 - 21:56

    +2

    LOL.

    I think Kevin Rudd wrote this one:

    "It is typical of a considerable number individuals that are endeavoring to increase extra musings in this. at first respected this book with an inconceivable. This book set depicts in detail the resuscitated Excel VBA and focal highlights of this program."

• 

  wangasm on 14/10/2019 - 02:06

  +3

  I had a quick look on my Kindle. While the content is fine, I have to say that learning VBA or any programming language on a Kindle is incredibly painful and unintuitive since there isn't any proper formatting applied to the code examples. You are better off using the many free resources available on the net.

• 

  FareEvader on 14/10/2019 - 10:30

  Waiting for the next free VBA course on udemy

• 

  Phoebus on 14/10/2019 - 11:09

  VBA is a waste of tine. You can do everything better in Powershell

  • 

    Homr on 14/10/2019 - 11:36

    My work doesn't have powershell

  • 

    wangasm on 14/10/2019 - 11:49

    Better than VBScript, probably. Better than VBA in MS Office products, not really.