Saving & Opening Problem

Good Afternoon All

I have the following problem

I would like to open File A save it as File B (this name is a variable and based on a cell value)

Then close File B and reopen File A

I have tried the following but with no joy as yet

Either it closes File B and doesn't finish the code off a s the file is closed
or
it saves it as File B and opens File A and then closes it again as its the active workbook

Please Login or Register  to view this content.

I would very much appreciate some guidance on this matter urgently as I am getting frustrated :-(

Thanks in advance

I have no idea what a logic macro is or how to share the files?

The user opens the File A without using VBA, adds some data and then the VBA saves the file as File B but I want File B to be closed and File to remain open as this is a Master Template

does this make it clearer

ThisWorkbook.SaveCopyAs - does not do as I want

thanks

Parth007 you solution would do as I require but sadly I don't know where to start and don't require anything to complicated

I have solved the problem with the following code myself (prob not the best solution)

Please Login or Register  to view this content.

any improvements much appreciated