MoonPoint Support Logo


Shop Amazon Warehouse Deals - Deep Discounts on Open-box and Used ProductsAmazon Warehouse Deals

Advanced Search
Sun Mon Tue Wed Thu Fri Sat
22 23
24 25 26 27 28 29 30
Oct Nov Dec

Mon, Sep 18, 2017 11:16 pm

Excel - This file is locked for editing

If you see an error message like the one below, which was produced by Microsoft Excel for Mac 2016 on a Mac OS X system, even though you don't have the file open currently, then you will need to delete the lock file, which should be in the same directory as the spreadsheet.

This file is locked for editing.

Locked by: John Doe
Filename: SGRS_2017.xlsm

You can open the file as read-only.


The lock file will have the same name as the workbook you were trying to open, but the file name will have ~$ prepended to it. To delete the file you will need to "escape" the meaning of the dollar sign by putting an escape character, i.e., a backslash character, immediately before the dollar sign. I.e., use ~\$ as shown below:

$ ls -alg **SGRS_2017.xlsm
-rw-rw-r--@ 1 ABC\Domain Users  761327 Sep 13 15:57 SGRS_2017.xlsm
-rw-rw-r--@ 1 ABC\Domain Users     171 Sep 18 22:46 ~$SGRS_2017.xlsm
$ rm ~$SGRS_2017.xlsm
rm: ~.xlsm: No such file or directory
$ rm ~\$SGRS_2017.xlsm

Once the lock file has been deleted, you should be able to open the file without the warning message that it is locked for editing.

[/software/office/excel] permanent link

Sun, Sep 17, 2017 11:09 pm

Determining the version of Microsoft Edge on a Windows system

You can obtain the version of the Microsoft Edge browser on a Windows system using the Get-AppXPackage cmdlet with Get-AppXPackage -Name Microsoft.MicrosoftEdge.

PS C:\> Get-AppXPackage -Name Microsoft.MicrosoftEdge

Name              : Microsoft.MicrosoftEdge
Publisher         : CN=Microsoft Corporation, O=Microsoft Corporation, L=Redmond, S=Washington, C=US
Architecture      : Neutral
ResourceId        :
Version           : 40.15063.0.0
PackageFullName   : Microsoft.MicrosoftEdge_40.15063.0.0_neutral__8wekyb3d8bbwe
InstallLocation   : C:\Windows\SystemApps\Microsoft.MicrosoftEdge_8wekyb3d8bbwe
IsFramework       : False
PackageFamilyName : Microsoft.MicrosoftEdge_8wekyb3d8bbwe
PublisherId       : 8wekyb3d8bbwe
IsResourcePackage : False
IsBundle          : False
IsDevelopmentMode : False
IsPartiallyStaged : False

PS C:\>

If you just want to see the version number and not the additional information, you can add "| select Version" at the end of the command.

PS C:\> Get-AppXPackage -Name Microsoft.MicrosoftEdge | select Version


PS C:\>

[/network/web/browser/edge] permanent link

Sat, Sep 16, 2017 11:05 pm

Determining the antivirus software on a Windows system from the command line

You can determine the antivirus software present on a system, if the antivirus software is registered with the Windows Security Center, using Windows Management Instrumentation Command-line (WMIC). E.g., for a Windows 10 system using Microsoft Windows Defender:

C:\>WMIC /Node:localhost /Namespace:\\root\SecurityCenter2 Path AntiVirusProduct Get displayName
Windows Defender


[ More Info ]

[/os/windows/commands/wmic] permanent link

Fri, Sep 15, 2017 11:04 pm

AskPartnerNetwork Directory on a Windows 10 system

A user reported her Windows 10 Professional system was running slowly. On September 14, 2017, I checked the system with SUPERAntispyware, which reported that it found the Ask Toolbar. It reported the following items associated with the toolbar:


[ More Info ]

[/security/scans] permanent link

Tue, Sep 12, 2017 10:58 pm

Adding an item to a list in Python without duplicates

If you have a list in a Python script and wish to add new items to the list, you can use listname.append(newitem) where listname is the name of the list and newitem is the item you wish to add to the list. If you wish to add new items to the list only if they don't already exist in the list, you can avoid adding an existing entry to the list by checking if the entry is already in the list as shown below:

filenameList = []
if filename not in filenameList:

If you wish to know the length of a list, i.e., how many items are on the list, you can use print len(listname) where listname is the name of your list.

[/languages/python] permanent link

Sat, Sep 09, 2017 11:53 pm

Backing up a MySQL or MariaDB table or database

You can backup a table in a MySQL or MariaDB database by using the mysqldump backup tool included with both database management systems. To backup a specific table you can use the command mysqldump database_name table_name where database_name is the name of the database that contains the table and table_name is the name of the particular table you wish to backup. E.g.:

mysqldump -u ptolemy -p Planets Mars > Mars.sql

In the above case, if I have a database named Planets with a table within it named Mars, I could backup just that one table from the database with the command above. The -u option to the command allows you to specify a MySQL/MariaDB username that has access to the database and the -p option will prompt you for the password associated with that username. The Mars.sql file will then contain all of the Structured Query Language (SQL) commands needed to recreate the table structure and the data in the table. E.g., it will contain insert SQL commands that will insert entries in the table.

[ More Info ]

[/software/database/mysql] permanent link

Fri, Sep 08, 2017 10:21 pm

Display a webpage from a Python script

If you just want to display text on a webpage from a Python script, a simple way to print to a web page is shown in the script below:


print "Content-type: text/plain\n"
print "Hello world"

If you want to display HTML code, you can use Python code like the following:


print "Content-type: text/html"
print """<!DOCTYPE HTML>
<html lang="en">
<h1>Hello World!</h1>

[ More Info ]

[/languages/python] permanent link

Thu, Sep 07, 2017 10:38 pm

Looping over a set of files in the Bash shell on Linux or OS X

I have a Python script,, that takes a file name as a parameter. I use the script to identify if a file with a .bin extension is actually a Microsoft Visio or PowerPoint file. I run the script on an OS X system from a Terminal window where I have a Bash shell prompt. E.g.:

$ ~/Documents/bin/ oleObject1.bin
Microsoft Office PowerPoint

But I often want to have it check all of the .bin files in a directory. You can loop through all files in a directory or a set of files using a Bash for loop. E.g., to check all of the .bin files in a directory I could use the for-loop below:

$ ls *
oleObject1.bin	oleObject3.bin	oleObject5.bin
oleObject2.bin	oleObject4.bin	oleObject6.bin
$ for f in *.bin; do ~/Documents/bin/ $f; done
Microsoft Office PowerPoint
Microsoft Office PowerPoint
Microsoft Office PowerPoint
Microsoft Visio
Microsoft Visio
oleObject6.bin: CDF V2 Document, No summary info


[ More Info ]

[/os/unix/bash] permanent link

Wed, Sep 06, 2017 11:57 pm

GoDaddy continues to show "Loading..." when composing email

Someone who uses GoDaddy for her email reported to me today that she couldn't send email. I logged into her account from another system and was able to send email to myself. When I notified her that I had been able to send email from her acount to myself, she sent an email to me, but reported it was still stating "loading" when she hit the send button. So tonight I logged into her system and opened the Firefox browser, since she uses that browser to send and receive email. When I clicked on Compose, I saw a "Loading..." message in the body of the email that wouldn't go away unless I clicked on the Plain Text tab to switch from "Rich Text", which allows one to format text in the message with bolding, font colors, etc., to "Plain Text". But when I switched back to "Rich Text", I had problems typing my email address in the "To" field with only one letter appearing in the "To" field no matter how many letters I typed.

[ More Info ]

[/network/email/godaddy] permanent link

Tue, Sep 05, 2017 10:55 pm

Using the PowerShell Get-WmiObject cmdlet to get BIOS information

You can get BIOS information on a system running the Microsoft Windows operating system using the PowerShell cmdlet Get-WmiObject cmdlet. E.g.

PS C:\> Get-WmiObject win32_bios

Manufacturer      : Award Software International, Inc.
Name              : Award Modular BIOS v6.00PG
SerialNumber      :
Version           : GBT    - 42302e31

PS C:\>

[ More Info ]

[/os/windows/PowerShell] permanent link

Once You Know, You Newegg AliExpress by

Shop Amazon Local - Subscribe to Deals in Your Neighborhood

Valid HTML 4.01 Transitional

Privacy Policy   Contact

Blosxom logo