The PC HelpSite
Office Tutorials & Software Solutions
Specializing in Advanced Spreadsheet & Office Macro Solutions.
Been away? What's new in February 2005?

Date Published: 2/5/2005 Version: 1.00
OfficeHelp.Biz February 2005 News

Hello! Welcome to OfficeHelp.Biz February 2005 Newsletter. Have you checked OfficeHelp.Biz recently? A lot has happened in OfficeHelp.Biz since the January Newsletter. 

DEMOS have been made available of almost all our macros, during January. Working versions, limited on the scale of the output they will generate, are available for FREE DOWNLOAD. Test-drive our products.

Access to the free content was limited to the newsletter subscribers. Subscribing to the OfficeHelp.Biz newsletter is free and the only requested information from you is an email address. There are no privacy risks, as we know nothing about you. But, even if we did, we wouldn’t share it with anyone else, as our Privacy Policy clearly states. To access the FREE PC Tips, once registered, all you need to do is to enter your email into the first access to a free content. Your login will be remembered on subsequent pages during the same session.

The Articles session title was changed to Tutorials because it better reflects it's content and makes a clear distinction with PC Tips. Tutorials are in-depth articles on how-to do something, step by step. PC Tips are smaller, less detailer tips on how to make the most of your office or home PC, as a regular but non-technical office user.

Update to the Browser Hijackers Tip

Last November we published a PC Tip about "Detecting and Removing Browser Hijackers". There is an important update on this subject. Reinforcing the growing importance of security and privacy issues, Microsoft itself has entered the browser hijacker detection and removal field. They acquired an existing company had published a website dedicated to this subject, including a FREE DOWNLOAD of a beta version of their future Browser Detection and Removal software.

It's worth checking, give it a try at

Recently added Contents

Have a corporate Laptop? Can't use IE (Internet Explorer) at home or on public wireless HotSpots? 

Our first FREE macro. Running on Excel, this macro easily switch IE (Internet Explorer) connection settings between Corporate and Home / Public Hotspot (wireless) network settings. Corporate networks have extra security levels and don’t let their users to directly connect to the Internet. An intermediate server, also known as a Proxy, is usually necessary. But it is only available at the Office, so it will prevent Internet connection from home or a public wireless hotspot.

While you can swap the settings manually, this is tiresome. The settings are well hidden (I bet Microsoft doesn't want regular users like you messing with it!) and you will need a lot of clicks before you can even access it. With this macro, all you need to do is to press a button to swap between office / home network settings.

PDF is a generic document format created by Adobe that become increasing popular with the internet, in the mid-90's. It is nowadays, by far, the dominant format for complex document publishing on the Internet. While HTML is used to create pages, PDF is used to publish "printed" or "for print" documents. It is the usual format for internet publication of corporate accounts reports, brochures, e-Books and all other multi-page documents.

It's popularity lies on the fact that it can preserve all formatting from the original documents, regardless of what software was used to make the original, and that it's reader (Adobe Acrobat Reader) is free and available for most computer platforms (Windows, Mac, Linux, etc). So, a PDF document will be freely readable by almost everyone, while retaining all original formatting. Try that with any other document format!

But while reading someone else published PDF's is easy, making them is another story. The free reader is only that, a reader. You can't make PDF files with it. But making PDF files can be as easy as printing, and for Free.

Find out how to convert your existing and future documents to PDF, for FREE.

New Contents to be published during February 2005

The following contents is intended for publication1 during February, in time for the March Newsletter:

  • MACRO: Internet Explorer Privacy Manager, in Excel – Every time you use your browser, it will register information about the pages you visited. This can be annoying and even misused. You can manually clear most of this information, but it is a time consuming process. There are commercial software around to clean it, but they are expensive and cannot be used on corporate PCs, where software installation is usually locked to end-users. Want to easily and fast clean all the records IE makes about your browsing? This macro is an excel file and will run on any computer with Excel just by pressing one button. Clean your navigation trail.
  • PC TIP: Copy text formats in MS Word – Recognize the problem? You're typing a word document and the text is in a different format from another document or even part of the same document. You need to harmonize. So you need to check the format of the source document and manually apply each format to the new text, right? WRONG. It is possible to copy formats between blocks of text, from the same or different documents, as easily as copy/paste. Save time and trouble formatting professional looking word documents.
  • PC TIP: Insert footnotes in MS Word – Ever read a professional document with numbered footnotes on the bottom of each page? Would like to replicate them on your Word documents? It is really easy, Word will even take care of the numbering for you. Learn how on this useful 5-minute tip. Make more professional looking documents with this trick.
  • TUTORIAL: Making Outlook email backups – Do you use Outlook to store your email? Do you have email archives that include almost all your professional life from the last few years? If you're anything like most regular users, losing your email archives would be a professional catastrophe. While corporate IT departments usually backup all email stored on the server, local archives on your own hard drive are at risk, both at home and the office. Learn how to backup the email archive files on this tutorial. Save yourself from this impending catastrophe

1 This list is a forecast and doesn't guarantee publication of the listed contents

Get FREE PC TIPS every month:



(c) 2004 - 2023 OfficeHelp.Biz