Consulting

View RSS Feed

Recent Blogs Posts

  1. VBAExpress.Com, a free Microsoft Help Forum

    VBAExpress is a site where users can learn all about VBA (Visual Basic forApplications). This is the programming language for Microsoft Office, and is often referred to as Macros.


    For example many routine orcomplex tasks in Excel can be automated with macros. A macro is a set of instructionsthe application will run. This automation eliminates tedious work and alsoremoves human error from the process. Running the macro is super easy, often as easy as pushing a button on the
    ...
    Categories
    Uncategorized
  2. Free Webinar on Power Tips for Using Microsoft Office Moving Data Between Them

    Power Tips for Using Microsoft Office:

    Click image for larger version. 

Name:	banner.jpg 
Views:	1508 
Size:	18.6 KB 
ID:	14913

    Microsoft Office has been the dominant business productivity suite for many years now. As it has evolved, the various elements of the program (Word, Excel, PowerPoint, Access, Outlook and others) have become more intertwined and interconnected to increase the functionality of the entire suite. While many users know how to work within the different programs, few people understand how to use the different ...
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	twitter-banner-0014-mini.jpg 
Views:	471 
Size:	20.8 KB 
ID:	14914  
  3. Windows 10 Training

    Microsoft is having a training session for Windows 10 that may be of interest. It is free. You can view more information here:


    http://www.microsoftvirtualacademy.c...=dx_MVP4039979




    Microsoft also has training courses available in their Virtual Academy. Most of these are free as well.


    https://www.microsoftvirtualacademy....=dx_MVP4039979
    Tags: -1' Add / Edit Tags
    Categories
    Uncategorized
  4. Jacob's VBA Tip #9 - Configuration ActiveX Controls

    In a recent project I have ActiveX Option Buttons on a worksheet. The worksheet is an inspection sheet and the Option Buttons are responses to questions and can be Yes, No, N/A.

    There are many sheets and each sheet has many questions but the design is similar. This means I can copy and paste the questions and then just update the specific question text.

    The problem comes in with all the ActiveX controls. They all need to be named, and lined to a specific cell so the values ...
    Categories
    Tips - Excel
  5. Jacob's VBA Tip #8 - Unreadable Content (Data Connection)

    I recently had a workbook that was causing problems. When it was opened an error was shown that Excel had to recover the content. The problem was given as:

    Removed Records: External connections from /xl/connection.xml part (Data connection).

    After Excel fixed the problem it would work for a while and then occur again.

    I found some suggestions online that it could be caused by sorting by custom lists. In this case custom lists were not being used, but in fact ...
    Categories
    Tips - Excel
Page 1 of 11 1 2 3 ... LastLast