Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA extraction of a part of the cells content | Excel Discussion (Misc queries) | |||
Automatically updating cells when opening workbook | Excel Discussion (Misc queries) | |||
Search Sample for Oracle-to-Excel extraction with CopyFromRecordset | Excel Discussion (Misc queries) | |||
selected extraction of cell ref in a series of cells in a row/colu | Excel Worksheet Functions | |||
data extraction / cleansing a string column in a workbook | Excel Programming |