Referring to a Workbook Using ThisWorkbook Dim wb As Workbook Set wb = ThisWorkbook wb.Close SaveChanges:=True
VIDEO TRAINING - LEARN AT YOUR OWN PACE
DEEP DIVE INTO LOOKUP FUNCTIONS - XLOOKUP, VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, IFERROR, ISNA, IFNA, LEFT, RIGHT, MID, FIND, SEARCH, LEN, SUBSTITUTE, REPLACE, TRIM, CLEAN & INDIRECT. Click here to enrol
THE MS ACCESS FOR BEGINNERS' COURSE - Click here to enrol
FREE STUFF
70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf
Open a Workbook Workbooks.Open Filename:="C:\Users\xxxx\Desktop\Finance.xlsx", ReadOnly:=True Close (and Save Changes to) a Previously Saved Workbook Workbooks("Finance.xlsx").Close SaveChanges:=True Close (and Save Changes to) to a New Workbook ActiveWorkbook.Close savechanges:=True,Filename:="C:\Users\xxxx\Desktop\Test.xlsx"
VIDEO TRAINING - LEARN AT YOUR OWN PACE
DEEP DIVE INTO LOOKUP FUNCTIONS - XLOOKUP, VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, IFERROR, ISNA, IFNA, LEFT, RIGHT, MID, FIND, SEARCH, LEN, SUBSTITUTE, REPLACE, TRIM, CLEAN & INDIRECT. Click here to enrol
THE MS ACCESS FOR BEGINNERS' COURSE - Click here to enrol
FREE STUFF
70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf
Save Workbook ActiveWorkbook.Save Performing a SaveAs…… Read More