Help needed in my VBA code SAP logon / SAP Scripting & Excel Interaction in VBA
Hi there, I have the following code: ‘ Function to read data from fileFunction GetDataFromFile(filePath)Dim ExcelAppDim WorkbookDim DataSheetDim DataRangeDim Data ‘ Create Excel objectSet ExcelApp = CreateObject(“Excel.Application”)ExcelApp.Visible = False ‘ Optional: Hide Excel application ‘ Open workbookSet Workbook = ExcelApp.Workbooks.Open(filePath) ‘ Assuming data is in the first sheet (Change if necessary)Set DataSheet = Workbook.Sheets(1) …
Help needed in my VBA code SAP logon / SAP Scripting & Excel Interaction in VBA Read More »