Tag Archives: Word

Python: How to Deal with Tables in Word

Header

I think I’ve mentioned it before that the Python documentation can be really confusing for beginners. There may be people out there who can look at this Table objects page and completely understand what’s happening.

I am not those people. I need visuals.

Continue reading

Advertisements
Tagged , , , , , ,

VBA: How to Use VLookUp in a Macro

Header

Alright, here’s something I’ve been meaning to learn for weeks. It’s probably going to be the most boring post of all time for anyone who isn’t an Excel nerd. In fact, if you aren’t an Excel nerd, just run. Run far, far away.

Continue reading

Tagged , , , , , , , , , ,

Python: How to Automate Word Docs

Header

Every time I start thinking that my job is bad, I try to remind myself that Stanley Kubrick had a secretary. The guy was notorious for driving actors into the ground. Making them do takes over and over and over. Can you imagine having to handle his administrative work?

If IMDB’s trivia page is to be believed, that poor soul had to spend weeks typing out the infamous ‘All work and no play makes Jack a dull boy’ novel from hell. On the off-chance I ever find myself similarly working for a maniac, I’m attempting to master the Python docx module, and I’ve been pleasantly surprised with how far you can get with just the basics.

Continue reading

Tagged , , , , , , , , , , ,

VBA: How To Auto-save Attachments in Outlook

GG2C 1

So this week I wrote a script that will take an email from your Outlook and save all the attachments to a specified file. It was a learning process that took many unexpected twists and turns. There was a fair amount of cursing, cajoling, and a minor panic attack. Ultimately the bastard functions though, so I’m calling it a net gain.

Continue reading

Tagged , , , , , , , , ,