| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use Array to activate workbooks
The following code works fine, in a situation where the workbooks
are originally opened, worked on, and then closed. FilesArray holds the names of the previously opened workbooks, and can be used again to open the books: If FileCounter 0 Then Application.ScreenUpdating = False For LoopCounter = 1 To FileCounter Workbooks.Open vFilename & FilesArray(LoopCounter), False In a slightly different situation, the books are still open. Can I modify the code and use FilesArray to activate them in turn? What I'd like to say, is: Workbooks.Activate vFilename & FilesArray(LoopCounter), False but that is not supported (Excel2000). Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.545 / Virus Database: 339 - Release Date: 27/11/2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| How do I activate the xls feature to combine and compare workbooks | Setting up and Configuration of Excel | |||
| Workbooks(WorkbookName).Activate Failure | Charts and Charting in Excel | |||
| how do I activate links without opening external workbooks? | Excel Discussion (Misc queries) | |||
![Stuart[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
