| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
windows.activatenext
YYY = activeworkbookname I then open a workbook with FileToOpen = Application.GetOpenFilename("Excel File (*.xls), *.xls", "Select Your File", , False) copy a range in the newly open book activate the workbook called YYY (activeworkbookname) and paste I now need to reopen the "FileToOpen" book. The windows.activatenex does not work for me as the user may have other workbooks open and V MAY activate the wrong book Any tricks will be appreciate -- Bonzo12 ----------------------------------------------------------------------- Bonzo123's Profile: http://www.excelforum.com/member.php...fo&userid=2418 View this thread: http://www.excelforum.com/showthread.php?threadid=39814 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i want all windows in one excel frame (windows in taskbar) | Excel Discussion (Misc queries) | |||
| cannot open exel from windows xp in windows vista and visa versa | New Users to Excel | |||
| can windows vista edit shared document from windows xp | Excel Worksheet Functions | |||
| Page breaks are different in Windows 2000 and Windows XP | Excel Discussion (Misc queries) | |||
| Use Windows Script to run Windows Explorer Search? | Excel Programming | |||
Threaded Mode
