Remko Weijnen's Blog (Remko's Blog)

About Virtualization, VDI, SBC, Application Compatibility and anything else I feel like

In my lab I have deployed Office 2019 to an Windows 2019 VM to do some testing with Citrix Virtual Apps and Desktops.

The proper way to do this is to customize the Office installation using the Office Deployment Tool (ODT). The page even lists an example containing a value to accept the EULA.

I didn’t do that, I just installed it manually (I know.) and upon first launch of any of the Office components I would always get this EULA nag screen:

Microsoft Office EULA nag screen

So how do you get rid of this nag screen if you didn’t use ODT?

To figure that out I started Outlook whilst I ran SysInternals Process Monitor with the following Filters configured:

  • Process Name is outlook.exe
  • Path contains license, eula or registration:

Screenshot of the Process Monitor Filter dialog showing Process Name is outlook.exe and Path contains license, eula or registration

What I was looking for was (ideally) a registry key or value that was global to all users (so in HKLM) and for all Office components. And from the Procmon trace this Value seemed a good candidate:

Showing that outlook.exe attempts to read the following value: HKLM\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Wow6432Node\Microsoft\Office\16.0\Registration\AcceptAllEulas

(more…)

Yesterday I was working with an Excel document that contained Combobox form controls.

I wanted to count the number of cells containing a particular value using the COUNTIF formula. However the count returned 0 because the LinkedCell property of the Combobox was not set to the Cell that contained the Combobox.

To set the LinkedCell Ctrl-Click the Combobox to select it, right-click and select Format Control. Then set the correct Cell in the Cell link field:

SNAGHTML18f5a4ba

My sheet contained about 150 Comboboxes, so obviously I was going to do this using a script. I couldn’t find anything useful with Google so I wrote my own Macro.

(more…)

  • 0 Comments
  • Filed under: Programming
  • Excel 2010 multi-threaded calculation

    Excel 2007 IconI was just browsing through the Options tab in Excel 2010 when I noticed the following setting:

    image

     

    This feature was introduced in Excel 2007.
    In the default settings, multi-threaded calculation is Enabled with "Use all processors on this computer".

    On a physical desktop this would be the preferred setting since it will make formula calculation as fast as possible.

    (more…)

  • 10 Comments
  • Filed under: General
  • Session freeze when starting Excel

    Environment
    Windows 2003 Enterprise (32 bit), Citrix XenApp 5, RES Workspace Manager 2011, McAfee VirusScan Enterprise 8.7.0i.

    Problem
    When a opening an Excel workbook from Sharepoint the whole session freezes.

    I asked the user to open an Excel workbook from Sharepoint and I noticed the following popup:

    Some files can harm your computer. If the file information looks suspicious or you do not fully trust the source, do not open the file | You are opening the following file: | File name: My Workbook.xls | From: Sharepoint

    So my first thought was that the user somehow clicked this message to the background and IE was waiting for a response.

    (more…)

    After I uninstalled Office 2010 64 bit and installed Office 2010 32 bit I had a problem with Office Communicator 2007 R2.

    After entering my password and clicking sign in it crashed every time:

    image

    In the EventLog an Application Error was recorded with some additional error info:

    Event Type: Error Event Source: Application Error Event Category: (100) Event ID: 1000 Date: 10-3-2011 Time: 15:20:52 User: N/A Computer: remkolaptop Description: Faulting application name: communicator.exe, version: 3.5.6907.221, time stamp: 0x4cddcd9f Faulting module name: KERNELBASE.dll, version: 6.1.7601.17514, time stamp: 0x4ce7bafa Exception code: 0xc06d007e Fault offset: 0x0000b727 Faulting process id: 0xf94 Faulting application start time: 0x01cbdf2e592fc53c Faulting application path: C:\Program Files (x86)\Microsoft Office Communicator\communicator.exe Faulting module path: C:\Windows\syswow64\KERNELBASE.dll Report Id: 9a4e3adf-4b21-11e0-8f0f-c0cb38a92f9b For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    The exception code is 0xc06d007e which is defined in WINERROR.h as ERROR_MOD_NOT_FOUND, the error description is: “The specified module could not be found”.

    (more…)

  • 0 Comments
  • Filed under: General
  • Blogroll


    Categories


    Archives