Re: downloaded file from SAP can't open using VBA
yes correct, because I noticed when my sap download file path changed, my VBA, I got debug error in my default path, so I want dynamic.
Posts by sojohns
-
-
Re: downloaded file from SAP can't open using VBA
Quote from norie;791300Are 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 ~~