With a saving variable in the name. ''Saves as created [Sales Order]_Lines.xslx need to chg? to .xml, needed? ''Save the downloaded file as a .xml and with the [SoLnNum]_Lines.xml 'myDirECTorY = "C:\_SAP\LynxFiles\" 'Wherever you want 'myFileNameO = myDirECTorY & [b]SalesOrderNum[/b] & "_Lines.xlsx" ' 'Workbooks.Add 'my need to remove this and make sure that Download.xml is active 'ActiveSheet.Paste 'May need to remove this too. ' 'ActiveWorkbook.SaveAs Filename:=myFileNameO, FileFormat:= _ ' xlOpenXMLWorkbook, CreateBackup:=False 'ActiveWorkbook.Close
From novice to tech pro — start learning today.