Browse by Tags

Protect a global variable in another VB project

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 Wed, Nov 11 2011 1:45 AM by Daily Dose of Excel

Filed under: Excel12, VBA, Fluent UI, Excel 14, Excel Basic, Excel Intermediate

Slicer or Data Validation list

This note documents a somewhat creative – and I suspect an unintended – way of using a slicer. A slicer is a control element introduced with Excel 2010. It is a large easy-to-use control to filter the results of one PivotTable or even multiple PivotTables. I like the UI look-and-feel of a [...] Read More...

Published Sat, Oct 10 2011 5:51 PM by Daily Dose of Excel

Filed under: Data Validation, User Interface, Pivot Tables, Filtering, Excel 14, Controls, Data Visualization

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

Cardinal (real) numbers and a log scale for a Column Chart x-axis

The x-axis of a Column Chart can contains either category values (the x values are equidistant) or dates. Neither of these allows for a truly numeric x axis. This tip shows how to simulate a column chart that has cardinal numbers on the x axis (cardinal numbers contain a sense of ‘distance’ – [...] Read More...

Published Sun, May 05 2011 12:45 AM by Daily Dose of Excel

Filed under: Excel12, Charting, Excel 14, Data Visualization

Cardinal (i.e., real) numbers and a log scale for a Column chart x-axis

The x-axis of a Column chart can contains either category values (the x values are equidistant) or dates. Neither of these allows for a truly numeric x axis. This tip shows how to simulate a column chart that has cardinal numbers on the x axis (cardinal numbers contain a sense of ‘distance’ – [...] Read More...

Published Sun, May 05 2011 12:45 AM by Daily Dose of Excel

Filed under: Excel12, Charting, Excel 14, Data Visualization

Ordinal Numbers Suffixes

Starting with Excel 2007, it is possible to specify the number format as part of conditional formatting. This note shows how to leverage that capability to add the appropriate suffix to an ordinal number (e.g., 1st, 2nd, 3rd, 4th, etc.) For a version in a page by itself (i.e., not in a scrollable iframe as below) [...] Read More...

Published Mon, Apr 04 2011 2:08 AM by Daily Dose of Excel

Filed under: Excel12, Excel 14

Banding rows in an Excel Table

For a version in a page by itself (i.e., not in a scrollable iframe as below) visit http://www.tushar-mehta.com/publish_train/xl_vba_cases/0120-1%20banded%20rows.shtml Tushar Mehta Read More...

Published Mon, Apr 04 2011 7:11 PM by Daily Dose of Excel

Filed under: Excel12, Formatting, Excel 14, Data Visualization

Name Manager Updated

Hi All, I’ve just updated Charles Williams and my Name Manager utility. New in this version is that when you delete a range name, you will be asked whether you want to unapply the range name in your formulas. This should effectively prevent any #NAME! errors from surfacing when you remove a range name. I’m now off to [...] Read More...

Published Tue, Feb 02 2011 12:28 PM by Daily Dose of Excel

Filed under: Excel12, MVP, Downloads, Names, Excel 14

Slice and Dice!

Hi all, I had a bit of time to spare the other day (got snowed in during travel by train) and wrote a couple of pages about a new Excel 2010 feature: Pivot table slicers I show how to customise them and also included some VBA examples on how to work with them. Enjoy the read! Regards, Jan Karel Pieterse www.jkp-ads.com Read More...

Published Wed, Jan 01 2011 9:54 AM by Daily Dose of Excel

Filed under: General, VBA, MVP, Pivot Tables, Excel 14

Insert a screenshot with Office 2010

For a version in a page by itself (i.e., not in a scrollable iframe as below) visit http://tushar-mehta.com/publish_train/xl_vba_cases/0110_Office_2010_insert_screenshot.shtml Read More...

Published Wed, Nov 11 2010 10:15 PM by Daily Dose of Excel

Filed under: Excel 14

Preventing Workbook_Open events from running (2)

In Preventing auto_open and Workbook_Open events from running I descibed how to do exactly that. Well, it appears that the methods I gave do not always work with Excel 2007. A visitor of my website complained he could not prevent his Auto_Open macro from running and during a BeamYourScreen session I took over his desktop and [...] Read More...

Published Fri, Jul 07 2010 2:10 AM by Daily Dose of Excel

Filed under: Excel12, VBA, MVP, Excel 14

Button image add-in for 2007 and 2010

Hi all I want to let you know that I upload a new version of Jim Rech’s button image add-in today. You can find it in the “Find the names of the button images” section on my Ribbon page. This great Add-in is working now in Excel 2007 and in Excel 2010. While you there check out also my [...] Read More...

Published Wed, Jul 07 2010 3:06 PM by Daily Dose of Excel

Filed under: Excel12, Downloads, Excel 14

Importing text files in an Excel sheet

Hi there! Many times it is a newsgroup post which triggers me to do a writeup on a specific subject. This time, a user asked how he could import a csv file every month, without having to go through the hassle of renaming the file and re-defining the import settings each time. Opening the file in Excel [...] Read More...

Published Thu, Mar 03 2010 4:27 AM by Daily Dose of Excel

Filed under: Excel12, MVP, External Data, Excel 14, For Normal People

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

Syndication

Recent Posts

Tags

News

Archives