I am rather new to programming in Excel so I am hoping someone will help me
out here. I want to execute certain subroutines depending on which cell the
user has just entered data into. Basically I want to check the user's input
for validity. From what little I know of Excel ...

Please tell me if this is possible... A cell receives an ID number
entered by the user. Upon update of the cell, I'd like to query a view
in a SQL server database. If the entered ID exists, a value (say "X")
is placed in another cell, else, a different value (say "Y") is placed

I made a program with vb 6.0.
By the way, the program use the only EVALUATE function in Excel.
Thus, any computer of uninstalled Excel application can not use the
program.

What am I doing wrong?  I get a run time error 91 when I get to
"        .CommandText = SqlSet".
please help.
Private Sub UpdateAccess1_Click()

Hello, I have created a lovely macro that builds reports and then
emails them out to people, and i am very proud of it. The reports that
go out are perfect except in one respect...
If you try to print or print preview, they crash excel with an error

If Selection.SpecialCells(xlConstants) Is Nothing Then
       Exit Sub
       Else
   Selection.SpecialCells(xlConstants).ClearContents

I have a workbook which copies information into a woksheet before it is
printed. The information at the moment has to be limited to avoid, text
becoming to small (this not the issues, am aware as I set the test size up).
Cell width autosize is not a problem, but resizing the cell ...

I have looked in past posts but been unable to find something to speed up
this code.
The worksheet has a number of codes doing different things: entering date in
P when initials are put in O; putting everything in uppercase, for example.

hi..
i got this to open a workbook. in it i tell it where to look for the
workbook. i would however like it to go and look on the entire system for
it...(including removeble drives etc..) i use it on about 14 branches and the

I have two questions:
1.  How do I identify a fill color for a cell so that I can match the text
to the color to hide it?  Is there a beter way to hide the text so that it is
not visble?

I want to program excel to check whether fluid flow is laminar, transitional,
or turbulent and use corresponding equations to solve for friction.
Laminar (re<2300) - friction = Re/64
Transitional (2300<re<4000) - friction use Churcill equation

Hello all, i have a workbook that is protected and therefore do not want to
share. What i want to know is, is it possible in addition or to replace the
standard message of " this workbook is locked for editing, open as read only
" ??

Excel XP & Win XP
In this snippet of code I am trying to "Kill" 3 files.  I get a "Subscript
out of range" error on the "Kill" command with the first file.  So I changed
the order of the files in the "For Each.." line and again I get that error

I need a template that allows employees to enter a start time, end time, and
choose a work project for that time from a dropdown (editable) list.   I
would like the template to generate a report of  total hours worked for each
project over a two week, month, etc. period.

I receive text file "happy" downloads daily via an ftp.  I want to be able to
move the files that are old to another folder "Happy old".