Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
Sub Save_SIF() Dim strFilePath, strFileName As String strFilePath = "C:\_SAP\GSA Extracts\GSA_SifFiles\" 'This needs to be changed to correct directory and must end with \ strFileName = InputBox("Please enter a filename or click OK to accept the default.", "Save File", _ "TestFile-" & Format(Now(), "yyyy-mm-dd")) '<--- change to new default If strFileName = "" Then Sheets("SIF Data").Select ActiveWindow.SelectedSheets.Visible = False Sheets("Order Line Items").Select ActiveWindow.SelectedSheets.Visible = False Exit Sub 'Will happen if Cancel is pressed End If strFileName = strFileName & ".sif" Application.DisplayAlerts = False ActiveSheet.Copy ActiveWorkbook.SaveAs Filename:= _ strFilePath & strFileName, FileFormat:=xlTextPrinter, CreateBackup:=False ActiveWorkbook.Close savechanges:=False Application.DisplayAlerts = True ' MsgBox "Sif file saved" End Sub
|Modified Max() formula depending on values in adjacent column in Excel||4||32|
|Excel 2013: Default workbook||13||27|
|Excel - Data Validation||3||26|
|Left trim cells in column A Excel vba||2||27|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!