Help with copying Sheet from One workbook into another workbook

P

ppds737

I have one excel file named Test1.xlsx with sheet named "List". I want to copy the sheet List into another file called Test2.xlsx. Both files are existing. I also want to delete the Sheet "List" in Test2.xlsx before copying.. Finally I want to save and close both the files.

I am new to Excel VBA.
I would appreciate if anybody can help me in showing how this can be done in Excel VBA 2013.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with copying a sheet from One workbook to another workbook 1
Save workbook without shapes 0
Working outlook via vba code with xlsx - error 0
Autonumber field in Excel that behaves the same as Access 0
Apply Excel Macros to another open file 1
Update cell links between 2 excel file without opening source file 0
move worksheet to end of another workbook 7
Email Mail Merge via linked Excel sheet 0

Top