Moving worksheet with charts to new workbook - VBA

[kalcerro_1]

Hello All,
I have this workbook, which is a xlsm, I will call it "A"
There is a sheet in this that summarize in 6 charts all the information of the WB "A". 6 charts are being populated by another sheet where all formulas are stored.
I'm trying to move this worksheet to a new workbook "B" (where all chart worksheets will be stored), and it works good, but when I close the new workbook "B", and re-open it again, excel asks me to update the link to the data, I do Update but just 3 charts are present. All 6 charts have the same sheet where data is stored to populate them.
I want to know if it's possible to move the chart without the data source to populate them.

This is the simple code I'm using now:

Private Sub CommandButton1_Click()
 
 Dim FileToImport As Variant
    FileToImport = Application.GetOpenFilename(FileFilter:="XLSM's  (*.xlsm), *.xlsm", Title:="Select Partner Result to import")
        If FileToImport = False Then Exit Sub
    MsgBox "This process will take a few seconds, please wait", vbOKOnly

Workbooks.Open FileToImport

Sheets("6.Results").Select
Sheets("6.Results").Copy after:=ThisWorkbook.Sheets(1)
Sheets("6.Results").Select
Sheets("6.Results").Name = ActiveSheet.Range("b4")

End Sub

 

[Zot]

Maybe this will help?

Macro to copy chart from one workbook to another,

Is it possible to get a macro to copy a chart from open workbook called master into current workbook current tab and set chart data to the formula name tonytest?

www.mrexcel.com