We'll start with the
strongest link from last round... It's -
-=+ NOISES FROM THE BASEMENT +=-
Vol. 2, Issue 14 June 20,
2001 ISSN 1531-5258
1) Windows Tips - "Extracting Microsoft DLL Files"
2) File Find! - "Worldview"
3) Sites-Seeing - "Nitpickers\World License Plates"
4) Email Funny - "Darts"
5) MOUS Tips - "Copy Values Only"
6) They Said It - quotes to give one pause
7) Hodgepodge - that what fits no where else
~ ~ ~
Greetings to all new readers! And a
sincere welcome back
to all of NFTB's
returning friends!
~and~
AOL users - see the newsletter end for your links!
_____________________________________________________
1) Windows
Tips -
"Extracting Microsoft DLL Files"
Continuing our look at replacing damaged DLL's:
Once you've determined that the DLL you need to replace is
a Microsoft file, you'll need to extract its replacement from a
Cabinet (.CAB) file. Most Win98 users
should find the
required CAB files on their hard drive; if not, then you'll
find them on your Win98 install CD in the Win98 folder.
The easiest way to find the CAB file that contains the DLL
you're looking for is to use Start | Find | Files or Folders.
In the "Named" control, key "*.cab" (sans quotes), tap your
Tab key, and in the "Containing text" control key the name
of the DLL you need. Click OK and
Windows will find any
CAB files that contain the requested DLL.
Note: if the DLL
you need is in more than one CAB file, check each CAB, then
extract and use the newest (by date) DLL you find.
Once you've found the target CAB file, you'll need to extract
the DLL. If you have a program like
WinZip or ZipFree
installed on your computer, you can use it to extract files
from the CAB file. If not, you'll need
to use EXTRACT.EXE,
a Microsoft-provided DOS program.
Because it is a MS-DOS
program, it must be used either in a MS-DOS window, or from
the Start | Run dialog box. The choice
is yours, though the
advantage of using a MS-DOS window is that you will see
any error messages (usually from typos); while if you use
Run, the window will close before you can read any messages.
The syntax to use EXTRACT is:
extract <cabinet> <filename> /l <destination>
For example: you need the MFC42.DLL file that is stored in
the WIN98_62.CAB file on your hard drive, and you want to
extract it to the C:\windows\system\ folder. (remember
-
make a copy or change the name of the original first!)
The command to key at the MS-DOS prompt would be:
extract
c:\windows\options\cabs\win98_62.cab<SPACE>
mfc42.dll /l c:\windows\system\
(Note: I had to type the command on two lines due to email
wrapping considerations; replace <SPACE> in the example
with a tap on the spacebar!)
Where:
c:\windows\options\cabs\win98_62.cab is
the complete path
to the CAB file;
mfc42.dll is the desired DLL you need;
/l tells Windows you're going to specify
a destination; and
c:\windows\system\ is the complete path
to the destination
folder.
Your DLL will be extracted and placed in the destination
folder, and you should be back in business!
-=++=- ~ ~
~ ~ ~
+ ~ ~ ~ ~
~ -=++=-
2) File
Find! -
"Worldview"
[5563 Kb/EXE]
Imagine you had the resources of the CIA Worldbook at
your
fingertips. Imagine having information
about 261 countries of
the world on your Desktop. Imagine
complete statistics on
Geography, People, Government, Economy, Communications,
Military, and Transportation - one click away.
Imagine no
more! With this week's File Find, you'll have this immense
collection of data immediately available!
http://www.basementnoises.com/free4u/dl101.htm
-=++=- ~ ~
~ ~ ~
+ ~ ~ ~ ~
~ -=++=-
3) Sites-Seeing -
"Nitpickers\World License Plates"
Are you a movie nitpicker? A nitpick can
be any little
detail, right or wrong, that you notice in a film. Things
like microphones or wires showing up in a scene, items
of technology that weren't available in the time period
depicted on-screen, or scientific facts that are misquoted
or just plain wrong.
The Nitpickers Site is a place to post your observed nitpicks,
and to comment on others' postings.
Visit the Top 10
Nitpicked Movies and see nitpicks about some of the most
popular movies of the past decade.
You're sure to watch
your next movie with a different perspective after spending
some time at this site:
http://www.nitpickers.com
~ ~ ~
After you've used this week's file find to read all
about the
population and products of
to have a look at the license plates you'd see on the typical
Romanian passenger car. "License
Plates of the World"
contains all the minutia one might ever want about
vehicle
identification plates worldwide. Photos,
history, markings,
and colorings are all provided. One day
you'll want this,
right?:
http://danshiki.oit.gatech.edu/~iadt3mk/index.html
-=++=- ~ ~
~ ~ ~
+ ~ ~ ~ ~
~ -=++=-
4) Email Funny -
"Darts" [780 Kb/EXE]
For the next time you find yourself on the phone, waiting
"on hold". Pull out this toy
from Office.com and make
the wait a bit less mind numbing. Darts,
board, chalk and
chalkboard all included:
http://www.basementnoises.com/free4u/dl102.htm
* * * A SPONSOR MOMENT * * * * * * * * * * * *
ITSAWORLD.NET - JOIN - ULTIMATE EMAIL.COM
to deliver a range of quality ezines to your Inbox
every week!
Ezine Publishers also need to check this out!
Find Out More: - http://www.ItsaWorld-of-Ezines.com
You Must Visit: - http://www.UltimateEmail.com
To Subscribe: mailto:IOE-subscribe@topica.comzzz
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
5) MOUS
Tips -
"Copy Values Only"
Reader Thomas R. writes: "I have an Excel workbook that
contains various formulas. I'd like to
take the results of
these formulas and use them in a different workbook. My
problem is that when I copy the cells that contain the
formulas and then paste them into the new file - instead of
copying the result, Excel copies the formula.
Is there a way
to copy only the results?"
There sure is, Thomas! By default, when
you paste a range
of cells containing formulas, Excel will retain the formula and
change the referenced cells - this is what let's you copy a
formula for a series of data and get the correct answer for
each data set without manually changing the cell addresses
in each copied formula. However, as
you've found out, this
is unsatisfactory when all you want is the result, and not the
formula.
Here's how you can get the results, only.
The initial steps
are the same as a "normal" copy & paste, only the final step
differs:
I) Select the range of cells containing
the formulas you
want to copy.
II)
Click the Copy icon.
III) Change to your destination file
(note: you can use this
process within a single workbook,
too.)
IV)
Select the destination cell.
V)
Select Edit | Paste Special, then select the Values
option. Click OK.
Voila! You now should have the desired
results only.
-=++=- ~ ~
~ ~ ~
+ ~ ~ ~ ~
~ -=++=-
6) They Said It
"Without involvement, there is no commitment.
Mark it down, asterisk it, circle it, underline it.
No involvement, no commitment." -- Stephen Covey
-=++=- ~ ~
~ ~ ~
+ ~ ~ ~ ~
~ -=++=-
7) Hodgepodge
Tired of the rat race? So was the
subject of this week's
Photo Funny. And, discover the impact of
new memory
research in this week's Bizarro article, only here:
http://www.BasementNoises.com
G'nite,
and thanks for reading!
=====================================================
Make some noises of your own! Care to
comment on this issue
of Noises? Send your criticisms and/or
compliments to:
mailto:noises@BasementNoises.com
=====================================================
-!-!-!-Subscribe to NOISES FROM THE BASEMENT-!-!-!-
If this issue of NOISES FROM THE BASEMENT has been
forwarded to you and you would like a subscription,
don't you want to receive the next issue directly?
You'll get it quicker, and you'll be sure to get it!
send mailto:signup@BasementNoises.com?Sub-news
or sign up online at http://BasementNoises.com/signup/index.asp?news
=====================================================
You have received this e-mail because I know you,
I used to know you, or I got your email address from
playing an Ozzy Osbourne
record backwards...
HOWEVER, if this does not describe you, your address
was submitted through one of the many marketing
venues I use, and your request is on record -
*I NEVER SPAM!*
If you DID NOT intend to sign up for this newsletter,
please click on link at very bottom of this email.
If you wish to change your email address reply to this message
with "Change of Address" in the subject line and include both
your old and new address in the body of the email.
Want advertising info? Send mailto:adinfo@BasementNoises.com
or call toll-free 1 (877) 285-4545
=====================================================
My standard "Your Mileage May Vary" Caveat:
NFTB does not assume responsibility for your use of
information given. Tips are tested on a
machine with
Windows 98 and Office 2000 Professional installed.
As I am firmly convinced that all systems are unique little
creatures in and of themselves, any given tip or suggestion
might just not be available to you. Why?
Murphy Rules!
All advice should be weighed against your own abilities
and circumstances and applied accordingly.
It is up
to you, the reader, to determine if advice is safe and
suitable for your current situation.
Any product or brand names mentioned in this ezine
and associated website are trademarks or registered
trademarks of their respective owners.
NOISES FROM THE BASEMENT is a BTB Management Services
publication e-published every Wednesday and always
delivered directly to your e-porch, rain or shine!
Noises From The Basement
ISSN: 1531-5258 - Library Of Congress,
Copyright (c) 2001, Dave Gretz
All Rights Reserved.
****************************************************
www.ForOhiosBest.com
Full Service Web Site Design/Management/Promotion
Have a dotcom dream? Visit today to make it real!
__________________________________________________________
Site contents and all original material
copyright © 2001
BTB Management Services
toll-free: 1-877-285-4545