When I do the below I get the message Provider cannot be found?  What
am I not seeing here?  I am trying to remove the use of the report
downloader Evergreen in certain applications.
Public Sub Open_AS400()

I have been trying to get all the cells in a row to change from one
background colour to another dependent upon the the last cell in the row
containing the word "Yes".
So for example, all cells in all rows are green. But when the last cell in

Is there a way from moving the insert Row/Column function from the tool
bar so that people can't insert Row/Column's into your spreadsheet?
Greg

Is there any way to specifically set shortcut keys to buttons
(programmatically or by tweaking the registry even)?  I would like to
set Excel's "Format Painter"
and "Center" buttons to the same key combos as Word's (Ctrl + Shift +

I have seen the making cells mandatory to fill in comment and it worked, but
I need the same only if a previous cell has been filled. I have various
columns not all of them will be filled but if a cell is filled the complete
row will have to be filled, how do I do this, if one ...

I am very new to Excel and VBA. We are a small company with a large server
with documents everywhere that are hard to find.  I have been tasked with
updating a workbook that was created in 1999 which provides a "house" for
various hyperlinks to the server to get documents.  In ...

I need to manage data that I pull in from an SQL data base where the collumn
that is supposed to hold dates is a number field.  I would like to be able to
write a macro to do a loop that goes down the colloumn and says if cell < 0
then (cursor movement**end (to get cursor to the ...

I have a routine that opens all files linked to a specifc worbook, but if
one of the files is already open with changes done I get a message.
How can I check before trying to open? I have no idea what to do.
Thanks

Some cells in Col A contain these amounts:
$.58
$1,267,98
$1.20

Hi Everybody!!!!
I need some help with a solution for running a macro that I recorded.
Just so you know recording macros is about the limit of my VBA
knowledge.

I have three buttons on a form I want one button (cmdFind) to activate
when the enter key is pressed.  I have two text boxes that can have
data entered into them.
The three buttons: cmdFind, cmdClear and cmdClose.

Hello, I am looking for a simple msgbox which will pop up if there i
nothing in a certain cell and ask the user if he wants to continue th
macro. If he clicks Yes then code continues otherwise it stops.
After looking in the VB help it only shows the following code but i

I am exporting an Access table to Excel. My problem is that Access exports
its column headings into the Excel spreadsheet, which is resulting in a row
(b6) being added that I do not want. I am an experienced Access programmer,
but I know nothing about Excel. Can I delete (b6) ...

All,
I have the following to select a range of cells in a column from A2 thru the
last row in the sheet.
    Range("A2:A" &

I have a spreadsheet that lives forever, constantly being saved and
resaved either with the same name or a new name.  That spreadsheet
contains several cells whose values change regularly, during the
dynamic life of the spreadsheet.  Consider for instance cell C5, which