Copy cells to specific file using open dialogue box.

I have a workbook called “cost8.9” which as a macro that copies various cells from a sheet called “VCS” & pastes them into another workbook called “Price Build Up” on the sheet called “PBU”. The following code allows this to happen:

Please Login or Register  to view this content.

What I now want is a code that opens the “Open As” dialogue box in a default file path location & when I choose a specific file I want it to paste the cells into the choosen file as the above code?

Hope that makes sense & someone can assist?
Thanks,

Tony.

Fantastic thanks

Could i just ask you when the VBA is run in both codes & i look at the workbook Price Build Up it shows the last sheet as default. I want it to show the first sheet i.e the one named PBU. Is this possible?

Thanks again,

Tony.

Thank you. I placed the PBwb.Sheets(1).activate as follows & it worked great.

Please Login or Register  to view this content.

Regarding the variable WasOpen i am not sure it may be from a previous version.

There will always be a sheet named VDS so we will be ok.

Thanks again.

Tony