Python 101: Setting Up Python on Windows Screencast
I created my first screencast based on an old article I wrote about setting up Python on Windows.
Python 101: Setting Up Python on Windows Screencast Read More »
PyWin32
A post that discusses something to do with the PyWin32 module for the Python programming language
PyWin32: How to Set the Desktop Background on Windows
Back in my system administrator days, we were thinking about setting the user’s Window desktop background to a specific image on login. Since I was in charge of the login scripts, which were written in Python, I decided to do some research to find out if there was a way to do it. We will
PyWin32: How to Set the Desktop Background on Windows Read More »
PyWin32 – How to Bring a Window to Front
I recently saw someone asking how to bring a window to the front in Windows and I realized I had had some old unreleased code that might help someone with this task. A long time ago, Tim Golden (and possibly some other fellows on the PyWin32 mailing list) showed me how to make windows come
PyWin32 – How to Bring a Window to Front Read More »
Creating Microsoft Excel Spreadsheets with Python and xlwt
There are a couple of ways to create Microsoft Excel spreadsheets with Python. You can use PyWin32’s win32com.client method, which was discussed in an old article a number of years ago or you could use the xlwt package. We’ll be looking at the latter in this article. You will learn how to create an Excel
Creating Microsoft Excel Spreadsheets with Python and xlwt Read More »
PyWin32: adodbapi and MS Access
Last week, there was an interesting thread on the PyWin32 mailing list about how to read Microsoft Access databases with Python without having Access actually installed. Vernon Cole had the solution, but I noticed that Google doesn’t seem to index the PyWin32 list very well, so I decided to write about it here.
PyWin32: adodbapi and MS Access Read More »
Top Ten Articles of 2010
A lot of websites are doing year-end retrospectives this week, so I thought you might find it interesting to know which articles on this blog were the most popular this year. Below you will find links to each article along with the page view count I got from Google Analytics: A Simple Step-by-Step Reportlab Tutorial,
Top Ten Articles of 2010 Read More »
Python and Microsoft Office – Using PyWin32
Most typical users have used Microsoft Office. While Office may be the bane of tech support, we still have to deal with it. Python can be used to script (AKA automate) Office and make it easier for us or our users to use. It may not be as easy as recording a macro, but it’s
Python and Microsoft Office – Using PyWin32 Read More »
Creating Windows Shortcuts with Python (Part II)
Back when I first wrote about creating shortcuts with Python last month, I kept thinking to myself that I had a 3rd way of doing it. Today, I had to maintain some of my shortcut code and I stumbled upon it once more. I also noticed that my post had received a comment from Tim
Creating Windows Shortcuts with Python (Part II) Read More »
Create a Shortcut in Windows Using Winshell or PyWin32
The past couple of days, I’ve needed a way to create a shortcut on a user’s desktop during the login process. I had a way that worked for most shortcuts, but I just could not figure out how to do this one.
Create a Shortcut in Windows Using Winshell or PyWin32 Read More »
Mapping Drives on Windows
One of the first scripts I had to help translate from Kixtart to Python was our map drives script. In it, we would map drives based on either which group the user was in and/or what a custom registry entry said. Here is a partial example of each of these categories in Kixtart: IF READVALUE(“HKEY_LOCAL_MACHINE\SOFTWARE\MyOrg”,
Mapping Drives on Windows Read More »
Reading OpenVPN Status Data with Python (3 of 3)
We’ve been discussing how to use OpenVPN with Python in the last two articles. In this final post, I’ll show how to bring it all together into a GUI with some wxPython code. I’m also going to discuss some important snippets.
Reading OpenVPN Status Data with Python (3 of 3) Read More »
Reading OpenVPN Status Data with Python (2 of 3)
This is the 2nd part of a 3-part series on using wxPython + PyWin32 to grab the output from an OpenVPN session on Windows. In this article, I will show how how to start OpenVPN with Python and how to watch a file that OpenVPN writes its data logs to.
Reading OpenVPN Status Data with Python (2 of 3) Read More »
Reading OpenVPN Status Data with Python (1 of 3)
I’m doing a 3 part series on using wxPython and PyWin32 to capture output from a running OpenVPN session. I use OpenVPN to connect to PCs at work. I noticed that our current method of launching OpenVPN was in a console window so that one could monitor the program’s output. If the user happened to
Reading OpenVPN Status Data with Python (1 of 3) Read More »