Browse by Tags

An MSForms Treeview

If you have ever used the Treeview control from the “Additional controls” section, then you know what a versatile control this is to show hierarchically organized data. There are a couple of problems with this Treeview control: Compile errors due to a difference in how the control libraries are registered in 32 bits Windows’ System32 [...] Read More...

Published Thu, Jan 01 2013 4:24 AM by Daily Dose of Excel

Filed under: Classes, VBA Advanced, Collections, VBA, MVP, Events, Visual Basic Editor, Windows API, Userforms and Controls, ActiveX Controls, Controls, UI Design, Excel Advanced

Excel 2013, SDI and modeless userforms

Hi Everyone, With Excel 2013 we also got new document windowing in Excel; Microsoft decided to make Excel behave the same as Word: from MDI: to SDI: This causes havoc when one shows a modeless userform which should stay on top of all Excel windows: I’ve devised a way to prevent this problem and written [...] Read More...

Published Mon, Nov 11 2012 10:16 AM by Daily Dose of Excel

Filed under: VBA Advanced, VBA, MVP, Downloads, User Interface, Windows API, Userforms and Controls, Excel Advanced, Excel 15

Find Matching Data in Array Speed Test

JP has a good post about finding exact matches in arrays. I use a similar method. I Join the array with delimiters around all the values, then use Instr to see if it’s there. Here’s my code: Function IsInArrayDK(vArr As Variant, sValueToCheck As String, _ Optional bMatch As Boolean = True) As Boolean [...] Read More...

Published Tue, Jul 07 2012 10:21 AM by Daily Dose of Excel

Filed under: Windows API, Arrays

Copy Chart as a Picture

I needed to copy a chart to a picture, but I wanted it to be an enhanced metafile (EMF) which is kind of like a vector graphic picture format. EMF graphics scale well when the page resizes. A user would … Continue reading → Read More...

Published Sat, May 05 2012 6:55 PM by Daily Dose of Excel

Filed under: VBA, Windows API, Charting, VBA Code Library

Save a global variable in an Excel workbook

Developers who have done any kind of programming with the Office 2007 (and later) Ribbon architecture have encountered almost certainly a scenario that resulted in the loss of their pointer to the ribbon. This happens because the ribbon object has to be stored in a global variable and any kind of unhandled error leads [...] Read More...

Published Sun, Aug 08 2011 11:01 PM by Daily Dose of Excel

Filed under: Excel12, Windows API, Fluent UI, Excel 14, Excel Basic, Excel Intermediate

Office 2010 VBA

Microsoft made several changes to VBA in Office 2010, all of them targeted at the one major change in the Office 2010 architecture, i.e., the availability of 64-bit Office applications. This note summarizes how the changes affect developers. I imagine there is a comprehensive list somewhere in the microsoft.com universe but I could [...] Read More...

Published Fri, Aug 08 2011 2:48 PM by Daily Dose of Excel

Filed under: VBA, Windows API, Excel 14

Read INI File in VBA

The “preferred” method for storing application parameters is the registry. But I’m a maverick. I still use ini files. What I didn’t know was that there are Windows API functions for reading and writing to an ini file. Oh, the time I could have saved. This an example of reading and writing [...] Read More...

Published Tue, Apr 04 2011 2:28 PM by Daily Dose of Excel

Filed under: Windows API

Declaring API functions in 64 bit Office

Hi everyone, The release date of Office 2010 is closing in and with this new version we’ll have a new programming challenge. Office 2010 comes in a 32 bit and a 64 bit version. Especially API function declarations need to be adjusted for the 64 bit environment. We’ll have to change a declaration like this one: Private [...] Read More...

Published Thu, Jan 01 2010 12:14 PM by Daily Dose of Excel

Filed under: VBA, MVP, Automation, Windows API, Excel 14, Variables and Data Types

Opening Outlook Attachments

I don't know why there's not an easier way to open attachments from an email I'm viewing, but there's not. I made stole some VBA code to do the job. First, I borrowed JP's code to Open Any Email Attachment From Outlook. Then I changed a few things. I only wanted to open [...] Read More...

Published Tue, Apr 04 2009 5:17 PM by Daily Dose of Excel

Filed under: Windows API

Get the Path to My Documents in VBA

VBA has an Environ function. To get a list of all the Environ variables you can see, you can use the method at VBA Express. I use the USERPROFILE argument like this Public Function MyDocsPath() As String MyDocsPath = Environ$("USERPROFILE") & "\My Documents\" End Function You can also use the Windows [...] Read More...

Published Thu, Feb 02 2009 6:25 PM by Daily Dose of Excel

Filed under: Windows API

Syndication

Recent Posts

Tags

News

Archives

An MSForms Treeview

Excel 2013, SDI and modeless userforms

Find Matching Data in Array Speed Test

Copy Chart as a Picture

Save a global variable in an Excel workbook

Office 2010 VBA

Read INI File in VBA

Declaring API functions in 64 bit Office

Opening Outlook Attachments

Get the Path to My Documents in VBA