Daily posts of Excel tips…and other stuff
Archive for the ‘Excel 14’ Category.
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 [...]
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 [...]
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 [...]
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 [...]
Here’s Excel:
See the rest at CyberNetNews.
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 [...]
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 [...]
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 [...]
