Hi, I have created a template in excel. Now a user would work on
that.. and do some work...BUT while saving, I dont want to all
overwrting the template file i.e the template woudl be named as say,
MyTemplate.xls, so as long user is trying to issue a save and is

As a follow on to my previous question (Thanks again for the help)......I
want to copy and paste data from MS Excel into MS Word. Is this even possible
with VBA?
For example:

I have a command button that I want to enable and disable using code. I have
tried this:
ActiveSheet.Shapes("PrintJour").Enabled = True
Without any luck. Can anyone guide me?

I'm using both 2003 and 2007 Outlook and Windows XP Pro. I have a particular
worksheet, in Excel, named DataSheet and I update this document daily to
retrieve new information. It is organized in a database format and a friend
is writing some code to select specific columns of data ...

What would the code look like if I wanted to print WorkSheet June if CheckBox
6 = true. I need to print without actually making the sheet active.

How can I copy text from another application (Microsoft Word) and then paste
it into a UserForm Textbox?
Thanks in Advance,
Ryan

I have a userform that uses a button (cbChangeButton) to look up an existing
values (textbox: tbExistingProjectNumber)in multiple (9)worksheets and then
changes it to a new value (textbox: tbChangeProjectNumberTo) on those
worksheets.  My problem is that if the ...

I try to wright a command which autofills a range adjacent to information in
the cells left. So if Range A1:A300 contains data and I have a formule in cel
B1 I normally double click the fill-handle to copy (or autofill) the formula
down to cel B300 (which is adjacent to cel A300) ...

I have a spreadsheet where columns BE and BF look something like this:
        BE                                   BF
1    Country                        Continent
2    From France

I have a workbook that is protected, which forces users to open it in Read
Only if they do not have the password.  When the user clicks on Save a
Message Box pops up saying "Workbook is Read Only.  To Save a copy, Click OK,
then give the workbook a new name in the Save As Dialog ...

I'm investigating why a DDEInitiate command locks up Excel.
Specifically, I am addressing a GoldMine database though DDE as
follows:
dim ret

If I call an Excel function (e.g. Linest) that returns an array (in
the case of Linest, the slope and the intercept), how can I access one
particular element of the array that is returned?
If I select two cells, type =Linest(a1:a10,b1:b10) in one and then hit

Good Morning Everyone . . .
I have an interesting application.
For easy explanation . . . My workbook consists of two sheets  (Sheet1 &
Sheet2)

How do I find out if a variable is even?
Thanks

I have posted this before and I am still having problems.  I have researched
myself and cannot come up with anything.
I have a macro that will create 26 commandbuttons on the active sheet.  I
get one button created with caption "CommandButton4".  I also get Run-time