Thread: Open book as hidden and getting value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Whitestar[_3_] Whitestar[_3_] is offline
external usenet poster
  
Posts: 1
Default Open book as hidden and getting value

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

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

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

Thank

--
Whitesta
-----------------------------------------------------------------------
Whitestar's Profile: http://www.excelforum.com/member.php...fo&userid=2825
View this thread: http://www.excelforum.com/showthread.php?threadid=47982

Reply With QuoteReply With Quote