Really having trouble with objects.  Can't seem to navigate through a
selected range and then edit a date cell.  Thanks to others I have made
progress.  I can change one selected cell, but not a selection of cells.

Dear people,
I used the code since last year. But today now I really had a problem with
it. Please help me.
The code begin with:-

I'm using excel 2000 on Windows 2000 professional
Sample Spreadsheet named QuotedPart
_____________________________________________________
                                   Column

I have my Excel spreadsheet importing the data I need from my database,
but it requires non-Windows authentication.  I would like to know if there's
a way to create a "hidden" or external connection that has the userid
and password already in it so that when the user needs to ...

I'm sure the answer to this must be posted somewhere on this group but
I can't find it!
I have a set of data containing exam results from pupils.  The pupils'
names are given in column A,

I have a textbox which if the user does not make a change, saves the empty
textbox back to the worksheet.  What I am finding is even though the cell is
emply my code is picking it up as having something in it.  Does this process
add some kind of invisible character?

Is there an array pointer available in VBA?  I use it in other languages to
easily and quickly sort and search arrays.  My problem is I have two very
large spreadsheets and want to get data from one to the other based on a link
and the arraypointer would make this easier in my ...

Is there a way to instead of deleting the extra rows after the first
duplicate is found, to delete all but the last one of the duplicates?
As in, keep the last duplicate, discard the ones above it.  I know the
reverse can be done... Thanks for any direction!

I have tried several approaches but cant quite get what I am looking
for (previous recommendation resulted in code errors).
I have a workbook that is accesible as 'read only' unless someone
knows the password to gain control access. The thing is, I have

I would like to write a macro to save a file to a different folder location,
same filename, and then delete the file from the original location.  I tried
record macro and went to file-open to do the delete file part (right click on
file and delete), but the file didn't delete.  ...

I run an SQL integration package (DTS) that copies a template over a
spreadsheet to fill various ranges with data. Somehow the spreadsheet is
either open or corrupted and I can't either copy over, open or delete it. Is
there a backdoor trick to getting rid of an open/corrupted ...

I would like to set my form as I set a worksheet however I get a type
mismatch.
My book does not list a form as an object and I do not see 'Form' as an
option on the Dim statement.  I'm not using it so much as in a with statment

I am trying to take information that is on a worksheet who's name
stays constant that gets updated daily from another one and then paste
that information into another worksheet.  The layout would be
constantworksheet(data):

The following code creates the file for the workbook. I need to be able to
disable a form button if the person has a file open, lets say #4 and file #5
exists I do not want them to be able to create another workbook from file #4
they would have to open #5.

I have a string (thanks to JW) to auto alphabetize column A in my
worksheet.... however...it's including the title cell.  How can I adjust that
so it only alphabetizes from cell A2 through the rest of the worksheet.......
I SOOOOO need to take computer classes!!!!