Copy sheet from closed Workbook to another workbook

[Kurt]

I am trying a new set of code:

Sub GetDataClosedBook()

Dim src As Workbook
'location of the file and data to copy

Set src = Workbooks.Open("C:\\Documents\Data Calc Formulas v 1.13b.xlsb", True, True)
'bring to this workbook

ThisWorkbook.Activate

Worksheets("RawData").Range("A1:S29,089").Formula = src.Worksheets("C:\Documents\Raw Reports - All Of Them - xxxx Copy.xlsx").Range("A1:C2").Formula

End Sub
'https://www.youtube.com/watch?v=5as4AfpqWBA

The code keeps stoping on the Set src = Workbooks line

Any Ideas?

 

[Yongle]

incorrect

Set src = Workbooks.Open("C:[COLOR=#ff0000]\\[/COLOR]Documents\Data Calc Formulas v 1.13b.xlsb", True, True)

correct

Set src = Workbooks.Open("C:[COLOR=#ff0000]\[/COLOR]Documents\Data Calc Formulas v 1.13b.xlsb", True, True)

 

[Kurt]

incorrect

Set src = Workbooks.Open("C:[COLOR=#ff0000]\\[/COLOR]Documents\Data Calc Formulas v 1.13b.xlsb", True, True)

correct

Set src = Workbooks.Open("C:[COLOR=#ff0000]\[/COLOR]Documents\Data Calc Formulas v 1.13b.xlsb", True, True)

I have already tried that! The code still stops!!

 

[Yongle]

What does the message box return when you run this?

Sub IsFileThere()
    Dim msg As String, fPath As String
    fPath = "C:\Documents\Data Calc Formulas v 1.13b.xlsb"

    If Dir(fPath, vbDirectory) = vbNullString Then msg = "NOT "
    MsgBox "File " & fPath & vbCr & msg & "FOUND"        
End Sub

 

[Kurt]

What does the message box return when you run this?

Sub IsFileThere()
    Dim msg As String, fPath As String
    fPath = "C:\Documents\Data Calc Formulas v 1.13b.xlsb"

    If Dir(fPath, vbDirectory) = vbNullString Then msg = "NOT "
    MsgBox "File " & fPath & vbCr & msg & "FOUND"        
End Sub

Thanks for this snippet of code Yongle.

I get the error message the file is not found!

I have tried several iterations of the file name path.

What else can I check for?

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...n-filename-error-post5211665.html#post5211665

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).