Macro to copy worksheet into a new workbook

Based upon the explanation you give, the first answer would be yes.
I understand that tailoring macros is not and easy job, especially if they're not your own.
You could record a macro and recreate the steps YOU want make.
After you stop the macro recorder you can open the VBA editor and see what it has been created.
Makes the macro easier to understand and then start practicing on writing and editing VBA code, it's the best way to learn, doing is learning.

We all learned that way, if you look at all vba tutorials they start in the same manner. record a macro and look at the created code.
If you have that code, then attach the file (with the code, non-private data please) and we can help you tailor, will make understanding VBA easier and then you won't have to depend on others

Thanks for your reply, Keebellah.

Taking heed of your advice I recorded the macro and changed a few things that seemed obviously not specific enough to work in the context I need it to. I've now run it and made a lot of progress,

so thanks a lot for your advice it really helped.

I may post some questions re. the code I come up with eventually, but in the meantime I've got a lot to go on and hone.

Thanks,

EDIT - It seems like I've hit a snag, it's very nearly there - WorksheetA from WorkbookA gets copied to WorkbookB when WorkbookA is saved, woo hoo!

However, when the code is run again I get worksheetA and worksheetA(2)

how do I get the code overwritten so there is only ever a WorksheetA?

here's the code:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Workbooks.Open Filename:="P:\B.xlsx"
Windows("A.xlsm").Activate
Sheets("worksheetA").Select
Sheets("worksheetA").Copy Before:=Workbooks("B.xlsx").Sheets(1)
ActiveWorkbook.Close savechanges:=True
End Sub

Hi Ben, use code tags when posting code.

Your example is good but since you do not overwrite the file it will have a worksshtA already there so Excel automatically adds the (20 for the new sheet.
This is the (my) solution

Bysetting display alerts to fals it will overwrite the existing file

Please Login or Register  to view this content.

Give it a run. you don't neet to select and all that just this

Do keep in mind that this worksheet is saved every time your file is saved (so when you close the file and say yes when prompted to save.
Caveat: hard-coding the path like you do P:\ means that anyone using this file must have access to a drive letter P: