MrExcel Publishing
Your One Stop for Excel Tips & Solutions

similar to below but want to open a sheet with VBA

Posted by carlos on June 29, 2001 11:21 AM

i see the post below about saving 1 sheet from workbook. anyone know how to code a button to open another file and copy a specific sheet into the opened workbook with the button? thanks in advance!

Posted by Johan on June 30, 2001 7:37 PM

You should be able to create such a macro with the macro recorder.