Search & Extraction of Cells in a Workbook without opening it?

  • Thread starter Thread starter Joe HM
  • Start date Start date
J

Joe HM

Hello -

I currently have some macro code that opens multiple Excel Workbooks
and searches for certain values in cells. I use something like
Set lWorkbook = Workbooks.Open("X.xls")
to get access to the file.

What I was wondering is whether there is a way of doing that more
"silently" without the workbook window pop up every time a file is
opened. Is there any way to open an *.xls file and search through a
worksheet? Currently it locks up my computer when I run it and any
inadvertent key stroke might interfer with the macro running.

Thanks,
Joe
 
Hi Joe,

Try:

Application.ScreenUpdating = False

Set lWorkbook = Workbooks.Open("X.xls")
'Your processing code

Application.ScreenUpdating = True
 

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

Similar Threads

How to reference a cell from anther workbook without opening it 0
How to change a sheet name without opening the workbook 3
Copying cells and formula from closed workbook to all sheets in open workbook 0
Opening a list of Excel files and run a macro in each 17
Open Workbook to Specific Cell 5
VBA insert column with two workbooks open 1
Access Data from Workbook without seeing the workbook open. 1
values from workbook without opening it 5

Back
Top