Finance

Charts

Statistics

Macros

Search

What You Need to Know About the Internet with Excel VBA

The convenient interface of the World Wide Web (WWW) links the vast number of resources available on the Internet. Using the WWW, you can move among thousands of computer nodes, system applications, files, and documents. The ease of moving between documents and the ability to read them on any computer system has enabled organizations to adopt web technology. Many corporations and enterprises develop their own networks based on Internet technologies (intranets) to host internal information intended only for employees.

Thus, when accessing resources located on other computers, we are dealing with resources of a computer network. A computer network is two or more computers connected by a shared data transmission channel. By territorial and organizational characteristics, computer networks are divided into:

  • Local Area Networks (LANs) — cover an organization, a group of organizations, or a district and use a single high-speed data transmission channel;
  • Wide Area Networks (WANs) — operate worldwide and use all possible communication channels (including, for example, satellite links).

A local network is usually called an intranet, whereas the global world-wide network is called the Internet. As a rule, the architectural principle for building networks is the client–server model.

Today, the Internet is a virtual space consisting of software, networks of various tiers, computers, and terminals (for data input and display) that is constantly growing and being updated to meet the new needs of modern society. The many local computer networks that make up the Internet are interconnected by high-speed communication channels at the continental level.

Given the enormous number of networks that form the Internet, to get to the right place you need to know the address formats in use. The numbers used to identify a computer on the Internet are called IP addresses. Every computer on the Internet has a unique IP address consisting of a combination of four groups of digits, each not exceeding 255 in decimal notation. Because an IP address is not very convenient for users, every computer on the Internet also has a DNS address (Domain Name Service), for example, www.domainname.org. Such a name is called a domain name.

To access a particular type of resource available on the Internet—for example, to view information published on a page—you must enter the address of that page on the Internet. This address is called a Uniform Resource Locator (URL). Depending on how the document must be accessed (through a local disk, a local network, a web site, or a file archive), the URL may look different (even for the same document). A URL consists of two parts: a protocol specifier for accessing the given resource and a location specifier for the resource itself. For example:

  • file://c:\sales\sales.htm — a file on the local computer;
  • file://brig\sales\sales.htm — a file on a computer in the local network;
  • http://brig/sales/sales.htm — a file on a web server in an intranet;
  • http://brig.boreas.ru/sales/sales.htm — a file on a remote web server on the Internet;
  • ftp://brig.boreas.ru/sales/sales.htm — a file on a remote FTP server on the Internet.

If a specific file is not indicated in the URL, the web page configured as the default for that web server opens.

The term “web server” (web site) can be interpreted in several ways. On the one hand, it is a set of documents connected by hyperlinks (in this case the web server has a main page from which all other pages are reachable in one or more steps). On the other hand, the term “web server” can mean the computer on which this set of documents is hosted and made accessible over a local or global network. Finally, the term may also refer to the software intended to provide access to the set of documents over a local or global network. Throughout this chapter, unless noted otherwise, we mean the first definition of “web server.”

A web page (or Internet page, or HTML document) is a text file that contains special document markup commands. If you open a web page in a plain text editor (for example, Notepad), you will see exactly these commands. However, when opened with a web browser such as Internet Explorer, Mosaic, or Netscape, the web page can display text, graphics, hyperlinks to other documents, and also controls. The secret is that a web browser contains an interpreter of HTML commands embedded in the web page file.

HTML (Hypertext Markup Language) is a document markup system for subsequent publication on the World Wide Web. Documents prepared in HTML format include images and links as well as formatting commands. To view these documents, a web browser (for example, Microsoft Internet Explorer) is used.

A hyperlink is text highlighted in blue or underlined (or otherwise styled as defined by the user), or a graphical image. Clicking a hyperlink navigates to a file, to a specific location within a file, to an HTML page on the World Wide Web, or to an HTML page in an intranet. Hyperlinks can also point, for example, to a terminal emulation protocol (Telnet), to newsgroups, or to FTP sites. As you move between pages via hyperlinks, a browsing history of all pages is created and stored. Web browsers such as Internet Explorer have navigation buttons on their toolbars that allow you to move forward or back from one viewed page to another.

Publishing is the process of outputting tables, forms, and reports in static or dynamic HTML format and then deploying all related files as World Wide Web applications to a web server, for example, Microsoft Internet Information Server or Microsoft Personal Web Server.

To view information published on the Internet, special programs called browsers (web browsers) are used. Browsers provide users with access to information, convenient tools for viewing it, and tools for creating their own web pages.

One well-known browser used as a convenient and reliable means of navigating Internet resources is Microsoft Internet Explorer.

With Internet Explorer you can not only view web pages, but also work with Microsoft Office Word documents, Excel worksheets, and PowerPoint presentations regardless of whether the document was saved as a web page or in the application’s standard format. When opening documents saved in the standard format of the application that created them, the corresponding application’s menus and toolbars appear inside Internet Explorer, allowing you to edit the document directly in Internet Explorer. This has become possible thanks to ActiveX technology.

Main Internet Services

  • WWW (World Wide Web) — a tool for working with hypertexts, allowing the retrieval and storage of different types of information (text, graphics, video, audio, etc.); hypertext documents are hosted on web servers that are part of the Internet.
  • FTP (File Transfer Protocol) — a method of transferring files between computers in the network regardless of their types, operating systems, file systems, or file formats.
  • E-mail (Electronic Mail) — a means of sending and receiving electronic messages between network users.
  • Usenet (newsgroups) — a service for distributing electronic messages among network users (one message is sent to a large group of users for public discussion).
  • IRC (Internet Relay Chat) — a service for real-time direct communication on the Internet among many users.
  • ICQ (I seek you) — an interactive communication service for users of the World Wide Web, which does not require a permanent IP address.

A user of this service registers on the central server www.icq.com and receives a personal identification number — UIN (Universal Internet Number) — which can always be used to establish contact with other users of the network who are also using this interactive communication service.

Microsoft Office and the Internet

Microsoft Office integrates two powerful information technologies that define the model of working with a computer.

  • The first is based on the ability to store information anywhere — on a local hard disk, in a local or corporate network, or on the Internet.
  • The second is based on the principle that users actually work not with applications but directly with documents and the information contained in them.

As a result, one of two possible approaches to working can be chosen:

  • Working mainly with Microsoft Office applications, with occasional access to the intranet or the Internet for a needed web page, a document, an add-in for an application, or additional information about a program.
  • Working mainly within the Internet Explorer browser, using it as the single environment in which you can view and edit any document located on your hard drive, in the company’s network, or on the Internet.

 

0 0 votes
Évaluation de l'article
S’abonner
Notification pour
guest
0 Commentaires
Le plus ancien
Le plus récent Le plus populaire
Online comments
Show all comments
Facebook
Twitter
LinkedIn
WhatsApp
Email
Print
0
We’d love to hear your thoughts — please leave a commentx