Replies

2. Bones in the body
4. Legs on a caterpillar

Have you thought about looping through each letter in the cell and finding the ASCII character code for the letter? Look for the ASC function in VBA help.

Upper case letters will (should) have values between 65 and 90, while the lowercase letters will be in the range of 97-122.

8. 16842 – Gosh, I love Excel!

1. My father
6. TON
7a. 0
7b. 8
7c. 24
7d. hidden
7e. 8

Can you ALT-TAB or SHIFT-ALT-TAB to it?

Here’s what I understand: You wish to add the case numbers and MonthDate to your file name.

Assuming the case numbers are located in the range A1:A12, I’d use this code to concatenate the case numbers:

Sub Test()

    Dim sMyString As String
    Dim i
    
    sMyString = Cells(1, 1).Value
    For i = 2 To 12
        sMyString = sMyString & ", " & Cells(i, 1).Value
    Next i
    
End Sub

Now sMyString contains all of the case numbers separated by a comma and a space. For you, it is just a matter of appending MonthDate via something like:

sMyString = sMyString & ", " & YourMonthDateVariable

HTH

I was able to do what I think you’re asking by using data validation.

I created a list of possible values for the cell, and set up data validation for another cell. I unchecked the “Show error alert…” box from the Error Alert tab, and likewise unchecked “Show input message…” from the Input Message tab. From there, I just did the normal data validation stuff: Allowed a list, set the source, checked the appropriate check boxes.

If I decide not to use the list, I’ll just type my own entry in the cell – ignoring the list completely.

Does the attached illustrate well enough, or did I completely miss the question?

Have you considered using a Pivot Table? It would allow you to view mins, maxes, counts and averages – among other things.

Often when surfing the internet for new desktop wallpaper, I find more than one that I like. I take advantage of Windows’ basic wallpaper – the bitmap, and of the new Active Desktop route with jpgs. When I find a photo I like (usually a JPG):
I save it to my HD
open in paint
save as BMP
set as wallpaper (centered).

THEN I find another JPG file I like, save to HD
Rt-click desktop > Properties
Browse to newly-downloaded Jpeg file
Set as wallpaper, centered.

When I get tired of seeing the JPG, I just right click the desktop,
Click Active Desktop,
Toggle View As Web Page to alternate between photos.

Thought you’d be interested.

Thanks for the clarification!

I believe that is a CLSID. Read more: http://msdn.microsoft.com/library/default…./whatsclsid.asp[/url]

I don’t have exactly what you’re looking for, but in my version of Excel (97), I’d just right-click a toolbar & click customize.
Click Insert on the menu bar, click Name… and Ctrl-drag the Paste… item to just above the formula bar. In my setup, I have it sitting just to the left of the Bold icon.

Now your names are only 2 clicks away.

Edited: Since a picture is worth a thousand words….

Are they all a part of the same workgroup? Bart might be set to use a different workgroup. To find out: In Windows 98, right click Network Neighborhood, click Properties, then click the Identification tab. The workgroup name should be the same on all computers.

This doesn’t seem impossible, it just ins’t elegant.

For I = 1 to 15
   DO YOUR STUFF
   IF I = 3 then
      I = 6
   END IF
NEXT I

Does the printer software include some kind of print manager? I have a Lexmark at home that includes a little control applet (tells how much ink is left, general printer-PC communications, etc). If you have such a program, check it for something like bi-directional communications. If you find it, disable it. My thought is that the printer can probably ‘hear’ your computer print requests, but since it can’t talk back to the computer, your computer believes that it is offline.
Also check around in the printer properties for a bi-directional option.

Good luck!