Specializing in Advanced Spreadsheet & Office Macro Solutions.

Date Published: 6/27/2006

Version:

1.00

New Major Excel Macro Release - OfficeHelp.Biz July 2006 News
OfficeHelp.Biz July 2006 News
Printer friendly version

Hello! Welcome to OfficeHelp.Biz July 2006 Newsletter.

Table of Contents:

Introduction
New ADVANCED Edition of the Calendar Plan Generator – 9 new features including 2 completely new calendar types
FREE PC Tips – Two new articles published since our last newsletter
- Hiding / Unhiding windows folders on the hard disk
- Record your own macros

Introduction

It’s been 6 months since our last newsletter (early December). Newsletters from OfficeHelp.Biz are only sent when there is relevant new content, as happen this month.

Our main product, the Excel based Calendar Plan Generator, has a brand new version with 9 brand new features, including 2 new types of Calendars (Monthly and Yearly), Outlook data import and FULL customization.

There are also 2 new FREE PC Tips, regarding privacy and Office automation. Check them below on this newsletters. Articles are completely free, just click on the title links.

As an EXTRA, only available to our newsletter subscribers, there is also a FREE download link for our PC TIPS in PDF file. Download 14 of our 16 PC tips in a single PDF file, for free. This product is usually commercial.

Calendar Plan Generator ADVANCED Edition

Generate ADVANCED Project style calendar plans, just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. Includes ADVANCED features like EXTRA plan types, detail filtering, optional fields, extra information of task bars, full customization and Outlook integration.

MORE INFORMATION? Check the ADVANCED Edition page!

Screen Shot from the resulting DAILY Microsoft® Excel File (Click to Enlarge)

Screen Shot from the resulting WEEKLY Microsoft® Excel File (Click to Enlarge)

Screen Shot from the resulting MONTHLY Microsoft® Excel File (Click to Enlarge)

Screen Shot from the resulting YEARLY Microsoft® Excel File (Click to Enlarge)

MORE INFORMATION? Check the ADVANCED Edition page!

The NEW ADVANCED Edition has several exclusive features not previously available:

FULLY CUSTOMIZE the look of your calendars by defining sample cells for each plan area: headers, task bars, backgrounds and columns widths. Set the plan to your look instead of manually formatting the output each time a plan is generated!
EXTRA PLAN OPTIONS with Two Extra Plan Types - Monthly and Yearly in addition to the previously existing Daily and Weekly, all generated from the same task list!
BETTER PLANS WITH LESS EFFORT with Optional Fields to easily add or remove heading columns, Improved Readability by including start and end dates directly on each task bar (Weekly and Monthly plans) and Detail Management - include or exclude task levels from plans to differentiate long-term (Monthly, Yearly) to short-term (Daily., Weekly) plans without having to write separated task lists!
OUTLOOK Integration: Import tasks or calendar events from Outlook with a highly customizable setup!
INVESTMENT PROTECTION for previous version customers, 100% compatible with previous version task lists, just copy/paste them into the ADVANCED Edition to benefit from the extra features!

MORE INFORMATION? Check the ADVANCED Edition page!

Screen Shot from the Microsoft® Excel Macro File (Click to Enlarge)

Consultant? Developer? Corporate IT? Make your own BRANDED version!!!

Rebrand messages and interface with YOUR logos and trademarks! Add missing features or adjust existing ones to your clients special needs. Supply it as your own product:

Link to the CUSTOM Edition - No coding, just enter YOUR own messages to replace our own branded messages and learn how to replace the logo, lock your changes (make them permanent) and distribute YOUR own BRANDED version of our macro! No coding! Check the licensing terms.

Link to the Source Code Edition - Add missing features or adjust existing ones to your clients special needs. Supply it as your own product. Full access to the Macro source code. If you know Excel VBA you should have no problems understanding this macro. Check the licensing terms.

New FREE PC Tips

Two new PC Tips have been published since our last newsletter. Click on TITLES to read the full article:

Hiding / Unhiding windows folders on the harddisk - Sometimes, it is nice to be able to keep some secrets from prying eyes. It is possible, in a very simple manner, to hide windows folders so that they don't become visible when browsing or searching the harddisk. It is very easy to hide folders in Windows. These folders are not visible under the regular Windows folder settings, but in fact they may be made visible with a single tweak. This is very basic privacy. There is, however, the stronger possibility of encryption and the utilization of extra software to add an extra degree of privacy

Create YOUR OWN Microsoft® Office Macros - Macros are software applications that run inside other applications, like Office packages. While some very sophisticated macros are real pieces of Software, demanding professional developers, ANYONE can create their own automation macros in any of the Microsoft® Office applications. They are very useful to extend the usefulness and productivity of the Office applications. As an example, in this website you can find, among others, Macros that build calendar plans using Excel and no extra software. Macros exist for all current Office applications, but only the most recent versions of Outlook (from 2000) support them (previous version have a different programming model). This article will use EXCEL for illustrations purposes, but in general its concepts will apply to all Microsoft® Office Applications.

¹ ^{OfficeHelp.Biz}^reserves^{the right to}^change^{prices without notice.}

00052- Design Chart Templates for Microsoft® Excel®		Microsoft Excel	Templates
The easiest way to create design charts. Check the samples, enter your own data and watch as your charts update. Multiple different charts from the same data, with many automatic calculations made for you. No code, macros, formulas or other complicated stuff. Just fill in YOUR data and watch the charts update automatically.

00054- Automatic Copy/Paste for Microsoft PowerPoint®		Microsoft Excel	Macro
Automatically update hundreds of Microsoft PowerPoint® slides, charts and tables from Excel in minutes. With the click on a button. Easily configure the updates you need. Copy from multiple Excel files. Resize and place pasted charts & tables – or just keep their original size & position.

00051- Organization Chart Maker for Microsoft® Excel®		Microsoft Excel	Macro
Quickly and easily generate your own organization charts from a plain list of data with Organization Chart Maker for Microsoft® Excel®. Apply colors and formats. Integrate external data from ERP or HR management systems like or Microsoft® Dynamics Navision, SAP®, PeopleSoft®, Oracle®, etc. Chart Stock & Portfolio listings, team members planning & company ownership charts.

00037- Traditional Calendars for Excel		Microsoft Excel	Macro
Easily generate annual and monthly Traditional & Planning calendars you can print and distribute, based only in Microsoft® Excel®. Five different formats available. Use special colors for special days or events, like holidays or meetings. Automatic event legend. Configurable background and font colors. Optional calendar background image. Traditional, Academic and Fiscal years. Imports data from Microsoft ® Outlook®.

00047- Calendar Templates 2014 with Holidays (USA / UK / Australia / Canada) for Excel		Microsoft Excel	Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for Microsoft® Excel®. Includes versions with Holidays for the USA, UK, Australia and Canada.

00044- Custom GANTT Charts for Microsoft® Excel®		Microsoft Excel	Macro
Generate CUSTOM Project style calendar plans with the EXCLUSIVE option to customize our COPYRIGHT messages to create YOUR own REBRANDED Edition. Includes all ADVANCED Edition features plus the REBRANDING option. Distribute CORPORATE versions to your staff.

00027- Get all OfficeHelp.Biz CALENDARS at once!		Microsoft Excel	Bundles
Interested in more than one of our Microsoft® Excel® Calendars? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?

00046- Calendar Templates 2007 with Holidays for Excel		Microsoft Excel	Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for 2007 in Excel. Include USA Holidays.

00002- Calendar Plan Generator - ADVANCED Edition		Microsoft Excel	Macro
Generate ADVANCED Project style calendar plans, just by entering the tasks and associated data like its name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel® file. Includes ADVANCED features like EXTRA plan types, detail filtering, optional fields, extra information of task bars, full customization and Microsoft® Outlook® integration.

00040- Get all OfficeHelp.Biz TEMPLATES at once!		Microsoft Excel	Bundles
Interested in more than one of our Templates, including all Excel Calendar Templates? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?

00036- Calendar Plan Generator - Source Code Edition		Microsoft Excel	Macro
Generate Project style calendar plans (weekly only), just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. SOURCE CODE available for changes for VBA Macro developers.

00043- Calendar Plan Generator - BASIC Edition		Microsoft Excel	Macro
Easily generate Project style calendar plans, just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. The SIMPLEST edition, just ONE button to use!

00028- Calendar Plan - Year Planner Template		Microsoft Excel	Templates
Create pretty yearlong planning calendars in minutes. Save time and effort. Ready to use calendar template! Really useful to set yearlong event like general meetings, special groups, holidays and all other long-term schedules. Regular Excel file, sample included.

00001- Queue Servicing Calculator		Microsoft Excel	Macro
Calculates the average waiting times and people (or item) processing times based on some input estimates. Can be used to make service capacity simulations or to measure the service throughput on any service or process demanding waiting queues.