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
    Sheets("Sheet1").Select
    ActiveSheet.Copy After:=Workbooks("Raw.xlsm").Sheets("existingRaw") ' ~~ This is file and sheet name ~~