no............................

But you can open it into an invisible instance of Excel, or you can hide to
Window also:



Application.Visible = False



Or



Window.Hide = True

Or you can import the data in the Excel-file without opening  it:

www.erlandsendata.no/.../index.php

Is there a macro I can copy to accomplish the following please?

Suppose this is in column A:
1> James Anderson
2> Jan 12, 1873
3> Aug 10, 1944
4> “Devoted Father”
5> William Brown
6> Feb 17, 1900
7> Jul 22, 1982
And so on…….

Ok, I highlight the first four options. Is there an easy macro to change
that to:
A
B C
D
1 James Anderson Jan 12, 1873 Aug 10, 1944
“Devoted Father”

I.e., whatever I highlight is spread across ONE row? Right now, I tried a
macro, but it pastes in the wrong cell. Automating this would save about
nine days work. After I highlight the next three rows, it gets spread out
like this:
A
B C
D
5 William Brown Feb 17,1900
Jul 22, 1982
???

I can do a sort later and remove the empty rows. Possible?

This should be possible using "PasteSpecial transpose"

I do not have the time to test it right now.

Microsoft provides a excel  ODBC driver so you can access a workbook  via
VBA ADO code without opening  it.

See the following KB article detailing the process:

http://support.microsoft.com/kb/257819