I have two workbooks, let's call them Parent & Child.  Parent is the master
template that contains a cross-ref table on sheet tab labeled "Xref" that
shows a long description in column A, and the corresponding sheet tab name in
column B.  It also then contains each of the ...

Using an external program with a language very similar to VB I have a script
that uses CreateObject to create a new workbook and fill with data. All well
and good. I have one column that is filled mostly with numbers where I need
to see any leading zeros.

I am running an macro on a worksheet that is has a horizontally split screen
that is frozen.  In addition, I have set the ScrollArea to limit the range of
scrolling on the lower pane.  At the end of my macro, I select a cell that is
in a row that I would like to be visible on the ...

For historical and educational reasons, I want to install Excel 95 on
a brand new HP PC, which comes shipped wth Vista.
Can I install Windows XP somewhere on it (which does support Excel 95
(ie Version 7) )  ?  If ncessary, partition it and install Windows XP

I am in USA.  The macro is being used in South Africa.  Dates in SA are
written ddmmyy.  12/02/08 is Feb. 12, 08 and not Dec 2, 08.  I am having a
problem with the way Excel is formating the date.
This is the code I am using:

I'm getting HRESULT: 0x800A03EC
On this statement:  cfDataBar =
osheet.Range(RangeText).FormatConditions.AddDatabar
with these values in RangeText:

Is there any fast way to check if a specific worksheet range is
referred to in my VBA code? (Find ???)
I suppose it's a common problem when you move data from unnamed cells
in a worksheet to another place on the same worksheet .  It may

I have a worksheet 'SBL' with some data.
Headers in first row i.e. from A1 to K1.
In columnJ sarting from J2, I have some user names.
I have a defined name TUsers for all the user names in worksheet

I created an add in with some chemistry formulas, I would like to sale it,
my problems is that I have no idea how to run the installation wizard, I
would like my costumer to double click on the installation icon and then my
add-in is uncompressed, and copied to the add in default ...

I am sorting data and it is not sorting completely. I ploped the sort into my
code and forgot that my range is dynamic.  The second range value is not the
same because the size of the output changes based on the data that I process
varies.

I've been scratching my head how to solve this problem.
Say I have a MacroA which is something like this:
Sub MacroA()
   Application.ScreenUpdating = False

I have excel 2002 running in my server.
I tried to format a sheet with macro.
The
sheet.range.borderaround xlcontinuous is working

I have 2 sheets in a workbook.   Sheet1 contains 25 rows of data.   Sheet2
contains a column of 5 cells that are the basis for a large calculation
within that sheet.  Today I'm manually loading up the 5 cells and then
running a macro to print out the results.

Set objword = New Word.Application
  Set objDoc = objword.Documents.Open(DocumentPath +
"\ECB_Document.doc")
 objword.Visible = True

I have the following list.
   Date              List
02-mar-2008 08459087671
02-mar-2008 08459087673