Link to home
Get AccessLog in
Avatar of montrof
montrofFlag for United States of America

asked on

Excel vba move tabs to new workbook

Hi experts,

I need some help with some vba to move three worksheets("Example1", "Example2", "Example3") from one workbook to a new workbook and then save the new workbook in the same directory as the current one.  The name of the new file will be coming from the worksheet named summary and the name of the file will be in cell a1.

Thank you ,
Montrof
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of montrof

ASKER

Great job, thank you

Montrof