Software Africa Newsletter - July 2019

Autodesk Tip ~ Online Business Tip ~ Excel Tip

Editorial

4IR

Did you know that Autodesk product users are already involved and committed to the 4th Industrial Revolution? The tools supplied in the Collections take a project from design and planning right through to full documentation of how to maintain the final system in total. This documentation makes the project completely holistic. Users can work together and their "footprints" are recorded throughout.

Think how much easier this will make our lives in the future as we employ more and more of this technology.

On-Line Business Tip #28: Google Hacks 6 - Search for Related Sites:

Google is the world's most popular search engine. So it helps to know a bit more about using it than the average person.

It is easy to go to www.google.co.za and type in words to search for. Google will then search for pages where all those words occur.  However, sometimes we rather want to look for sites that are similar to a website.

To do this, put "related:" (note the colon) in front of a web address you already know. For example, related:megaplex.co.za

That search turns up Eat Out, Restaurants South Africa, Mallguide, Government Gazette of South Africa, SA Commercial Property Investment News, Johannesburg Business Directory, and South African Tourism – proof of the versatility and uniqueness of our sister site Megaplex: Much copied in part, the whole seldom equalled.

AutoCAD News

There are a number of developments in the next few months, as follows:

AutoCAD for Mac and LT for Mac 2020 released

Please note that these can be downloaded now from your connection.

 

Bonfire Share of the Week

New Composite Building Materials Are Redefining Modernism at Exhibit Columbus

Join Bonfire, a simple way to share Autodesk and industry stories with your own social media audience.

Announcing Autodesk Q2-Q3 Global Field Promotion (GFP)

Autodesk is pleased to provide a special offer encouraging eligible customers with 2014-2019 perpetual licenses not on maintenance to upgrade to subscription.

From May 7 through October 25, 2019, you may receive up to 20% off the Suggested Retail Price of a new 1- or 3-year subscription when you terminate your associated perpetual license.

In addition to more value and flexibility than perpetual licenses, you can save up to 20% when trading in qualifying perpetual licenses that are not on maintenance plans, for a subscription to the latest Autodesk industry collections or to most individual products—like AutoCAD® including specialized toolsets, AutoCAD LT® , Civil 3D® , Revit® , Inventor® , 3ds Max® and more.

Compelling Events

Event

Applies to

Date:

Introduction of

Multi-year Moving to Subscription

Maintenance plans moving to a 3-year subscription

Or

As part of this offer, now if you have a 1-year or 2-year subscription Move to Subscription can choose to switch to a 3-year Move to Subscription at the time of renewal

March 27, 2019

You can act on this 90 days before expiry.

Autodesk Developments.

Autodesk Knowledge Network (AKN)

AKN is the community content site providing tech support, training materials, product knowledge, and interactive discussion forums for you as customers. Please make use of it.

Incidentally, M2S subscriptions activate on the day of renewal. Other helpful links are:

The differences on how these different layouts work are illustrated here.

Previous Versions of Autodesk Software

Global Travel Rights

Using Subscriptions Software at Home

Autodesk Cloud Credits

Support & Learning

QuickBooks' Cloud Solutions

QBO is proving a multi-faceted platform.

Please contact Judith for more

Excel Tip #177 – A Recorded Excel Macro

Last time we had you record and test your first Excel Macro, named Demo1 (Shortcut key: Ctrl+Shift+H) and stored in the Personal Macro Workbook.  This macro bolds and underlines Row 1. It resizes columns A to P to fit the columns to their contents. Finally, it selects cell B2 and freezes panes.

Let us now look inside the macro.

In Excel, press Alt+F11 to open the Visual Basic Editor.

If MacroDemo1.xlsx is open (it needn't be), you should see the following:

If you do not see the Project window lane on the left, press Ctrl+R.

If you do not see "Modules" under "VBAProject (PERSONAL.XLSB)", click the "+" next to it to expand the tree.

If you do not see "Module1" under "Modules", click the "+" next to "Modules" to expand the tree.

If you do not see the code window on the right, double-click "Module1" (if you have recorded macros before, your latest macro might be in Module2, 3, or later.

Let us examine the macro:

  1. You might not have "Option Explicit": That is a useful setting we will discuss much later.
  2. Technically, the macro is a subprogram.  Hence it starts with "Sub" plus its name, and ends with "End Sub".
  3. The green lines that start with a single quote (') are comments. All lines that start with a single quote are comments:  They are ignored by the program.  Comments are for the benefit of the programmer, so that you have an explanation of what is going on.
  4. After the comments, in black and dark blue, is the program proper:
  5. "Rows("1:1").Select" selects Row 1.
  6. The next two rows bold and single-underline the selection.
  7. "Columns("A:P").Select" selects columns A to P.
  8. "Columns("A:P").EntireColumn.AutoFit" resizes the column to fit their contents.
  9. "Range("B2").Select" selects cell B2.
  10. "ActiveWindow.FreezePanes = True" chooses Freeze Panes > Freeze Panes from the View ribbon.

Now that we have seen the macro, next time we'll look in more detail at the Visual Basic Editor.

Computius Say:

If at first you don't succeed; call it version 1.0

Remember:  We can make your business run better by:

All the Best from the team!
Judith and Rick

Members, Communication in Action cc trading as Software Africa
"Empowering African Business with standard and custom PC programs, databases, and templates using Microsoft technologies"
Reg. 2009/007863/23 ~ VAT No 4500104387 ~ 126 Kelvin Drive, Morningside Manor, Sandton, 2191 South Africa.
Tel: 011 802-2685 / 011 802-6440 ~ Fax: 086-635-7902/3 ~ Cell: 082 389-3481/2 ~ e-mail: info@softwareafrica.co.za

This entire newsletter is Copyright © 2019 Communication in Action cc t/a Software Africa. All rights reserved. Information may be reproduced in full context as long as credit is given.
Newsletter Index | < January 2015 | < January 2016 | < January 2017 | < January 2018 | < February | < March | < April | < May | < June | < July | < August | < September | < October | < November | < December 2018 | < January 2019 | < February | < March | < April | < May | < June | < July
Back to top | Updated 19 July 2019 | e-mail Webmaster.