Retrieving cell formatting from closed workbook

[paulharvey]

*Hey guys, I've studied C++ for a couple of years, but I am somewhat ne
to Excel VBA -- so I was wondering if you could help me out. Here's th
problem:

Currently, I have a GetValue function which pulls a cell's value from
closed workbook and an OutputData function which stores the value in th
corresponding cell of the active sheet, however the cell's formatting i
lost in the process. Is it possible to carry any of the cell'
formatting across and, if so, could someone advise me on how to d
this? In particular, what objects, classes, or functions might
need? Also, would a GetFormat function call from GetValue slow th
processing speed down much more than just passing more parameters t
the GetValue function?

Thanks. *

Private Function GetValue(path, file, sheet, ref)

Dim arg As String

arg = "'" & path & "[" & file & "]" & sheet & "'!"
Range(ref).Range("A1").address(, , xlR1C1)

GetValue = ExecuteExcel4Macro(arg)

End Function

Private Function OutputData(File, InputRow, OutputRow, FileDone)

p = PathName(File)
f = FileName(File)
s = "InputSheet"

Do

For c = 1 To 20
a = Cells(InputRow, c).address
Activesheet.Cells(OutputRow, c) = GetValue(p, f, s, a)
Next c

InputRow = InputRow + 1
If Not FileDone Then OutputRow = OutputRow + 1

Exit Do
Ignore = True
FileDone = True
Loop

End Functio

 

[Peter T]

I'm pretty sure not possible, if it is no doubt someone will come back and
demonstrate. The potential XLM to use would be GET.CELL() which can return a
variety of cell details and most formats. But it does not appear to work
with a closed workbook, either in VBA with ExecuteExcel4Macro or in a named
formula.

Regards,
Peter T