HTG Asks: Office Doc Editing, Port Forwarding & Android Remote Control

Reader Questions: Weekly Roundup

Each week, we compile a selection of questions answered for our readership to benefit a wider audience. This installment addresses methods for mass-editing author information within Microsoft Office documents, configuring port forwarding on a network router, and establishing remote control access to an Android device.

Bulk Editing Authorship in Microsoft Office

A common inquiry concerns efficiently updating the author details across numerous Microsoft Office files. This can be achieved through scripting or specialized software designed for metadata manipulation.

The process involves accessing and modifying the document's properties, specifically the 'Author' field, in a batch manner. Consider utilizing tools that support automated metadata editing for large volumes of documents.

Setting Up Port Forwarding on Your Router

We received questions regarding the configuration of port forwarding. This process directs network traffic from the internet to a specific device on your local network.

Port forwarding is essential for hosting servers or accessing devices remotely. The exact steps vary depending on your router's manufacturer and model, but generally involve accessing the router's administration interface and creating a new forwarding rule.

Typically, you'll need to specify the external port, the internal port, the IP address of the target device, and the protocol (TCP or UDP).

Remotely Controlling Your Android Phone

Several readers asked about methods for remotely controlling their Android phones. Various applications facilitate this functionality, offering features like screen mirroring, remote access to files, and device control.

Popular options include dedicated remote control apps and screen sharing software. Ensure the chosen application is reputable and prioritizes security to protect your device and data.

These apps generally require installation on both the Android device and a controlling device (such as a computer or another smartphone). Following the app's setup instructions will enable remote access and control.

Modifying Authorship Information in Microsoft Office Documents in Bulk

Dear How-To Geek,

A persistent issue with my Microsoft Office installation concerns document authorship. The computer I currently use was previously assigned to a colleague, and consequently, his name is consistently listed as the "Author" for all documents. I require a method to rectify this.

I have a substantial number of Office files – thousands, in fact – and have successfully updated the Author field for approximately one-eighth of them to reflect my own name. However, performing this task manually is proving to be incredibly time-consuming.

Is there a way to establish a default Author Name for files, and to implement this change across all files within a folder, or even system-wide?

Sincerely,

Office Editing in Edison

Dear Office Editing,

To begin, if you haven’t already, navigate to Word Options, then select "Popular," and finally "Personalize Your Copy of Microsoft Office." Within these settings, update the default Author name to your own to ensure all newly created documents are correctly attributed.

Addressing Existing Documents

For the existing documents that incorrectly display the previous author's name, a specialized application can significantly streamline the process. We recommend exploring Microsoft Word Document Properties, a tool developed by Easy HR.

Our testing confirms its effectiveness in modifying the specific document properties you wish to alter. The download process is straightforward; simply locate and click the download link, bypassing the information request form.

After installation, the application allows you to specify a directory containing the Word documents. It then facilitates a bulk change of the Author field to your desired name.

Important Precaution

Before applying this change to your entire document collection, we strongly advise creating a test directory and copying a representative sample of a dozen or two documents into it. This will allow you to verify the application's functionality and ensure the desired outcome without risking unintended consequences to your full file set.

Remember to always back up important data before making bulk changes to file properties.

Configure Your Router for Port Forwarding

Port forwarding is a crucial process for allowing external access to specific services running on a private network.

This technique redirects network traffic from a public IP address to a specific device within your local network.

Why is Port Forwarding Necessary?

Most routers act as a firewall, blocking unsolicited incoming traffic for security reasons. However, this can prevent legitimate access to services like game servers, web servers, or remote desktop applications.

Port forwarding creates an exception to this rule, allowing designated traffic to reach the intended destination.

Understanding Ports and Protocols

A port is a virtual point where network connections start and end. It's like an extension number for a phone line.

Common protocols used with port forwarding include TCP (Transmission Control Protocol) and UDP (User Datagram Protocol). Each service utilizes specific ports and protocols.

Steps to Configure Port Forwarding

The exact steps vary depending on your router's manufacturer and model, but the general process remains consistent.

1. Access Your Router's Configuration Interface

Typically, you can access this by entering your router's IP address (often 192.168.1.1 or 192.168.0.1) into a web browser.

You will then be prompted for a username and password – consult your router's documentation if you don't know these credentials.

2. Locate the Port Forwarding Section

This section may be labeled as "Port Forwarding," "Virtual Servers," "NAT Forwarding," or something similar.

It's usually found within the router's advanced settings.

3. Create a New Port Forwarding Rule

You'll need to provide the following information:

• Service Name: A descriptive name for the rule (e.g., "Web Server").
• Internal IP Address: The IP address of the device on your network that will receive the forwarded traffic.
• External Port: The port number that external users will connect to.
• Internal Port: The port number on the internal device that the traffic will be forwarded to. This is often the same as the external port.
• Protocol: Select TCP, UDP, or Both.

4. Save and Apply the Changes

After entering all the necessary information, save the rule and apply the changes to your router's configuration.

Some routers may require a reboot for the changes to take effect.

Testing Your Port Forwarding Configuration

To verify that port forwarding is working correctly, you can use online port checking tools.

These tools will attempt to connect to your public IP address on the specified port and report whether the connection is successful.

Security Considerations

While port forwarding can be useful, it also introduces potential security risks.

Only forward ports that are absolutely necessary, and ensure that the services you are exposing are properly secured with strong passwords and up-to-date software.

Consider using a firewall on the internal device to further protect it from unauthorized access.

Dear How-To Geek,

With my recent network configuration, I've introduced a router – a first for me! To ensure proper functionality of certain applications, I understand port forwarding is necessary. However, I'm unfamiliar with the process. Could you explain it? Is the concept similar to mail forwarding? I apologize for the potentially simplistic comparison. Any assistance would be greatly appreciated.

Port Baffled in Buffalo

Dear Port Baffled,

Your analogy isn't terrible at all. Essentially, port forwarding directs network traffic. Your router receives a data stream, either originating from within your network or arriving from the outside world.

This stream is then redirected to a specific port number. Think of it as a redirection service within your router.

This process ensures smooth operation, even when the externally visible port differs from the internal port utilized by your applications. It's a subtle adjustment that maintains network functionality.

We have created a comprehensive guide detailing port forwarding and router configuration. This resource will address your concerns and assist you in optimizing your router settings.

You can find this guide and learn more about how to effectively manage your network's ports through the provided link. It offers a detailed explanation of the process.

Controlling an Android Device Remotely

A reader from Texas reached out with a specific request: the ability to control their Android device from a computer, without interrupting their workflow.

They expressed a desire to avoid physically interacting with their phone to manage tasks like responding to text messages, preferring to maintain focus on their computer monitor.

The Challenge

The user wanted a solution that would allow simultaneous charging and remote control functionality, utilizing a mouse and keyboard for interaction.

This setup aims to enhance productivity by minimizing distractions and streamlining task management.

The Solution: Android SDK and Android Screencast

We employ a combination of the Android SDK and a Java-based application called Android Screencast to achieve this.

While the initial setup process isn't the most straightforward, the resulting system is remarkably user-friendly once configured.

This method allows for remote viewing and control of the Android device directly from the computer.

It’s a practical solution for maintaining focus and leveraging the efficiency of a keyboard and mouse.

Further Assistance

For detailed instructions on setting up this system, refer to our comprehensive guide available here.

Do you have a challenging tech question? Don't hesitate to email us at ask@howtogeek.com, and we will endeavor to provide assistance.