Is there a way to code for sending a selection of cells as a body of an
e-mail and then attach a file to said e-mail? Also I'm looking for help on
being able to automate changing of the "From" field in this e-mail to reflect
an alias. Thanks in advance.

I am new at running macro's and have written one and ran it in the same excel
instance but when I close excel and open a new workbook and try to run the
macro it is not there to run.

I am currently working on a macro that performs a few tasks.  The end result
is emailing the document out to another user.
What I want part of the macro to do is the following:
1.  Message box:  Did you save as current version?

I am working a project where I want to limit the user changes via either a
form or a macro. In other words I do not want the user to be able to alter a
cell's content directly.
I know I could hide the worksheet or columns but the user has to be able to

I have this macro/code placed in "ThisWorkbook" in the VBAPProject of a 2003
excel file.  The problem is it is not clearing the scroll area when the
reference field is set to "No"
Private Sub Workbook_Open()

I am aware of the application.version function and I can also use the
conditional compile using the #if #else #endif statements.
What I need to do though is determine the version at run time and then run
different code depending. The conditional code needs a const which I cant

The code below runs fine until it gets to the last pastespecial, the I get
the message "PasteSpecial of Range object failed". Any ideas?
Sub AllocbyCty()
Dim wbCty As Workbook

I am writing a version control macro and need it to identify whether
the file name entered by the user is valid as a file name.  Can
anybody either:
a) provide some code that identifies whether a given text string is

I am working in a workbook that has 5 sheets.  Each sheet has different data
and calculations based on information in the first sheet.
What I want to do is
1. Find the last row on the first worksheet that has data in it.  Copy that

I have Microsoft Excel 2003  and Office2003 Service Pack 3. I installed the
XML Toolkit for Excel, but it fails to run. Gives the error "The excel xml
toolbox can only run in a version of Microsoft excel that has xml support"
What could be the reason ?

To all,
I have a question as follows:
I’m trying get a macro to correlate data that appears on 2 separate
sheets and transfer the relevant data over.

In Excel 2007, I turned on the macro recorder and printed a sheet to MODI to
get a tif of my worksheet. When I looked at the recorded code I got:
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"
Which is fine as long as it works, but I found it strange to get an old XL4

I found this code on a website and that will copy a range as a picture.  I
also need it too save it as a picture on our network.  Can you help?
Worksheets("Sheet1").Range("A3:D12").CopyPicture _
   Appearance:=xlScreen, Format:=xlBitmap

I have a spreadsheet that the user inputs 4 dates (into 4 different cells)
where those dates are used in an SQL query against a database. Is there a way
to perform edit checks once the dates are input so as not to have the SQL
query execute until the dates are known to be valid ?

I had the need to use the ISBLANK() worksheet function in some VBA code, so
I went into the editor, typed "WorksheetFunction.Is" and the first thing
that came up in the Intellisense list was IsError. ??? So I scrolled up and
found I had passed items starting with "is," meaing ...