Hi all I am wondering how to save a file automaitcally. How do I get excel
to check if there is a folder called "Darts" and if it does not already have
one then it is to create one on the C drive?
Thanks

Hi guys/gals,
I have a worksheet with 3 columns on it:
Version, Type, Release Date
I need to be able to analyse the date and when a version's Release Date

I have an excel spreadsheet that contains data in a number of columns
(some contain data and some do not). I would like to have a seperate
spreadsheet check the range (E3:IV3), if data is present in this row, I
would like the seperate spreadsheet to write the cell values of the

I am building an Excel spreadsheet that will be used to produce Invoices and
Delivery Notes via a web based IntraNet site.
Since the usual toolbars and menus are not available in the Internet
Explorer embedded Excel; I have been creating macros to allow the users to

I have one worksheet with several hundred entries in column "A" and over one
thousand items in column "C".  I need a procedure which will determine if
each item in the shorter list is also found in the longer list and then paste
the duplicate item in the proper cell in column "B" ...

I'm constantly creating workbooks (thru Essbasse Cascade function) that
have 50 or more sheets.
I'd like a quick macro to defined a named range on each sheet, using
the tab name as the range name.

i try to use match to search some value. When i run it, excel displays an
error 13 : type mismatch.
Here is my code:
Set rngCrit1 = ThisWorkbook.Sheets("Backup").Range("G1:G65536")

I'm trying to create a procedure to show the detail in a pivot table.  Using
the macro recorder, I get:
Range("B7").Select
Selection.ShowDetail = True

I am creating a user form to display data that is hard to read in a
spreadsheet. The sheet will have about 20 cells of data in each row, so this
may be very simple but what process can I use to grab the current row, or
even start at row 2 and paste cells into text boxes.

Can anyone tell me if there's a limit to the size of data that you can
insert into an excel cell using VB6 automation? I'm transferring data into a
worksheet but whenever the data is more than about 1000 bytes I get an
automation error 1004 "Application-defined or object-defined ...

I have 200 workbooks that are 80% the same. One worksheet in each is an index
that has checkboxes for printing. I need to verify the presence of the sheet
to print before I issue the print command. Any sugguestions?

I am creating a spreadsheet using matrices that allows you to add
pre-defined transformations to a triangle. I have a problem with
circular references because my macros have to copy and paste a lot of
calculations. for example the 'current coordinates of image' is a

Hi -
 I needed a tool to measure how long different versions of
some macros I'm writing take to execute, AND, I wanted the
precision in at least tenths of a second; (partly as a learning

Earlier I used XL2000, and I had a macro opening a .CSV file:
Workbooks.Open Filename:="C:\Myfolder\2005_12.csv"
worked correctly, it placed the semicolon-separated data into different
columns (I use a Hungarian version where list separator is semicolon).

I have a macro that produces a message box and I have used vbYesNo so the
user can answer a question. However instead of a yes or no answer I want the
user to answer with 'left' or 'right'.
Is it possible to change the text of these buttons?