Entries from Project tagged with 'excel'

VBA returns in Excel 2011 for Mac

One of the things that I missed in the last version of Excel for the Apple Mac was that VBA was dropped. If you read this blog you will know how useful VBA can be for automating a bunch... read more.

Office VBA for Mac After 2008

For those who work on Apple Macs there was some good news today. Microsoft announced that it is bringing back VBA support for the Macintosh version of Office. Support will be coming in the versions after 2008. Here is the... read more.

Analyze Microsoft Project Resource Usage Data In Excel

The "Analyze Timescaled Data In Excel" add-in which ships with Microsoft Project has a couple of limitations, the first is that it is not easy to find, and the second is that it is task-based only, so if you want... read more.

Microsoft Project VBA - the Instr function

The Instr function is used to find out if one set of characters (string) is contained in another. It can be used in VBA macros (in Word, Excel, Project etc.) and also in Microsoft Project and Microsoft Project Server Custom... read more.

VBA Writing to a text file (MS Project, Excel)

One common question is how do I write from an office app like Excel or Project to a text file. I have the code embedded in a few samples here, but this short sample shows it most clearly. There are... read more.

MS Project VBA - Trim Function

Solving a recent custom field formula problem required reaching into the toolbox and pulling out the trim() string function. Trim is one of the simplest string functions. It does one thing and does it well. It just strips any leading... read more.

Project Scheduling with Excel

For the "I Hate Microsoft Project" crowd some new hope glittered today with a couple of posts on making Project schedules and charts in Excel. The secret is using an xy chart with error bars (my version uses formulas and... read more.

Do your own SEO - Using Excel and Grep to read log files

I'm always curious about how you arrived here. It seems that the majority find their way through a search on google. The reason I know this is because I take a look at the log files from my server. If... read more.

Feed Subscription

If you use an RSS reader, you can subscribe to a feed of all future entries tagged 'excel'. [What is this?]

Subscribe to feed Subscribe to feed

Other Tags

Other tags used on this blog: