ExcelBanter - Making an open workbook active

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Making an open workbook active (https://www.excelbanter.com/excel-programming/325781-making-open-workbook-active.html)

Jay Oken

Making an open workbook active

What is the VBA code for making an open workbook the active workbook.

Thanks.
J

Dave Peterson[_5_]

Making an open workbook active

workbooks("myworkbook.xls").activate

is one way.

Jay Oken wrote:

What is the VBA code for making an open workbook the active workbook.

Thanks.
J

--

Dave Peterson

All times are GMT +1. The time now is 03:35 AM.