VBA variable save file as depending on folder path of another workbook

[Lefemmenikita]

Hi

I have a workbook template ('master workbook') where I want to create new workbook from using one of Master workbook's worksheets.

i.e. right clicking the tab called 'summary'(in Master workbook)> move or copy worksheet> create new workbook:

I want to save the newly created workbook in the same place as the original workbook(('Master Workbook') from which it originated using a macro.

Is there a variation of this code which I can use so that it points to wherever the Master workbook is saved, and save the newly created workbook in the same location?

Dim Masterwb As Workbook
Dim folderpath As String


folderpath = Application.[B]ActiveWorkbook[/B].Path

Thanks

 

[Fluff]

Try

Workbooks("Master Workbook").Path

 

[Lefemmenikita]

Thanks.

Just to clarify, where do I use that line of code?

Wouldn't I need to declare what ("Master Workbook") is (as an object?) elsewhere?

 

[Fluff]

Is the macro located in the Master Workbook?

 

[Lefemmenikita]

Yes, the macro is supposed to run from the ,master workbook

 

[Fluff]

In that case you can simply use

ThisWorkbook.path