Become an Σxpert at Σxcel.com

Standard VBA/Excel (40 of 1182)

	•	Compress Large Excel Workbooks
	•	Workbooks.Open
	•	ActiveWorkbook after opening an excel file
	•	Thisworkbook (xl reserved word)
	•	Activeworkbook.name
	•	Workbooks(thisworkbook.name).sheets("xxxx").Range("DER_cc") ' get the range name in another workbook
	•	ThisWorkbook.Sheets(....).Range(....) ' use when a different sheet is active
	•	ActiveWorkbook.Close False
	•	GettheVersion - opens workbook and finds the version and date by searching the sheet
	•	ActiveWorkbook.SaveAs sFile
	•	ActiveWorkbook.Worksheets("....").Autofilter.sort.sortfileds.clear ' clears a filters sorting ' recorded
	•	ThisWorkbook.Activate
	•	ActiveWorkbook.Save
	•	Open two workbooks and apply adjustments from one workbook to the other
	•	WorkBooks.Open sFileout, UpdateLinks:=False
	•	ActiveWorkbook.FullName
	•	ActiveWorkbook.SaveCopyAs sFile
	•	Thisworkbook.path
	•	LoadArray(workbookname, Sheetname, header) 🔝
	•	Run "Thisworkbook.WorkBook_Open"
	•	Workbooks(sWB).Close False
	•	ActiveWorkbook.RefreshAll
	•	ActiveSheet.Copy After:=Workbooks(sMainWBK).Sheets(Sheets.count)
	•	ActiveWorkbook.Names("dataset").RefersToR1C1 = "=cpt_input_data!R1C1:R40C13"
	•	Workbooks(sWBK).Sheets("CPR_LIst").Range("portfolio")
	•	set wb = ActiveWorkbook
	•	ActiveWorkbook.worksheets("sfile1").sort.sortfields.Add Key:=Range("N2"), SortOn:=xlSortOnValues, order:=xlAscending, DataOption=xlSortTextAsNumbers
	•	Workbook_open - event
	•	Workbook_close - event
	•	Get ini file - gsINIFile = Left(ThisWorkbook.Name, Len(ThisWorkbook.Name) - 4) & ".ini"
	•	WorkBook
	•	Workbooks Collection
	•	ThisWorkbook
	•	Using Multiple Workbooks
	•	This Workbook contains links to one or more external sources [update] [don't update]
	•	Hidden Workbook
	•	ActiveWindow.DisplayWorkbookTabs = True
	•	We can't update some of the links in your workbook right now ... [continue] [Edit Links...] dialog
	•	FindWorkbook(sWB) udf
	•	OpenExcelWorkbook(sFile)