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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
windows.activatenext
Dim bk as Workbook
FileToOpen = Application.GetOpenFilename("Excel File (*.xls), *.xls", , "Select Your File", , False) workbooks.Open FileToOpen set bk = ActiveWorkbook copy a range in the newly open book bk.Activate -- Regards, Tom Ogilvy "Bonzo123" wrote in message ... 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.activatenext does not work for me as the user may have other workbooks open and VB MAY activate the wrong book Any tricks will be appreciated -- Bonzo123 ------------------------------------------------------------------------ Bonzo123's Profile: http://www.excelforum.com/member.php...o&userid=24182 View this thread: http://www.excelforum.com/showthread...hreadid=398142 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
windows.activatenext
Thanks Tom. Regards Brian -- Bonzo123 ------------------------------------------------------------------------ Bonzo123's Profile: http://www.excelforum.com/member.php...o&userid=24182 View this thread: http://www.excelforum.com/showthread...hreadid=398142 |
Reply |
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 |