I have VBA code which will take a copy of the activesheet, save it and create
an Outlook Drafts folder item with the saved workbook attached.    My problem
is the original workbook is interactive and has vba code on the
"before_doubleclick" event of the sheet.   I do not want the ...

I am trying to set up a macro to import a specific text file based on the
information the user puts into specific cells. They imput the company,
division and date and this generates a path & filename in a cell in the
spreadsheet. How can I get that path & filename into the macro? ...

I'm using a combo box (from the Control Toolbox) to allow data-entry
into a range of cells.
There's just one combo, which is shifted about to appear on the current
cell, using code adapted from a solution at contextures.com:

Does anyone have (or know where I can locate) the list of VBA data types and
their descriptions? Really what I need is just this:
Data Type Name
Possible Values (and decimal accuracy)

I've not got used to programming excel. I'm trying to select the bottom
right cell and then select the current region in order to do a sort of the
first three columns without headers.
I'm obviously getting it wrong!!!

Is there a quick (and easy) way of determing the minimum and maximum values
of data points on a chart?  I have multiple lines on a chart and want to be
able to find the min value and the max value.
Thanks.

I have some experience with making macros in excel, however never don
it with word. So some guidance would be nice.
What I’m trying to do is... See attached file (picture).
The picture is an example of a reference to a journal. My documen

The following statement causes an error message, but it appears (to me) to be
ok.
The statement is Range("A1").Value = 5, and the error message is "A value
used in the formula is of the wrong data type"

I want to use a macro to copy data from a text box to a cell.
To copy the contents of TextBox10 on sheet "Customer Info" to cell B43 on
sheet "Answers" I have tried recording a macro whilst highlighting the text
and then manually copying it, but that doesn't work. I have also ...

I have a command button on my worksheet. I can't
delete it from the woorksheet, and I don't know why.
Have anyone an idea who to delete the button ?

I took a file and i added some code to eliminate the "do you want to save
...before closing" message box. A pretty minor change.
Well adding this code made the file size go from 104K to 79K - it some how
choped off 1/5 of the file size. Does anyone know why this would happen?

Anybody, with any advice / suggestions on what is the best methods
/practices on parsing strings. I have a really huge string, that
provides a major performance Bottleneck while reading through. Right
now I split it by a delimiter, fill it into a Variant and run through

I hope someone here can help.  I have next-to-zero experience with
Excel macros.
I have a large spreadsheet that was used to track workshop attendance
for several people throughout 2005.  It has names in Column A and

I export data from other prog. To excel and converting to text to column. I
have fields like  Date, Ref No., Item, Opening Bal, Pending Bal. In my
Opening Bal, Pending Bal. column  some amount comes in – (-ve) and some comes
in + (+ve) I want to convert –ve amount into +ve and ...

Its clear that I am still a newbie...
In VBA, how do I assign a value to a cell with out first selecting the cell?
In pseudo code I would describe it as "Assign the value 5 to the cell in
location x".