<p>General-purpose VBA techniques spanning the Office suite.</p>
I have a legacy application developed in VBA/Excel which uses ListView controls. Unfortunately, it looks like these controls can't be used with 64-bit versions…
The Options dialog in Word 2010 implements the category selector via set of white "toggle" buttons that become orange when clicked (selected). How would…
How do I set the format for timevalue for 12-hour clock without second. For example: hh:mm AM/PM. Right now I'm using Format(TimeValue(Now), "hh:mm") but…
I am trying to sort a range within a separate sheet. However, I keep getting this message: '1004': "The sort reference is not valid.…
I've used a routine for years to put a plain text string into the clipboard that I can paste into another program such as:…
My Excel workbook contains VBA subs and macros similar to those below; they sit in Module1. How to call them using Python win32com module?…
Can String.Format() be implemented in VB6, at least a close-enough version of it that could be useful when programming in good ol' VB6? Good…
I have a reporting spreadsheet that grabs some data from a database and forms three sheets of summary report information. I want to run…
I am creating various charts from the same source. I would like to be able to cut paste with vba each chart as a…
I have the following: $mimeTypes = array('application/msword'); //used to be an array $finfo = new finfo(FILEINFO_MIME, "/usr/share/misc/magic"); $type =…