Posts by sojohns

    Re: downloaded file from SAP can't open using VBA

    Quote from norie;791300

    Are you sure the file is being downloaded to the directory where the Excel application is stored?

    yup, if I used default path Workbooks.Open "C:\Next\forward\folder\name\BT.XLSX", my file open auto and transfer to my main file

    Data from SAP.

    The objective open the excel data and copy to my main excel

    MyPath = Application.Path & "" & "BT.xlsx

    Workbooks("BT.xlsx").Activate <---- U got debug issue can't find the path
    ActiveSheet.Copy After:=Workbooks("Raw.xlsm").Sheets("existingRaw") ' ~~ This is file and sheet name ~~