I have setup Excel to populate a word document template which is my primary
document. Depending on a certain field on the spreadsheet, it would then
trigger another template word document. When the process is completed, I have
two documents on display. I would like to have the ...

I have created an Excel file with Macros. If I try to oopen tha
particular file it takes atleast 60 seconds to open. i.e 60 second
delay. If try to open other excel files delay is not there. Kindl
message me the solution to this problem if any one of u know

How could I performe a comparison of the content of 2 workbooks. To locate
which new records that are added or deleted.

I have a report I have written in Excel using multiple sheets.
some sheets have a single page, some have multiple pages.
I want to put page numbers in the footer as I also have to put time
date, filename in the footer due to company layout rules.

När jag ska starta Exel kommer det upp. Systemets resursnivå är låg sedan
låser sig datorn. Kan starta word och access.
Datorn har ca 70 % ledigt systemresurer.
Kan någon hjälpa mig tacksam för svar.

I want to tally up the results of a survey by putting a check mark or a "1" for
every yes response in a Cell.   But how do I take the sum of the bits? (ie. as if the end result were a binary number, "1111111111111" ?)
I suppose I could use a push button!

This message occur-" To prevent possible loss of data, Microsoft Excel
cannot shift nonblank cells off the worksheet. Try to delete or clear the
cells to the right and below your data. Then select cell A1,and save yur
workbook to reset the last cell used or, yo can move the data to ...

how to transform string ( include only numbers )  to numbe
--
zhuta
-----------------------------------------------------------------------

Right now, each patient is identified with their medical record number.
We could go and manually input an 001 next to any record with the
Medical Record# XXXXXXXXX and 002 for any Medical Record# YYYYYYYYY.
But that would take quite a while.  Do you know of another method that

I need to make a macro that when I run it, it always starts at the cell from
where the cursor is.  From that starting position, it moves 2 cells to the
left and does something.
I can't seem to do that.  When I look at the code, it seems to have

Is it possible to select specific cells and then have the Replace feature
only apply to those cells, particularly if I use the Replace-All button?

I want to have a Function or Subprocedure that can create an array with
52 specific values in it. I then want to call this Function or
Subprocedure from a main Subprocedure and be able to access the
contents of the array. Everything can be of type variant for the

I have a sheet that has rows and columns that are grouped.
I need to protect rollup portion of the grouped rows.
However, when I do that and protect the sheet, I can no longer group
and ungroup.

Is this possible?
I have two cells which are filled in by choosing from drop-down lists.  A1
is January, February etc and B1 is 2006, 2007 etc.
Once the user chooses the month & year I would like Excel to automatically

I have an annual report spreadsheet comprised of  15 rows (1 - 15) and 5
columns (A - E).  In columns "B" and "D" I add numbers from the current
year, leaving future year cells blank.  I highlight in yellow the blank
future cells in columns "B" and "D" by a conditional format ...