Browse by Tags

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

Preventing auto_open and Workbook_Open events from running

As a fulltime developer I oftentimes open files containing VBA and want to be able to run code. At the same time I sometimes want to prevent Workbook_Open event code or an Auto_Open macro from running. With Excel 97 to 2003, this was simple: hold the shift key when you click “Enable macros”. With Excel 2007 and [...] Read More...

Published Mon, Dec 12 2009 8:35 AM by Daily Dose of Excel

Filed under: Excel12, VBA, MVP, Events, Excel 14

Office Web Apps

I’m trying to be the last blog on earth to announce the Office 2010 Beta. Included in 2010 are Office Web Apps. With Microsoft Office Web Apps, you can access documents from virtually anywhere. Whether you’re editing a document from home or collaborating with someone around the world, Office Web Apps help you work the [...] Read More...

Published Fri, Nov 11 2009 7:00 AM by Daily Dose of Excel

Filed under: Excel 14

Office 2010 Icons

Here’s Excel: See the rest at CyberNetNews. Read More...

Published Wed, Sep 09 2009 10:01 AM by Daily Dose of Excel

Filed under: Excel 14

Using VBScript to monitor Office events…or not

I spent an unexpectedly long time trying to figure out how to monitor Office events using VBScript and this post shares my experience, largely disappointing. The below scenarios were tested with Vista Ultimate and Office 2007 as well as with Windows 7 Ultimate and Office 2010 Beta. This is about using VBScript through the Windows [...] Read More...

Published Wed, Aug 08 2009 9:00 AM by Daily Dose of Excel

Filed under: Excel12, Excel 14

Golf Charts — Another Take

Inspired by Dick’s interest in charts, I took a look at how I would have presented the data. Some overall thoughts. I used Office 2010 beta for the charts shown below. There was not much, if any, difference between what I would have got with Excel 2007. I also stayed with the default [...] Read More...

Published Mon, Aug 08 2009 2:13 AM by Daily Dose of Excel

Filed under: Charting, Excel 14

Make Office Better

JP posted about Make Office Better, so I checked it out. First, I have to say that I love the design of the site. I didn’t know anyone at MS knew how to design clutter-free websites anymore. Maybe that could add a few more suggestions per page and get rid of the [...] Read More...

Published Tue, Aug 08 2009 12:13 PM by Daily Dose of Excel

Filed under: Excel 14

Office 2010 Trailer

via Tony’s Microsoft Access Blog Read More...

Published Fri, Jul 07 2009 5:25 PM by Daily Dose of Excel

Filed under: Excel 14

Office “14” – Microsoft Office 2010

Hi all, The word is out! We now have an official name for Office 14 and some sort of a date too. Regards, Jan Karel Pieterse Read More...

Published Thu, Apr 04 2009 10:02 AM by Daily Dose of Excel

Filed under: Excel 14

VBA Here to Stay

Clarification on VBA Support In case you missed it: We understand that VBA is a critical capability for large numbers of our customers; accordingly, there is no plan to remove VBA from future versions of Excel. And if you want to read some 2.5 year old predictions about VBA, go revisit The Future of VBA Read More...

Published Tue, Mar 03 2009 2:30 PM by Daily Dose of Excel

Filed under: Excel 14

Office14 Sneak Peek

UX Evnagelist via Harlan’s Smurf Comment Read More...

Published Thu, Jan 01 2009 11:15 AM by Daily Dose of Excel

Filed under: Excel 14

Syndication

Recent Posts

Tags

News

Archives

Declaring API functions in 64 bit Office

Preventing auto_open and Workbook_Open events from running

Office Web Apps

Office 2010 Icons

Using VBScript to monitor Office events…or not

Golf Charts — Another Take

Make Office Better

Office 2010 Trailer

Office “14” – Microsoft Office 2010

VBA Here to Stay

Office14 Sneak Peek