Is it possible to hide a workbook while pulling data from it


S

sam

Hi All,

I know we have to open a workbook if we want to update it, but do we need to
open it even if we want to pull information from it? If yes.. Is there a way
to keep it hidden?
Is there a way to keep the workbook hidden while we update it or are pulling
data from it(to populate form fields in different workbook)?

Hope I am clear with my requirements

Thanks in advance
 
Ad

Advertisements

D

Dave Peterson

I bet if you use:

application.screenupdating = false
'open the sending workbook
'a bunch of code here
'close the sending workbook
application.screenupdating = true

You and your users would never know that it was being opened, inspected, and
closed.

=======

You could add formulas to empty cells to retrieve values from your sending
workbook.

=======

John Walkenbach has a routine that can get values from a closed workbook:
http://j-walk.com/ss/excel/eee/eee009.txt
Look for either: GetDataFromClosedFile or GetValue.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top