[mso] Re: Excel visual basic command
- From: "Greg Chapman" <greg@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 15 Sep 2003 21:52:01 -0500
This will seem OT but I'm offering it as an example of why we should all,
perhaps, feel a little more grateful for plain english programming
languages like VBA. Take a look one of the Notices to Airmen that every
pilot flying in the US today gets to translate and understand before
taking off:
Data Current as of: Tue, 16 Sep 2003 01:13:00 GMT
3/9082 - 3/9052 CANCELLED BY FDC 3/9082 ON 09/16/03 01:07
CANCEL 3/9052 - PART 1 OF 3 FLIGHT RESTRICTIONS DREXEL HILL, PENNSYLVANIA,
SEPTEMBER 15, 2003 LOCAL. PURSUANT TO TITLE 14, SECTION 91.141 OF THE CODE
OF FEDERAL REGULATIONS AIRCRAFT FLIGHT OPERATIONS ARE PROHIBITED WITHIN 30
NMR UP TO BUT NOT INCLUDING FL180 OF 395648N/0751856W OR THE OOD008018.6
FROM 0309151835 (1435 LOCAL 09/15/03) UNTIL 0309160010 (2010 LOCAL
09/15/03). WITHIN 10 NMR UP TO BUT NOT INCLUDING FL180 OF 395648N/0751856W
OR THE OOD008018.6 FROM 0309151835 (1435 LOCAL 09/15/03) UNTIL 0309160010
(2010 LOCAL 09/15/03). EXCEPT AS SPECIFIED BELOW AND/OR UNLESS AUTHORIZED
BY ATC: A. ALL AIRCRAFT OPERATIONS WITHIN A 10 NMR AREA LISTEDABOVE ARE
PROHIBITED EXCEPT FOR: 1. LAW ENFORCEMENT AND MILITARY AIRCRAFT, DIRECTLY
SUPPORTING THE UNITED STATES SECRET SERVICE (USSS), EMERGENCY MEDICAL
FLIGHTS, REGULARLY SCHEDULED COMMERCIAL PASSENGER AND CARGO AIRCRAFT THAT
MEET OR EXCEED THE TSAS DOMESTIC SECURITY INTEGRATED PROGRAM STANDARDS AND
ARE ARRIVING INTO AND/OR DEPARTING FROM 14 CF
R PART 139 AIRPORTS. 2.. FO
PART 2 OF 3 FLIGHT RESTRICTIONS DREXEL HILL, PA. GOING INTO EFFECT TO
AVOID POTENTIAL DELAYS. B. WITHIN THE AIRSPACE BETWEEN 10 NMR AND 30 NMR
RESPECTIVELY AREA LISTED ABOVE: 1. ALL AIRCRAFT ENTERING OR EXITING THE 30
NM RADIUS TFR SHALL BE ON AN ACTIVE IFR OR VFR FLIGHT PLAN WITH A DISCRETE
CODE ASSIGNED BY AN AIR TRAFFIC CONTROL (ATC) FACILITY. AIRCRAFT SHALL BE
SQUAWKING THE DISCRETE CODE PRIOR TO DEPARTURE AND AT ALL TIMES WHILE IN
THE TFR. 2. ALL AIRCRAFT ENTERING OR EXITING THE 30 NM RADIUS TFR MUST
REMAIN IN TWO-WAY RADIO COMMUNICATIONS WITH ATC. 3. ALL AIRCRAFT OPERATING
WITHIN THE AIRSPACE BETWEEN A 10 TO 30 NM RAIDUS TFR AND OPERATING AT
ALTITUDES OF UP TO BUT NOT INCLUDING FL180 ARE LIMITED TO AIRCRAFT
ARRIVING OR DEPARTING LOCAL AIRFIELDS AND ATC MAY AUTHORIZE TRANSIT
OPERATIONS. AIRCRAFT MAY NOT LOITER. 4. FLIGHT TRAINING, PRACTICE
INSTRUMENT APPROACHES, AEROBATIC FLIGHT, GLIDER OPERATIONS, PARACHUTE
OPERATIONS, ULTRALIGHT, HANG GLIDING, BALLOON OPERATIONS AGRICULTURE/CR
OP DUSTING, ANIMAL POPULAT
PART 3 OF 3 FLIGHT RESTRICTIONS DREXEL HILL, PA. MEET OR EXCEED THE TSA(S)
DOMESTIC SECURITY INSPECTION PROGRAM STANDARDS; ARE NOT AUTHORIZED. 5. ALL
U.S. SECRET SERVICE CLEARED AIRCRAFT OPERATORS BASED IN THE AREA SHOULD
NOTIFY THE US SECRET SERVICE PRIOR TO THEIR DEPARTURE. 6. ALL MEDICAL
FLIGHT OPERATION COMPANIES SHALL COORDINATE WITH THE USSS PRIOR TO THIS
NOTAM GOING INTO EFFECT TO AVOID POTENTIAL DELAYS WHEN THE NOTAM IS IN
EFFECT. C. IT IS RECOMMENDED THAT ALL AIRCRAFT OPERATORS CHECK NOTAMS
FREQUENTLY FOR POSSIBLE REQUIRED CHANGES TO THIS TFR PRIOR TO OPERATIONS
WITHIN THIS REGION. END PART 3 OF 3 WIE UNTIL UFN
*END*
Folks, that's precisely how they look when we get 'em. And,not to show
off, here's all that it boils down to: The president was to be in the
vicinity of Drexel Hill, Pa. today. Within 10 miles of a point on the map,
no aircraft may fly below 18,000 feet without being operated by civil
authorities or without a specific, controller issued transponder code. All
flights must be on a flight plan and in constant communication with
controllers. No loitering, no training, no practicing. And it WIE UFN
(Will be In Effect Until Further Notice).
I like VBA.
Greg Chapman
http://www.mousetrax.com
"Counting in binary is as easy as 01, 10, 11!
With thinking this clear, is coding really a good idea?"
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
