| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Focusing on open workbooks
how can I focus on a specified open workbook? I have written some code that opens 10 of them. I need to then select each one in turn to copy a range of data an paste it to another sheet. I just cant seem to work out how to select a workbook.. -- matp ----------------------------------------------------------------------- matpj's Profile: http://www.excelforum.com/member.php...fo&userid=2107 View this thread: http://www.excelforum.com/showthread.php?threadid=48099 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I open Excel, workbooks open automatically. How can I stop t | Excel Discussion (Misc queries) | |||
| Focusing on open workbooks | Excel Programming | |||
| Problem with focusing on Application.Inputbox type:= 8 | Excel Programming | |||
| Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming | |||
| SendKeys command not focusing on the correct open program | Excel Programming | |||
![matpj[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
