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

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

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