Yes: you can automate a new Excel session from inside Excel VBA and open the
book in the new session, which will be hidden by default:
Dim NewXl As Excel.Application, NewBook as Workbook
Dim A1Val as Variant
Set NewXL = New Excel.Application
Set NewBook = XL.Workbooks.Open("FilePath")
A1Val = NewBook.Sheets(1).Range("A1").Value
....
NewBook.Close
NewXL.Quit
Set NewBook = Nothing
Set NewXL = Nothing
--
- K Dales


"Whitestar" wrote:


In vbscript it is possible to create a new Excel object, open a workbook
and get the value while keeping everything hidden (myXLApp.Visible =
False).

My question is: In VBA, is it possible to have a workbook open (and
visible) and then open another workbook and getting av value from it
without displaying it?

Say I have workbook A open and visible. I want to open workbook B, get
the value in cell A1 and close it without ever displaying it.

Thanks


--
Whitestar
------------------------------------------------------------------------
Whitestar's Profile: http://www.excelforum.com/member.php...o&userid=28253
View this thread: http://www.excelforum.com/showthread...hreadid=479820