As the title suggests i am trying to save an XML file that I have
generated in VBA (in excel) using the DOMDocument object to a location
on sharepoint but the DOMDocument.Save method does not work. Does
anybody have any idea how this might be done?

When I click on the finished button on my dialog box I would like the focus
to move  left by 1 cell. So if cell E4 is active I want cell D4 to become
active.

I'm not having any luck finding examples on creating charts & graphs
via code online.  Does anyone know of any out there they can point me
to?

I am trying to extract and use the column letter instead of the number.  My
code looks something like this:
Dim StrLastColumn as String
strLastColumn = ActiveCell.Column

Hello - Any chance someone has code that would allow the following.
In sheet1 I have a list of names that are being added as active
members. When the members leave or terminate, we enter the word
"terminated" in a column titled "Status."

I am using Excel 2003 to programmatically create a workbook.
A bunch of cells contain the XIRR function..
MSFT KB article 291058 describes a bug in using XIRR.
3 solutions are offered. The 3rd solution does not work, at least for me.

I have an excel workbook with two worksheets,
I need to cut any row that has "Complete" in a specific cell from
worksheet 1.
Then paste it onto worksheet 2 on the next available row.

I'm developing a basic Life Cycle Cost Analysis Spreadsheet and need some
assistance adding the costs of particular activity into a specified year.
Example:
           This column checks

I have a report that returns multiple rows per ID number.  The columns always
stay the same.  The number of rows per ID number is variable.  I would like
to group the info per ID number into one cell.  If the number of rows was
constant I could concatenate easily.  But each ID ...

Does any one have the answer to how I can get the values ( e.g. namedRange )
for a range validation dropdown from a worksheet other that the sheet that
contains the Range.Validation.
Thanks

I have created a formula that has two problems:
1. It only works it all the cells have a numerical value in them.
2. The formula is very long and needs to be simplified.
Is there anyone that can help me?

I have a Macro (VB script) that will help me protect all worksheets within a
workbook.  It prompts for the password to protect all sheets when the Macro
is run.
Can someone help me revise the code below where only 2 worksheets are

Column N is value - Column A is the result
here is the code:
   Range("A2").Select
   ActiveCell.FormulaR1C1 = _

Sub TAKEDATA()
With Sheets("F")
FULRNG = .Range("A" & Rows.Count).End(xlUp).Row
Range("A2:A" & FULRNG).Copy SHEET("RESULT").RANGE("B11").PasteSpecial

Is it possible to write excel data to the *middle* of a text file? The
only writing/exporting I can find seems to either append the data to
the end, or overwrite the text file starting at the beginning (erasing
the existing text).