I know Ron put some lovely code up on his site on how to zip an fil
using winzip as I searched on the forum but every answer pointed t
ROns site.. could somebody please be kind and post the code or th
sample workbooks here as my IT department insists that Rons site is BA

I need help setting up the following Column Width macro in Excel:
1. The "width" for Columns A, B, C, D should total 40.
2. Columns B, C, D have been "autofit" based on the data entered.
3. How would I set Column A "width" for all columns to still equal 40.

I need to use VBA code to update a table in a SQL Server database. I have
not done anything like this before. Can someone point me in the right
direction?
Thanks,

I am testing some SelectionChange event code. Each time it doesn't like
like what I test it with it refuses to trigger the event again. My only
solution to get it working again is to save the file, close the
workbook, and close Excel.

I have Dim a variable as a range.
I am trying to write an IF statement based on that range being empty,
and having no success.
Any help is appreciated

Heres my goal.  I have a directory full of .xls files, around 500 or
so.  I would like to
merge all these files (all located in c:\data) into one master file.
Doing

I would like to create a calendar that I choose the month, data that auto
fills for one month begining with the first work day, and I choose the
holidays to skip when data is auto filling.
This is what I would like to do:

I have a user that has ~300 word files.  Each of these word files have
embedded excel objects in them.
The powers that be want a program written that will open these word
files and edit hyperlinks that are inserted into the excel objects.  Is

When trying to transfer data from a Database on one drive to an Exce
Spreadsheet on a different drive in our system, the transfer i
creating a new tab in the destination spreadsheet.  We want th
information to overwrite the info on the old worksheet every time th

I only want my code to execute if the value of the selected cell does
not equal any of the values in a defined list of values.  Instead of
constructing an If . . . Then statement that repeats "selection.value
<> value1 AND selection.value <> value2 . . ." I'm hoping someone might

I'm new to Macros and this forum, so any help is greatly appreciated.

I'm trying to run a macro on my machine (Windows 2000 and Office 2003
and I keep getting an error on one method.  Now I tried to run the sam

Hi, Please help...
I am trying to workout the number of working days between to dates.
I have a column of paperworkrecieveddate (28-Jun-06) and second column with
VisitDate(24-Jun-06)

Help with pop up window/2nd sheet within workbook
I would like for a rate calculator I've put together in Sheet 2 to pop up
when button clicked Sheet 1.   After the dimensions are keyed in, I would
like the calculated figure to populate a cell with-in Sheet 1 when button to

Can anyone tell me how to select all cells in a row up to (not
including) the first blank cell in the row?
Thanks alot!

Hey, I was wondering if you Excel Gurus could give me a hand.  My mother
is making a list (in Excel) of all of the books in the church library.
The church would like to see each book sorted by titles on a tab for
each letter of the alphabet.  So, she has created a workbook with 26