Software Africa Newsletter - November 2019

Autodesk Tip ~ Online Business Tip ~ Excel Tip

Editorial

Rain and joy, somehow this boosts energy. Prize won for sales - yes you too can do it! Want to kill retailers who spoil children's expectations of celebrations by starting two months before.

On-Line Business Tip #32: Scam Alert - Pick n Pay is NOT giving away R1 500 coupons:

Scores of unwary South African Facebook users have been sharing a viral scam offering a R1 500 coupon from Pick n Pay, but the retailer has confirmed to Fin24 that it is a hoax.

This phishing scam reads as follows: "Pick n Pay has announced that everyone who shares this link will be sent a R1500 coupon for its anniversary. TODAY ONLY" and gives a fake website that requires answers to a three step "survey" before the post is shared to your own timeline. 

We got sent it today on WhatsApp.  Read more here on Fin24.  The real Pick n Pay website is https://www.pnp.co.za/ (the https: means it is a secure site).  The scam site is an insecure (http:) .com site.

For confirmation visit the real Pick n Pay website and scroll down to "November 2019: Fake R1500 Facebook Coupon".

AutoCAD Newss

90-day Subscription Renewal Reminder Added

Customers are reminded 90 days in advance to renew their subscription by Autodesk:

"In an effort to increase our subscription renewal rates, we recently began sending 90-day renewal reminder emails to customers in addition to our standard 45-, 30-, and 4-day reminders.

"Our goal is to give customers more advance notice that their maintenance plan will be expiring soon and to remind them of their renewal options. The renewal reminders are stopped once a subscription has been renewed.

"As previously announced, we have also added that customers can save 10% when they switch to a subscription with 3-year terms at renewal time*."

* Savings of 3-year subscriptions is compared to the applicable Autodesk suggested retail price for 3 consecutive, annual subscriptions. Autodesk partners are independent and free to set their own prices.

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

New Product Usage Reporting for Admins with Single-User Access

Product usage reporting, in Autodesk Account, provides admins with single-user access transparency into what:

We can now spend more time strategically advising you on the best way to adopt new and existing tools to achieve your business outcomes.

Autodesk Success Hub

https://customersuccess.autodesk.com/
 

Upgrade to an Autodesk Subscription

By sending us your old perpetual licence, we can upgrade you to the latest subscription version of your product at a 20% discount. Microsoft has announced the end of extended support for Windows 7 in January 2020, this is an opportunity to upgrade to a Windows 10 supported subscription.

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 #181 – The Excel Visual Basic Editor's Standard Toolbar

Earlier, we looked inside the macro you recorded.  Then, we introduced the macro editor program and its main menu. Let us now examine the first of its Toolbars: The Standard Toolbar.

In Excel, press Alt+F11 to open the Visual Basic Editor.  You should see the following at the top of the window:

  1. If you don't see the toolbar (shown here directly under the main menu, but yours may be elsewhere), click the View menu and, on the Toolbar sub-menu, tick "Standard".  Let's now look at the tools and what they do:

    View Excel: This takes you back to the current  workbook in Excel.

  2. Insert UserForm: Add a User Form. The "down arrow" button on the right produces the drop-down menu (shown above). which is used to insert new objects that will appear in the Project Explorer on the left.  You can insert a User Form, Module, Class Module, or Procedure.
  3. Save File: Save the Personal Macro Workbook or current Workbook) (Ctrl+S)
  4. Cut: Move text to the Clipboard (Ctrl+X)
  5. Copy: Copy text to the Clipboard  (Ctrl+C)
  6. Paste: Insert text from the Clipboard  (Ctrl+V)
  7. Find: (the binoculars) Find text in the code, optionally Replace (Ctrl+F)
  8. Undo: Undo the previous action (Ctrl+Z)
  9. Redo: Undo the previous Undo.
  10. Run: (The green "play" triangle) Starts the Sub code or UserForm running (F5)
  11. Break: Pauses the running code (Ctrl+Break),
  12. Stop: (the square) Kills the running code
  13. Design Mode: Used to design UserForms
  14. Project Explorer: This opens the window pane at the top left where you can see the parts of the project (Ctrl+R)
  15. Properties Window: This opens the window pane at the bottom left where you can see the properties of the project or UserForm (F4)
  16. Object Browser: Opens the list of properties, methods, and constants in the object you select (F2)
  17. Toolbox: for User Form design.
  18. Help: go to Microsoft VBA (Visual Basic for Applications) Help (F1)
  19. Position Indicator: Tells you in which Line and Column the cursor is.
  20. Add or Remove Buttons drop-down arrow: This lets you customise the toolbar.  If you've already done that, yours will look different to the one above.

Next time we'll look at the Visual Basic Editor's Edit toolbar.

Computius Say:

Computer Terms: "Beta" version software is in its second stage of testing.  Beta is Latin for "still doesn't work".

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 | < August | < September | < October |
Back to top | Updated 22 November 2019 | e-mail Webmaster.