Entries from Project tagged with 'excel'
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?]
