I'm stumped on the fastest/cleanest way to do the following:
After copying in an entire worksheet from a source workbook into my
open workbook in vba, I would like to name a range of cells on that
worksheet just copied in.

I have cells in an excel spreadsheet with contents (employee short-form
initials)  like [tv pm dsab sa] - this is the content of a single cell.
When such cells are scanned for contents equal to, say, 'ds' or 'sa' I
don't want to flag on 'dsab' (which contains both 'ds' and 'sa'), ...

Is there any way to set (and unset) the File Type name through excel VBA?
I want to list all DWG files in a directory and make hyperlinks to them, but
the problem is that different operating systems will use different file type
names e.g. some may be "Autocad 14 Drawing" where ...

After code has run in workbook, workbook is being sent to printer countless
times even though in code it is told to print out only once. any ideas?

Is it possible to autofill formulas on a worksheet other than the
active sheet?
For example, this works fine if Sheet1 is active, but returns an error
if not:

SUBJECT:  Error handler if copy area different from paste area.
I am writing a macro that pastes cells from the clipboard to a spreadsheet.
But I want the macro to run ONLY if the number of columns already on the
clipboard is EXACTLY the same as a number that I plan to specify in ...

   I am using a spinner for number input.
Can anyone tell me how I can make the spinner increment decimal values
I.E.  1.15,     60.04 etc
Thank you for all your help in advance

I have numerous references from 1 sheet(report) to another sheet(photos).
Currently i use a simple but time consuming:
=IF(Report!C28="","",Report!C28) method.
I would like to code this as somehting like:

The below code inserts a picture into the active cell,
But i want ot name the picture a value in the cell above and 1 column to the
right of the cell where the picture is added.
This way i can then use another code to delete it by value.

I wrote code in Excel 2000, and it does not work in Excel 2003 (tested
this on two different computers).   All I'm doing is copying range
values into an array and pasting the values at the end of another
range.  When I try to paste the values, Excel 2003 raises a 1004 Run

I have an interesting problem, I am writing a function where there are
a few hard coded times for the function to use.  I am however having
problems applying a variable value to 1:00 AM.  Here is my code for the
variable application

I am creating and using Excel.Style objects and I'm running into problems
with accessing the Borders of an Excel.Style object.
1.  The enumerator to access the Top Border "Excel.xlBorderTop" returns the
Left Border object.  It seems that the enumerators when access the Borders

I have created a frontpage for my excel database which displays records via
a combobox and Index values. I have included a photograph in my worksheet
which displays a photograph of the selected combobox item and I also want to
show the relevant item report below this.

~~~~~~~~~~~
Sub DeleteEvent()
   If Not
Application.Intersect(Range("A28,A32,A36,A40,A44,A48,A52,A56,A60,A64,A68,A72,A76,A80,A84,A88,A92,A96,A90"),

I am 99% finished a little application that will automate a bunch of web
procedures at work for me. So I can basically start it up on my laptop,
and let the application do it's work. The only problem I am having is
that a combobox in the web application has an onchange() event ...